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;
}
}
