protected void Page_Load(object sender, EventArgs e)
{
// get userName stored in session
string userName = (string)Session["UserName"];
User.Text = userName;
clientID = Request.QueryString["clientID"];
// access to DB and pass Client ID as a parameter
// var db = new DataAccess();
WebFormsTraining.ServiceReference2.WebServiceDBSoapClient webService2Db = new ServiceReference2.WebServiceDBSoapClient();
bool isAccountBasedSearch = false;
DataTable dt = webService2Db.Get(clientID, isAccountBasedSearch);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
clientDetailsLabel.Text = "No Record Found";
}
// this is not needed anymore
// string language = Request.QueryString["language"];
// clientDetailsLabel.Text = "Client ID: " + clientID + "|| Selected Language:" + language;
}
protected void Page_Load(object sender, EventArgs e)
{
string userName = (string)Session["UserName"];
User.Text = userName;
accNmb = Request.QueryString["AccountNumber"];
if (accNmb != null)
{
bool isAccountBasedSearch = true;
AccNumber.Attributes.Add("ReadOnly", "ReadOnly");
AccNumber.BorderStyle = BorderStyle.None;
AccType.Attributes.Add("ReadOnly", "ReadOnly");
AccType.BorderStyle = BorderStyle.None;
AccLanguage.Attributes.Add("ReadOnly", "ReadOnly");
AccLanguage.BorderStyle = BorderStyle.None;
AccBalance.Attributes.Add("ReadOnly", "ReadOnly");
AccBalance.BorderStyle = BorderStyle.None;
ClientId.Attributes.Add("ReadOnly", "ReadOnly");
ClientId.BorderStyle = BorderStyle.None;
createAcc.Visible = false;
WebFormsTraining.ServiceReference2.WebServiceDBSoapClient webService2 = new ServiceReference2.WebServiceDBSoapClient();
DataTable dt = webService2.Get(accNmb, isAccountBasedSearch);
AccNumber.Text = dt.Rows[0][0].ToString();
AccType.Text = dt.Rows[0][1].ToString();
AccLanguage.Text = dt.Rows[0][2].ToString();
AccBalance.Text = dt.Rows[0][3].ToString();
ClientId.Text = dt.Rows[0][4].ToString();
}
}
protected void CreateAcc_Click(object sender, EventArgs e)
{
ServiceReference2.WebServiceDBSoapClient webService2 = new ServiceReference2.WebServiceDBSoapClient();
var insertError = webService2.Insert(AccNumber.Text, AccType.Text, AccLanguage.Text, AccBalance.Text, ClientId.Text);
if (insertError == 1)
{
errorLabel.Attributes.Add("style", "color:Red;");
errorLabel.Text = "Some error happened during the insertion to database!";
}
if (insertError == 2)
{
errorLabel.Attributes.Add("style", "color:Red;");
errorLabel.Text = "Please fill out all of the fields and use valid values!";
}
else
{
Response.Redirect("Client.aspx?clientID=" + ClientId.Text);
}
}
