private int CheckLoginCredentials(string userid, string password)
{
try
{
ProcessQuery process = new ProcessQuery();
UserDetails = process.ExecuteDataSet(QueryBank.CheckLoginCreds(userid, password));
if (UserDetails == null)
return -1;
else if (UserDetails.Rows.Count == 0)
return 0;
else return 1;
}
catch (Exception) { return -1; }
}
protected void Submit_Click(object sender, EventArgs e)
{
string Name = TxtName.Text;
string EmpNo = Session["USERID"].ToString();
string Email = TxtEmail.Text;
string MobileNo = TxtMobile.Text;
string Password = TxtPass1.Text;
if (Password.Equals("a") || String.IsNullOrEmpty(Password))
{
Password = Session["PASSWORD"].ToString();
}
ProcessQuery process = new ProcessQuery();
try
{
int result = process.ExecuteUpdate(QueryBank.EditUserDetails(Name, EmpNo, Password, MobileNo, Email));
if (result <= 0)
LblStatus.Text = "Updation Failed. Contact The Administrator";
else
LblStatus.Text = "Updation Successful";
}
catch (Exception) { LblStatus.Text = "Validation Failed"; }
}
protected void Register_Click(object sender, ImageClickEventArgs e)
{
string Name = TxtName.Text;
string EmpNo = TxtEmpNo.Text;
string Email = TxtEmail.Text;
string MobileNo = TxtMobile.Text;
string Password = TxtPass1.Text;
ProcessQuery process = new ProcessQuery();
try
{
int result = process.ExecuteUpdate(QueryBank.RegisterNewUser(Name, EmpNo, Password, MobileNo, Email));
if (result <= 0)
LblStatus.Text = "Registration Failed. Contact The Administrator";
else
LblStatus.Text = "Registration Successful. Goto Login Page to Log in";
}
catch (OleDbException error)
{
if (error.Message.Contains("ORA-00001"))
LblStatus.Text = "You are already registered.";
else
LblStatus.Text = "Registration Failed. Contact The Administrator";
}
}
