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));
}
