protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
LabelResult.Visible = false;
using (var myDB = new c382atsEntities())
{
TblUser loginuser = (from u in myDB.TblUsers
where u.email == TextBoxEmail.Text &&
u.pass == TextBoxPass.Text && u.isActive == true
select u).SingleOrDefault();
if (loginuser != null)
{
Session["user"] = loginuser;
Response.Redirect("Default");
}
else
{
LabelResult.Text = "Wrong!!!";
LabelResult.Visible = true;
}
}
}
catch (Exception)
{
throw;
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
using (var myDB = new c382atsEntities())
{
var checkuser = (from u in myDB.TblUsers
where u.email == TextBoxEmail.Text
select u).SingleOrDefault();
if (checkuser == null)
{
LabelError.Visible = false;
var newuser = new TblUser();
newuser.title = DDLTitle.SelectedItem.Text;
newuser.fname = TextBoxFname.Text;
newuser.lname = TextBoxLastName.Text;
newuser.email = TextBoxEmail.Text;
newuser.pass = TextBoxPass.Text;
newuser.timestamp = DateTime.Now;
newuser.isActive = true;
newuser.isAdmin = false;
myDB.TblUsers.Add(newuser);
myDB.SaveChanges();
LabelError.Visible = false;
Response.Redirect("Login");
}
else
{
LabelError.Visible = true;
}
}
}
catch (Exception)
{
LabelException.Visible = true;
throw;
}
}
