public ActionResult ChangeSalesPerson(string[] CustomerEmail, string SalesPersonID)
{
try
{
var DB = new BG_DBEntities();
string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id;
if (CustomerEmail.Count() > 0)
{
foreach (var i in CustomerEmail)
{
var Old = DB.AssignSalesPersonMsts.Where(x => x.CustomerID == i).ToList();
if (Old.Count() > 0)
{
Old.ForEach(x => x.Active = false);
DB.SaveChanges();
}
var obj = new AssignSalesPersonMst
{
Active = true,
CreatedDate = DateTime.Now,
CreatedBy = CurrentUserID,
SalesPersonID = SalesPersonID,
CustomerID = i
};
DB.AssignSalesPersonMsts.Add(obj);
DB.SaveChanges();
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AssignSalesPersons(string CustomerEmail, string SalesPersonID)
{
try
{
var DB = new BG_DBEntities();
string CurrentUserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id;
string CustomerID = DB.AspNetUsers.FirstOrDefault(x => x.Email == CustomerEmail).Id;
var obj = new AssignSalesPersonMst
{
Active = true,
CreatedDate = DateTime.Now,
CreatedBy = CurrentUserID,
SalesPersonID = SalesPersonID,
CustomerID = CustomerID
};
DB.AssignSalesPersonMsts.Add(obj);
DB.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}