public ActionResult AddProduct(AddProductView view) { var user = db.Users. Where(us => us.UserName == User.Identity.Name). FirstOrDefault(); if (ModelState.IsValid) { var orderDetailTmp = db.OrderDetailTmps. Where(odt => odt.UserName == User.Identity.Name && odt.ProductID == view.ProductId). FirstOrDefault(); if (orderDetailTmp == null) { var product = db.Products.Find(view.ProductId); orderDetailTmp = new OrderDetailTmp { Description = product.Description, Price = product.Price, ProductID = product.ProductID, Quantity = view.Quantity, TaxRate = product.Tax.Rate, UserName = User.Identity.Name, }; db.OrderDetailTmps. Add(orderDetailTmp); } else { orderDetailTmp.Quantity += view.Quantity; db.Entry(orderDetailTmp).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Create")); } ViewBag.ProductId = new SelectList( ComboBoxHelpers. GetProducts( user.CompanyId), "ProductID", "Description"); return(PartialView(view)); }
public ActionResult Create(WareHouse wareHouse) { if (ModelState.IsValid) { db.WareHouses.Add(wareHouse); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException. InnerException != null && ex.InnerException. InnerException.Message. Contains("_Index")) { ModelState. AddModelError( string.Empty, "You Can't Add a New Record, Because There is Already One"); } else { ModelState. AddModelError( string.Empty, ex.Message); } } } ViewBag.CityId = new SelectList( ComboBoxHelpers. GetCities(), "CityId", "NameCity", wareHouse.CityId); ViewBag.StateId = new SelectList( ComboBoxHelpers. GetStates(), "StateId", "NameState", wareHouse.StateId); return(View(wareHouse)); }
public ActionResult Create(Category category) { if (ModelState.IsValid) { db.Categories.Add(category); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException. InnerException != null && ex.InnerException. InnerException.Message. Contains("_Index")) { ModelState. AddModelError( string.Empty, "You Can't Add a New Record, Because There is Already One"); } else { ModelState. AddModelError( string.Empty, ex.Message); } } } ViewBag.CompanyId = new SelectList( ComboBoxHelpers. GetCompanies(), "CompanyId", "NameCompany", category.CompanyId); return(View(category)); }
public static Response SaveChanges(CenECommerceContext 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 GetPurchasesStatus(string description, CenECommerceContext db) { var purchaseStatus = db.PurchaseStatus. Where(ps => ps.Description == description). FirstOrDefault(); if (purchaseStatus == null) { purchaseStatus = new PurchaseStatus { Description = description, }; db.PurchaseStatus.Add(purchaseStatus); db.SaveChanges(); } return(purchaseStatus.PurchaseStatusId); }
public ActionResult Create(City city) { if (ModelState.IsValid) { db.Cities.Add(city); try { db.SaveChanges(); if (city.FlagFile != null) { var folder = "~/Content/Cities/FlagsCities"; var file = string.Format("{0}.jpg", city.CityId); var response = FilesHelpers. UploadPhoto( city.FlagFile, folder, file); if (response) { var pic = string.Format("{0}/{1}", folder, file); city.Flag = pic; db.Entry(city).State = EntityState.Modified; db.SaveChanges(); } } if (city.ShieldFile != null) { var folder1 = "~/Content/Cities/ShieldsCities"; var file1 = string.Format("{0}.jpg", city.CityId); var response1 = FilesHelpers. UploadPhoto( city.ShieldFile, folder1, file1); if (response1) { var pic = string.Format("{0}/{1}", folder1, file1); city.Shield = pic; db.Entry(city).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException. InnerException != null && ex.InnerException. InnerException.Message. Contains("_Index")) { ModelState. AddModelError( string.Empty, "You Can't Add a New Record, Because There is Already One"); } else { ModelState. AddModelError( string.Empty, ex.Message); } } } ViewBag.StateId = new SelectList( ComboBoxHelpers. GetStates(), "StateId", "NameState", city.StateId); return(View(city)); }
public ActionResult Create(Company company) { if (ModelState.IsValid) { db.Companies.Add(company); var response = DBHelpers.SaveChanges(db); if (response.Succeeded) { if (company.LogoFile != null) { var folder = "~/Content/Logos"; var file = string.Format("{0}.jpg", company.CompanyId); var response0 = FilesHelpers. UploadPhoto( company.LogoFile, folder, file); if (response0) { var pic = string.Format("{0}/{1}", folder, file); company.Logo = pic; db.Entry(company).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ModelState.AddModelError( string.Empty, response.Message); } ViewBag.CityId = new SelectList( ComboBoxHelpers. GetCities(company.StateId), "CityId", "NameCity", company.CityId); ViewBag.StateId = new SelectList( ComboBoxHelpers. GetStates(), "StateId", "NameState", company.StateId); return(View(company)); }
public ActionResult Create(User user) { if (ModelState.IsValid) { db.Users.Add(user); var response = DBHelpers.SaveChanges(db); if (response.Succeeded) { UsersHelpers. CreateUserASP(user.UserName, "User"); if (user.PhotoFile != null) { var folder = "~/Content/Photos"; var file = string.Format("{0}.jpg", user.UserID); var response0 = FilesHelpers. UploadPhoto( user.PhotoFile, folder, file); if (response0) { var pic = string.Format("{0}/{1}", folder, file); user.Photo = pic; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ModelState.AddModelError( string.Empty, response.Message); } ViewBag.CityId = new SelectList( ComboBoxHelpers. GetCities(user.StateId), "CityId", "NameCity", user.CityId); ViewBag.CompanyId = new SelectList( ComboBoxHelpers. GetCompanies(), "CompanyId", "NameCompany", user.CompanyId); ViewBag.StateId = new SelectList( ComboBoxHelpers. GetStates(), "StateId", "NameState", user.StateId); return(View(user)); }
public static Response NewOrder(NewOrderView view, string userName) { using (var transacction = db.Database.BeginTransaction()) { try { var user = db.Users.Where( u => u.UserName == userName). FirstOrDefault(); var order = new Order { CompanyId = user.CompanyId, CustomerId = view.CustomerId, DateOrder = view.DateOrder, Remarks = view.Remarks, PurchaseStatusId = DBHelpers.GetPurchasesStatus( "Created Order", db), }; db.Orders.Add(order); db.SaveChanges(); var details = db.OrderDetailTmps. Where(odt => odt.UserName == userName). ToList(); foreach (var detail in details) { var orderDetail = new OrderDetail { Description = detail.Description, OrderID = order.OrderId, Price = detail.Price, ProductID = detail.ProductID, Quantity = detail.Quantity, TaxRate = detail.TaxRate, }; db.OrderDetails.Add(orderDetail); db.OrderDetailTmps.Remove(detail); } db.SaveChanges(); transacction.Commit(); return(new Response { Succeeded = true, }); } catch (Exception ex) { transacction.Rollback(); return(new Response { Message = ex.Message, Succeeded = false, }); } } }
public ActionResult Create(Customer customer) { var user = db.Users. Where(us => us.UserName == User.Identity.Name). FirstOrDefault(); if (ModelState.IsValid) { db.Customers.Add(customer); var response = DBHelpers.SaveChanges(db); if (response.Succeeded) { if (customer.LogoCFile != null) { var folder = "~/Content/Customers"; var file = string.Format("{0}.jpg", customer.CustomerID); var response0 = FilesHelpers. UploadPhoto( customer.LogoCFile, folder, file); if (response0) { var pic = string.Format("{0}/{1}", folder, file); customer.LogoC = pic; db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ModelState.AddModelError( string.Empty, response.Message); } ViewBag.CityId = new SelectList( ComboBoxHelpers. GetCities(customer.StateId), "CityId", "NameCity", customer.CityId); ViewBag.StateId = new SelectList( ComboBoxHelpers. GetStates(), "StateId", "NameState", customer.StateId); return(View(customer)); }
public ActionResult Create(Product product) { var user = db.Users. Where(us => us.UserName == User.Identity.Name). FirstOrDefault(); if (ModelState.IsValid) { db.Products.Add(product); var response = DBHelpers.SaveChanges(db); if (response.Succeeded) { if (product.ImageFile != null) { var folder = "~/Content/Products"; var file = string.Format("{0}.jpg", product.ProductID); var response = FilesHelpers. UploadPhoto( product.ImageFile, folder, file); if (response) { var pic = string.Format("{0}/{1}", folder, file); product.Image = pic; db.Entry(product).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ModelState.AddModelError( string.Empty, response.Message); } ViewBag.CategoryId = new SelectList( ComboBoxHelpers. GetCategories( user.CompanyId), "CategoryId", "Description", product.CategoryId); ViewBag.TaxId = new SelectList( ComboBoxHelpers. GetTaxes( user.CompanyId), "TaxId", "Description", product.TaxId); return(View(product)); }
public ActionResult Create(State state) { if (ModelState.IsValid) { db.States.Add(state); var response = DBHelpers.SaveChanges(db); if (response.Succeeded) { if (state.FlagFile != null) { var folder = "~/Content/Flags"; var file = string.Format("{0}.jpg", state.StateId); var response0 = FilesHelpers. UploadPhoto( state.FlagFile, folder, file); if (response0) { var pic = string.Format("{0}/{1}", folder, file); state.Flag = pic; db.Entry(state).State = EntityState.Modified; db.SaveChanges(); } } if (state.ShieldFile != null) { var folder1 = "~/Content/Shields"; var file1 = string.Format("{0}.jpg", state.StateId); var response1 = FilesHelpers. UploadPhoto( state.ShieldFile, folder1, file1); if (response1) { var pic = string.Format("{0}/{1}", folder1, file1); state.Shield = pic; db.Entry(state).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } ModelState.AddModelError( string.Empty, response.Message); } return(View(state)); }