public ActionResult editUser(userMaster ur) { if (ModelState.IsValid) { using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) { if (ur.userId > 0) { var v = db.userMasters.Where(a => a.userId == ur.userId).FirstOrDefault(); if (v != null) { v.firstName = ur.firstName; v.lastName = ur.lastName; v.dob = ur.dob; v.gender = ur.gender; v.address = ur.address; v.city = ur.city; v.state = ur.state; v.countryId = ur.countryId; v.contactNo = ur.contactNo; v.emailID = ur.emailID; db.SubmitChanges(); } } else { } db.SubmitChanges(); } } return(View()); }
public ActionResult addUser(userMaster ur) { if (!ModelState.IsValid) { ViewBag.error = "Invalid Request"; return(View(ur)); } OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"); userMaster um = new userMaster(); um.firstName = ur.firstName; um.lastName = ur.lastName; um.dob = ur.dob; um.gender = ur.gender; um.address = ur.address; um.city = ur.city; um.state = ur.state; um.countryId = ur.countryId; um.contactNo = ur.contactNo; um.emailID = ur.emailID; um.password = ur.password; db.userMasters.InsertOnSubmit(um); db.SubmitChanges(); ViewBag.success = "Successfully Added New User"; return(View()); }
public ActionResult delteUser(int id, userMaster ur) { using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) { userMaster v = db.userMasters.Where(x => x.userId == ur.userId).Single <userMaster>(); db.userMasters.DeleteOnSubmit(ur); db.SubmitChanges(); return(RedirectToAction("Index", "ManageUser")); } /* using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) * { * var v = db.userMasters.Where(a => a.userId == id).FirstOrDefault(); * if (v != null) * { * * db.userMasters.DeleteOnSubmit(v); * db.SubmitChanges(); * RedirectToAction("Index"); * } * else * { * return View("deleteUser"); * } * */ }
// GET: ManageUser public ActionResult Index() { OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"); var user = db.userMasters.OrderBy(emp => emp.firstName).ToList(); return(View(user)); }
public ActionResult editUser(int id) { using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) { var v = db.userMasters.Where(a => a.userId == id).FirstOrDefault(); return(View(v)); } }
public ActionResult deleteUser(int id) { using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) { userMaster user = db.userMasters.Where(a => a.userId == id).FirstOrDefault(); if (user != null) { return(View(user)); } else { return(HttpNotFound()); } } }
public ActionResult Login(string txtEmail, string txtPassword) { /*if (txtEmail == "admin" && txtPassword == "admin") * { * * * if (txtEmail != null && txtPassword != null) * { * ViewBag.user = "******"; * return RedirectToAction("Dashboard", "Home"); * } * else * { * ViewBag.message = "Invalid Username and Password"; * return View("Login"); * } * } * else * {*/ OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"); var loginresult = db.userMasters.Where(a => a.emailID == txtEmail && a.password == txtPassword).FirstOrDefault(); if (loginresult != null) { Session["UserProfile"] = loginresult; ViewBag.user = "******"; return(RedirectToAction("Dashboard", "Home")); } else { ViewBag.message = "Invalid Username and Password"; return(View("Login")); } //} //return Json("Invalid Data",JsonRequestBehavior.AllowGet); }