public ActionResult Create([Bind(Include = "Id,OrderId,ProductId,Count,PricePerItem")] OrderItem orderItem) { if (ModelState.IsValid) { orderItem.PricePerItem = db.Products.SingleOrDefault(p => p.Id == orderItem.ProductId).Price; var existing = db.OrderItems.Where(oi => oi.OrderId == orderItem.OrderId && oi.ProductId == orderItem.ProductId) .SingleOrDefault(); if (existing != null) { existing.Count += orderItem.Count; existing.PricePerItem = orderItem.PricePerItem; db.Entry(existing).State = EntityState.Modified; } else { orderItem.Id = Guid.NewGuid(); db.OrderItems.Add(orderItem); } db.SaveChanges(); return(Json(new { success = true })); } ViewBag.OrderId = new SelectList(db.Orders, "Id", "Id", orderItem.OrderId); ViewBag.ProductId = new SelectList(db.Products, "Id", "ProductName", orderItem.ProductId); return(PartialView(orderItem)); }
public ActionResult Edit([Bind(Include = "Id,CategoryName,Description")] Category category) { if (ModelState.IsValid) { db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Edit([Bind(Include = "ID,UserName,Password,Active,Email,Address,Phone,UserType")] User user) { if (ModelState.IsValid && user.UserName.ToLower() != "admin") { using (var dbContextTransaction = _db.Database.BeginTransaction()) { try { string encodedPassword = TextEncoding.EncodeString(user.Password); user.Password = encodedPassword; _db.Entry(user).State = EntityState.Modified; _db.SaveChanges(); foreach (var ur in _db.UserRoles.Where(u => u.UserId == user.Id).ToList()) { _db.UserRoles.Remove(ur); } _db.SaveChanges(); string roleName = ""; switch (user.UserType) { case UserType.Company: roleName = "Company"; break; case UserType.Customer: roleName = "Customer"; break; case UserType.EStore: roleName = "Admin"; break; } if (!string.IsNullOrEmpty(roleName)) { var role = _db.Roles.SingleOrDefault(r => r.Roles == roleName); var userRole = new UserRole { Role = role, User = user }; _db.UserRoles.Add(userRole); } _db.SaveChanges(); dbContextTransaction.Commit(); return(RedirectToAction("Index")); } catch { dbContextTransaction.Rollback(); } } } return(View(user)); }
public ActionResult Edit([Bind(Include = "Id,CompanyName,Rate,UserId")] Company company) { if (ModelState.IsValid) { db.Entry(company).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.Users.Where(x => x.UserType == UserType.Company), "Id", "UserName", company.UserId); return(View(company)); }
public ActionResult Edit([Bind(Include = "Id,CustomerId,OrderDate,IsDelivered,DeliveredDate")] Order order) { if (ModelState.IsValid) { db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerId = new SelectList(db.Customers.Where(c => c.User.UserType == UserType.Customer), "Id", "Nikename", order.CustomerId); return(View(order)); }
public ActionResult Edit([Bind(Include = "Id,Nikename,Gender,UserId")] Customer customer) { if (ModelState.IsValid) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.Users.Where(c => c.UserType == UserType.Customer), "Id", "UserName", customer.UserId); return(View(customer)); }
public ActionResult Edit([Bind(Include = "Id,SubCategoryName,Description,CategoryId")] SubCategory subCategory) { if (ModelState.IsValid) { db.Entry(subCategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryId = new SelectList(db.Categories, "Id", "CategoryName", subCategory.CategoryId); return(View(subCategory)); }
public ActionResult Edit([Bind(Include = "Id,UserId,RoleId")] UserRole user_Roles) { if (ModelState.IsValid) { _db.Entry(user_Roles).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RoleId = new SelectList(_db.Roles, "ID", "Roles", user_Roles.RoleId); ViewBag.UserId = new SelectList(_db.Users, "ID", "UserName", user_Roles.UserId); return(View(user_Roles)); }
public ActionResult Edit([Bind(Include = "Id,ProductName,Description,SubCategoryId,CompanyId,Price,AvailableStock,Rate,ImageURL")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } var companyId = GetUserCompanyId(); if (companyId != Guid.Empty) { ViewBag.CompanyId = new SelectList(db.Companies.Where(c => c.Id == companyId), "Id", "CompanyName", product.CompanyId); } else { ViewBag.CompanyId = new SelectList(db.Companies, "Id", "CompanyName", product.CompanyId); } ViewBag.SubCategoryId = new SelectList(db.SubCategories, "Id", "SubCategoryName", product.SubCategoryId); return(View(product)); }