using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.Odbc;

namespace UACSEmployee

{

/// <summary>

/// Summary description for GetEmployee.

/// </summary>

public class GetEmployee : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid DataGrid1;

protected System.Web.UI.WebControls.TextBox TextBoxFirstName;

protected System.Web.UI.WebControls.TextBox TextBoxLastName;

private string mFirstName;

private string mLastName;

private int mNumRows;

protected System.Web.UI.WebControls.Button ExecuteButton;

protected System.Web.UI.WebControls.Button ResetButton;

protected System.Web.UI.WebControls.Panel ResultsPanel;

protected System.Web.UI.WebControls.Label NumRowsLabel;

protected System.Web.UI.WebControls.Label FirstNameLabel;

protected System.Web.UI.WebControls.Label LastNameLabel;

protected System.Web.UI.WebControls.Image UAImage;

private OdbcConnection mConn;

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.ExecuteButton.Click += new System.EventHandler(this.ExecuteButton_Click);

this.ResetButton.Click += new System.EventHandler(this.ResetButton_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void ExecuteButton_Click(object sender, System.EventArgs e)

{

ResultsPanel.Visible = true;

mFirstName = TextBoxFirstName.Text;

mLastName = this.TextBoxLastName.Text;

try

{

mConn = new OdbcConnection("DSN=webuacs;UID=bluefish;PWD=111111;");

mConn.ConnectionTimeout = 60;

mConn.Open();

OdbcCommand commandHandle = new OdbcCommand( "{call get_employee(?,?)}", mConn);

commandHandle.CommandType = CommandType.StoredProcedure;

OdbcParameterCollection paramHandle = commandHandle.Parameters;

OdbcParameter firstNameParameter = paramHandle.Add("@firstname", OdbcType.VarChar);

firstNameParameter.Value = mFirstName;

OdbcParameter lastNameParameter = paramHandle.Add("@lastname", OdbcType.VarChar);

lastNameParameter.Value = mLastName;

OdbcDataAdapter resultDA = new OdbcDataAdapter( commandHandle );

resultDA.MissingSchemaAction = MissingSchemaAction.AddWithKey;

DataSet resultDS = new DataSet();

resultDA.Fill(resultDS, "Employee");

DataGrid1.DataSource = resultDS.Tables["Employee"];

DataGrid1.DataBind();

DataGrid1.Visible = true;

mNumRows = DataGrid1.Items.Count;

this.NumRowsLabel.Text = mNumRows.ToString();

this.FirstNameLabel.Text = mFirstName.ToString();

this.LastNameLabel.Text = mLastName.ToString();

}

catch(OdbcException ex)

{

Response.Write(ex.Message);

}

finally

{

mConn.Close();

}

}

private void ResetButton_Click(object sender, System.EventArgs e)

{

ResultsPanel.Visible = false;

TextBoxFirstName.Text = "%";

TextBoxLastName.Text = "%";

}

}

}