public ActionResult AssignSaleForClient(string id, string userSale)
{
var model = new SaleManageClient {
User_Client = id, User_Sale = userSale
};
var listSale = db.UserProfiles.Where(a => a.UserType == UserType.Sale.ToString()).Select(a => new { email = a.Email, display = a.Name });
ViewBag.listSale = new SelectList(listSale, "email", "display", userSale);
return(PartialView("_AssignSalePartial", model));
}
public ActionResult AssignSaleForClient(SaleManageClient model, string listSale)
{
var update = db.SaleManageClients.FirstOrDefault(a => a.User_Client == model.User_Client);
if (update == null)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
model.User_Update = User.Identity.Name;
model.LastUpdate = DateTime.Now;
db.SaleManageClients.Add(model);
//truong hop khach hang moi duoc gan sale
//update sale vao don hang moi chua co sale manage
var listOrder = db.Orders.Where(a => a.UserName == model.User_Client && string.IsNullOrEmpty(a.SaleManager)).ToList();
foreach (var order in listOrder)
{
order.SaleManager = model.User_Sale;
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
else
{
update.User_Update = User.Identity.Name;
update.LastUpdate = DateTime.Now;
update.User_Sale = model.User_Sale;
db.SaveChanges();
}
return(RedirectToAction("ListClient"));
}
