protected void ButtonLogin_Click(object sender, EventArgs e)
{
System.Data.DataView dv;
SDS_Customer.Select(DataSourceSelectArguments.Empty);
dv = (System.Data.DataView)SDS_Customer.Select(DataSourceSelectArguments.Empty);
System.Data.DataRow dr;
dr = dv.Table.Rows[0];
// go back SDS look SQL for array index values
// match db email and password to form email and password
if (dr.ItemArray[1].ToString().ToLower().Equals(TextBoxEmail.Text) &&
dr.ItemArray[2].ToString().ToLower().Equals(TextBoxPassword.Text))
{
Session["CustomerID"] = dr.ItemArray[0];
LabelMessage.Text = "Welcome back " + dr.ItemArray[0].ToString();
if (CheckBoxRemember.Checked)
{
SetCookie();
}
ButtonContinue.Visible = true;
}
else
{
LabelMessage.Text = "Login not found!";
ButtonContinue.Visible = false;
}
}
protected void Select_Customer()
{
System.Data.DataView dv;
SDS_Customer.Select(DataSourceSelectArguments.Empty);
dv = (System.Data.DataView)SDS_Customer.Select(DataSourceSelectArguments.Empty);
System.Data.DataRow dr;
dr = dv.Table.Rows[0];
//could textbox email - just try to showcase session variables
/*if (dr.ItemArray[6].ToString().ToLower().Equals(Session["EmailAddress"].ToString().ToLower()))*/
Session["CustomerID"] = dr.ItemArray[0];
}