protected void LoginUser_Click(object sender, EventArgs e)
{
Registrations registrationObj = new Registrations();
string Pass = registrationObj.encryptpass(Password.Text);
GenerateQuery QueryObj = new GenerateQuery();
string[,] ReplaceValues = new string[2, 2];
ReplaceValues[0, 0] = "_UserName_";
ReplaceValues[0, 1] = UserName.Text;
ReplaceValues[1, 0] = "_Password_";
ReplaceValues[1, 1] = Password.Text;
long UserId = 0;
string User = "";
Registration registration = null;
string Query = QueryObj.GetQueryViaFileAndTagName("LogIn.xml", "ValidUserOrNot");
Query = Query.Replace("_UserName_", UserName.Text.ToString());
Query = Query.Replace("_Password_", Password.Text.ToString());
if (Query != "")
{
UserId = QueryObj.GetSingleNumericValueViaQuery(Query, ReplaceValues, Connection);
User = QueryObj.GetSingleStringValueViaQuery(Query, ReplaceValues, Connection);
if (UserId > 0)
{
Response.Redirect("ListPage.aspx?UserId=" + UserId);
}
else
{
UserName.Text = "";
Password.Text = "";
Label1.Text = "Enter User Name And Password is incurrect please try again.";
}
}
if (Query != "")
{
registration = QueryObj.GetCollectionOfDataViaQuery(Query);
DataTable DataTableObj = new DataTable("DataTable");
DataTableObj = QueryObj.GetCollectionOfDataSetViaQuery(Query);
if (DataTableObj != null)
{
//Data Set havinf data now retrive it to its sutiable properties
}
}
if (Query != "")
{
registration = QueryObj.GetCollectionSearchDataViaQuery(Query, ReplaceValues, null, null, "", registration);
}
}