public ActionResult PoliceCreate(tblreg re) { int model = de.tbllogins.Where(a => a.username == re.username).Count(); ViewBag.dist = de.tbldistricts.ToList(); ViewBag.cit = de.tblcities.ToList(); if (model == 0) { if (ModelState.IsValid) { tbllogin log = new tbllogin(); log.username = re.username; log.password = re.password; log.roleid = 3; log.isdeleted = false; log.status = false; de.tbllogins.Add(log); de.SaveChanges(); re.loginid = de.tbllogins.Max(a => a.loginid); de.tblregs.Add(re); de.SaveChanges(); } } else { TempData["dataalready"] = "Police user is already registered"; } return(RedirectToAction("../Home/Index")); }
public ActionResult UpdateEditPro(tblreg re) { tbllogin lg = de.tbllogins.Where(a => a.loginid == re.loginid).SingleOrDefault(); lg.username = re.username; lg.password = re.password; de.SaveChanges(); tblreg reg = de.tblregs.Where(a => a.regid == re.regid).SingleOrDefault(); reg.email = re.email; reg.address = re.address; reg.districtid = re.districtid; reg.cityid = re.cityid; de.SaveChanges(); return(Json(new { result = true, message = "Data Updated Succesfully." }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// code for denying users /// </summary> /// <param name="ids"></param> public static int denyingusers(int ids) { try { using (var objdata = new HavanadataclassesDataContext()) { tblreg reg = objdata.tblregs.Where(x => x.Id == ids).FirstOrDefault(); if (reg != null) { reg.IsVerified = false; } objdata.SubmitChanges(); return(1); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Code for User registration /// </summary> /// <param name="reg"></param> /// <returns></returns> public static int userregistration(tblreg reg) { try { using (var objdata = new HavanadataclassesDataContext()) { reg.Crdt = DateTime.Now; reg.Updt = DateTime.Now; reg.IsActive = false; reg.IsVerified = false; objdata.tblregs.InsertOnSubmit(reg); objdata.SubmitChanges(); return(1); } } catch (Exception ex) { throw ex; } }
/// <summary> /// code to change password on mail.... /// </summary> /// <param name="ids"></param> /// <param name="password"></param> /// <returns></returns> public static int PasswordChangeOnEmail(string mail, string password) { try { using (var objdata = new HavanadataclassesDataContext()) { tblreg reg = objdata.tblregs.Where(x => x.Email == mail).FirstOrDefault(); if (reg != null) { reg.Password = password; } objdata.SubmitChanges(); return(1); } } catch (Exception ex) { throw ex; } }