public ActionResult Create(User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); UserHelper.CreateUserASP(user.UserName, "User"); if (user.PhotoFile != null) { var folder = "~/Content/Users"; var file = string.Format("{0}.jpg", user.UserId); var response = FilesHelper.UploadPhoto(user.PhotoFile, folder, file); if (response) { var pic = string.Format("{0}/{1}.jpg", folder, user.UserId); user.Photo = pic; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", user.CityId); ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", user.CompanyId); ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", user.CountryId); return(View(user)); }
public ActionResult Create(Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); if (category.ImageFile != null) { var folder = "~/Content/Categories"; var file = string.Format("{0}.jpg", category.CategoryId); var response = FilesHelper.UploadPhoto(category.ImageFile, folder, file); if (response) { var pic = string.Format("{0}/{1}.jpg", folder, category.CategoryId); category.Image = pic; db.Entry(category).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", category.CompanyId); return(View(category)); }
public static Response SaveChanges(StartupContext db) { try { db.SaveChanges(); return(new Response { Succedeed = true, }); } catch (Exception ex) { var response = new Response { Succedeed = false, }; if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("_Index")) { response.Message = "Ya existe un registro con ese nombre"; } else if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE")) { response.Message = "El registro no puede ser borrado porque tiene otros registros relacionados"; } else { response.Message = ex.Message; } return(response); } }
public ActionResult DeleteCity(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var city = db.Cities.Find(id); if (city == null) { return(HttpNotFound()); } db.Cities.Remove(city); db.SaveChanges(); return(RedirectToAction($"{nameof(Details)}/{city.CountryId}")); }
public ActionResult Create(Customer customer) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { db.Customers.Add(customer); var response = DBHelper.SaveChanges(db); if (!response.Succedeed) { ModelState.AddModelError(string.Empty, response.Message); transaction.Rollback(); ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", customer.CityId); ViewBag.DepartmentId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", customer.CountryId); } UserHelper.CreateUserASP(customer.UserName, "Customer"); var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault(); var companyCustomer = new CompanyCustomer { CompanyId = user.CompanyId, CustomerId = customer.CustomerId, }; db.CompanyCustomers.Add(companyCustomer); db.SaveChanges(); transaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); ModelState.AddModelError(string.Empty, ex.Message); } } } ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", customer.CityId); ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", customer.CountryId); return(View(customer)); }