public IHttpActionResult PutuserMaster(int id, userMaster userMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != userMaster.userId) { return(BadRequest()); } db.Entry(userMaster).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!userMasterExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Register(userMaster obj) { try { if (ModelState.IsValid) { //string vPassword = CommonMethods.Encrypt(obj.PASSWORD); //string vSvrKey = CommonMethods.Encrypt(DateTime.Now.Date.ToString(), "BICPRO"); //obj.PASSWORD = vPassword; obj.SVRKEY = "abcd"; obj.ISADMIN = true; objRes = obj.Save(obj, 0); if (objRes.ResultId > 0) { return(RedirectToAction("Login", "Account")); } else { ModelState.AddModelError("ErrorMgr", objRes.Message); } } } catch (Exception ex) { throw ex; } return(View(obj)); }
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"); * } * */ }
//Method for Updating Employee record public int Update(userMaster user) { int i; using (SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True")) { con.Open(); SqlCommand com = new SqlCommand("InsertUpdateUser", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@userID", user.userId); com.Parameters.AddWithValue("@firstName", user.firstName); com.Parameters.AddWithValue("@lastName", user.lastName); com.Parameters.AddWithValue("@dob", user.dob); com.Parameters.AddWithValue("@gender", user.gender); com.Parameters.AddWithValue("@address", user.address); com.Parameters.AddWithValue("@city", user.city); com.Parameters.AddWithValue("@state", user.state); com.Parameters.AddWithValue("@countryId", user.countryId); com.Parameters.AddWithValue("@contactNo", user.contactNo); com.Parameters.AddWithValue("@emailID", user.emailID); com.Parameters.AddWithValue("@password", user.password); com.Parameters.AddWithValue("@Action", "Update"); i = com.ExecuteNonQuery(); } return(i); }
public IHttpActionResult GetuserMaster(int id) { userMaster userMaster = db.userMasters.Find(id); if (userMaster == null) { return(NotFound()); } return(Ok(userMaster)); }
public IHttpActionResult PostuserMaster(userMaster userMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.userMasters.Add(userMaster); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = userMaster.userId }, userMaster)); }
public ActionResult Dashboard() { userMaster u = new userMaster(); clientMaster c = new clientMaster(); domainMaster d = new domainMaster(); ViewBag.usertotal = db.userMasters.Count(); ViewBag.domaintotal = db.domainMasters.Count(); var count = db.clientMasters.Select(p => p.companyName).Distinct().Count(); ViewBag.companyNametotal = count; return(View()); }
public IHttpActionResult DeleteuserMaster(int id) { userMaster userMaster = db.userMasters.Find(id); if (userMaster == null) { return(NotFound()); } db.userMasters.Remove(userMaster); db.SaveChanges(); return(Ok(userMaster)); }
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 JsonResult Update(userMaster ur) { return(Json(user.Update(ur), JsonRequestBehavior.AllowGet)); }