public ActionResult Edit(User user) { if (ModelState.IsValid) { if (user.PhotoFile != null) { var folder = "~/Content/Users"; var pic = string.Empty; var file = string.Format("{0}.jpg", user.UserId); var response = FilesHelper.UploadPhoto(user.PhotoFile, folder, file); if (response) { pic = string.Format("{0}/{1}.jpg", folder, file); user.Photo = pic; } } var db2 = new KissiContext(); var currentUser = db2.Users.Find(user.UserId); if (currentUser.UserName != user.UserName) { UsersHelper.UpdateUserName(currentUser.UserName, user.UserName); } db2.Dispose(); db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CityId = new SelectList(CombosHelper.GetCities(user.DepartmentId), "CityId", "Name", user.CityId); ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", user.CompanyId); ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartment(), "DepartmentId", "Name", user.DepartmentId); return(View(user)); }
public ActionResult Edit(Customer customer) { if (ModelState.IsValid) { var db2 = new KissiContext(); var currentUser = db2.Customers.Find(customer.CustomerId); if (currentUser.UserName != customer.UserName) { UsersHelper.UpdateUserName(currentUser.UserName, customer.UserName); } db2.Dispose(); db.Entry(customer).State = EntityState.Modified; var response = DBHelper.SaveChanges(db); if (response.Succeeded) { //UsersHelper.CreateUserASP(customer.UserName, "Customer"); return(RedirectToAction("Index")); } ModelState.AddModelError(string.Empty, response.Message); //return RedirectToAction("Index"); } ViewBag.CityId = new SelectList(CombosHelper.GetCities(customer.DepartmentId), "CityId", "Name", customer.CityId); //ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", customer.CompanyId); ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartment(), "DepartmentId", "Name", customer.DepartmentId); return(View(customer)); }
public static Response SaveChanges(KissiContext db) { try { db.SaveChanges(); return(new Response { Succeeded = true, }); } catch (Exception ex) { var response = new Response { Succeeded = false, }; if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("_Index")) { response.Message = "There is a record with the same value"; } else if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE")) { response.Message = "The record can't be delete because it has related records"; } else { response.Message = ex.Message; } return(response); } }
public static int GetState(string description, KissiContext db) { var state = db.States.Where(c => c.Description == description).FirstOrDefault(); if (state == null) { state = new State { Description = description, }; db.States.Add(state); db.SaveChanges(); } return(state.StateId); }