protected void btnInsert_Click(object sender, EventArgs e) { using (var obj = new OntologyDataContext()) { var per = new tblPerson(); per.Category = Convert.ToInt32(RadioButtonList1.SelectedValue); per.HostName = txtHost.Text; per.IPAddress = txtIP.Text; obj.tblPersons.InsertOnSubmit(per); obj.SubmitChanges(); } }
protected void btnLogin_Click(object sender, EventArgs e) { using (var obj = new OntologyDataContext()) { if (OntologyHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text && a.Password == txtPassword.Text) > 0) { Session["UserName"] = txtUsername.Text; Response.Redirect("Home.aspx"); } else { Label1.Text = "Incorrect username or password"; } } }
protected void btnRegister_Click(object sender, EventArgs e) { using (var obj = new OntologyDataContext()) { if (OntologyHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text) > 0) { lblError.Text = "User Name already exists"; } else { var user = new tblUser(); user.Date = DateTime.Now; user.MailId = txtMailId.Text; user.MobileNumber = Convert.ToInt64(txtMobileNumber.Text); user.Password = txtPassword.Text; user.UserName = txtUsername.Text; obj.tblUsers.InsertOnSubmit(user); obj.SubmitChanges(); Session["UserName"] = txtUsername.Text; Response.Redirect("Home.aspx"); } } }