protected void btnLogin_Click(object sender, EventArgs e)
{
objAdminUser = new clsAdminUser();
try
{
bool ans;
ans = objAdminUser.UserLogin(txtemail.Text, txtPassword.Text);
if (ans == true)
{
// objAdminUser = objAdminUser.GetData(txtemail.Text);
/* Session["email"] = objAdminUser.Email;
* Session["fullname"] = objAdminUser.FullName;
* Session["usertype"] = objAdminUser.UserType;*/
Response.Redirect("Home.aspx");
}
else
{
Alert.Visible = true;
}
}
catch (Exception x)
{
Response.Write(x.Message);
}
}
public void UpdateData(clsAdminUser objAdminUser, string em)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "UPDATE Adminusers set Email=@Email,Password=@Password,FullName=@FullName,Mobile=@Mobile,UserType=@UserType,Status=@Status where Email=" + em;
cmd.Parameters.AddWithValue("@Email", objAdminUser.Email);
cmd.Parameters.AddWithValue("@Password", objAdminUser.Password);
cmd.Parameters.AddWithValue("@FullName", objAdminUser.FullName);
cmd.Parameters.AddWithValue("@Mobile", objAdminUser.Mobile);
cmd.Parameters.AddWithValue("@UserType", objAdminUser.UserType);
cmd.Parameters.AddWithValue("@Status", objAdminUser.Status);
myDB.Execute(sSQL, cmd);
}
public void InsertData(clsAdminUser objAdminUser)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "INSERT into Adminusers(Email,Password,FullName,Mobile,UserType,Status)values (@Email,@Password,@FullName,@Mobile,@UserType,@Status)";
cmd.Parameters.AddWithValue("@Email", objAdminUser.Email);
cmd.Parameters.AddWithValue("@Password", objAdminUser.Password);
cmd.Parameters.AddWithValue("@FullName", objAdminUser.FullName);
cmd.Parameters.AddWithValue("@Mobile", objAdminUser.Mobile);
cmd.Parameters.AddWithValue("@UserType", objAdminUser.UserType);
cmd.Parameters.AddWithValue("@Status", objAdminUser.Status);
myDB.Execute(sSQL, cmd);
}
public clsAdminUser GetData(string em)
{
clsAdminUser objAdminUser;
myDB = new DBHelper();
objAdminUser = new clsAdminUser();
sSQL = objAdminUser.DispDataCode(em);
SqlDataReader sDr = myDB.GetFromReader(sSQL);
sDr.Read();
if (sDr.HasRows)
{
objAdminUser.Email = sDr["Email"].ToString();
objAdminUser.Password = sDr["Password"].ToString();
objAdminUser.FullName = sDr["FullName"].ToString();
objAdminUser.Mobile = sDr["Mobile"].ToString();
objAdminUser.UserType = sDr["UserType"].ToString();
objAdminUser.Status = sDr["Status"].ToString();
}
return(objAdminUser);
}
protected void btnsignup_Click(object sender, EventArgs e)
{
objAdminUser = new clsAdminUser();
try
{
bool ans;
objAdminUser.Password = txtpswd.Text;
objAdminUser.FullName = txtfname.Text;
objAdminUser.Email = txtemail.Text;
objAdminUser.UserType = utype.Text;
if (chkStatus.Checked == true)
{
objAdminUser.Status = "Active";
}
else
{
objAdminUser.Status = "Inactive";
}
objAdminUser.Mobile = txtmno.Text;
ans = objAdminUser.CheckUser(txtemail.Text);
if (ans == true)
{
Alert.Visible = true;
return;
}
else
{
objAdminUser.InsertData(objAdminUser);
}
}
catch (Exception x)
{
Response.Write(x.Message);
}
}
