public ActionResult ChangeSaleman(assignNewspaperVM serviceAssign) { if (db.ServiceAssign.Any(m => m.CustomerId == serviceAssign.CustomerId)) { foreach (var item in serviceAssign.NewspaperIds) { ServiceAssign objService = db.ServiceAssign.FirstOrDefault(m => m.CustomerId == serviceAssign.CustomerId && m.NewspaperId == item); objService.SalesManId = serviceAssign.SalesManId; log.AddActivity("Service assign to customer successfully"); db.SaveChanges(); } return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Newspaper Already Assigned."); serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName"); serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); return(View(serviceAssign)); } }
public ActionResult ChangeSaleman(int?id) { var date = DateTime.Now; assignNewspaperVM assignVM = new assignNewspaperVM(); assignVM.CustomerId = Convert.ToInt32(id); var cus = (from s in db.ServiceAssign from c in db.Customer from n in db.Service where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.CustomerId == id select new { n }).ToList(); List <Service> ser = new List <Service>(); foreach (var item in cus) { Service newSer = db.Service.Find(item.n.Id); ser.Add(newSer); } assignVM.custId = db.Customer.Find(id).CustomerId; assignVM.Newspapers = new SelectList(ser, "Id", "NewsPaperName"); assignVM.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); return(View(assignVM)); }
public ActionResult Create(assignNewspaperVM serviceAssign) { if (!db.ServiceAssign.Any(m => m.NewspaperId == serviceAssign.NewspaperId && m.CustomerId == serviceAssign.CustomerId)) { if (db.Service.Any(m => m.Id == serviceAssign.NewspaperId && m.TimeBase == "मासिक") && serviceAssign.Duration == 365) { serviceAssign.EndedDate = serviceAssign.PaperDispatchDate.AddDays(serviceAssign.Duration - 30); } else { serviceAssign.EndedDate = serviceAssign.PaperDispatchDate.AddDays(serviceAssign.Duration); } ServiceAssign objService = new ServiceAssign(); objService.NepaliDate = serviceAssign.NepaliDate; objService.NewspaperId = serviceAssign.NewspaperId; objService.SalesManId = serviceAssign.SalesManId; objService.PaperDispatchDate = Convert.ToDateTime(serviceAssign.PaperDispatchDate.ToShortDateString()); objService.status = true; objService.UpdatedBy = serviceAssign.UpdatedBy; objService.UpdatedDate = serviceAssign.UpdatedDate; objService.CreatedBy = serviceAssign.CreatedBy; objService.CreatedDate = serviceAssign.CreatedDate; objService.CustomerId = serviceAssign.CustomerId; objService.Quantity = serviceAssign.Quantity; objService.EndedDate = Convert.ToDateTime(serviceAssign.EndedDate.ToShortDateString()); db.ServiceAssign.Add(objService); log.AddActivity("Service assign to customer successfully"); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Newspaper Already Assigned."); serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName"); serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); return(View(serviceAssign)); } }
// GET: ServiceAssigns/Create public ActionResult Create(int id) { var date = DateTime.Now; assignNewspaperVM assignVM = new assignNewspaperVM(); assignVM.CustomerId = id; assignVM.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName"); assignVM.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); assignVM.CreatedDate = date.Date; assignVM.EndedDate = DateTime.Now; assignVM.CreatedBy = Session["userEmail"].ToString(); assignVM.UpdatedBy = Session["userEmail"].ToString(); assignVM.UpdatedDate = DateTime.Now; assignVM.UpdatedDate = DateTime.Now; assignVM.status = true; assignVM.custId = db.Customer.Find(id).CustomerId; return(View(assignVM)); }
public ActionResult AllAssigned() { var cus = (from s in db.ServiceAssign from c in db.Customer from n in db.Service from o in db.SalesMan where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.SalesManId == o.Id select new { Customer = c, ServiceAssign = s, NewsPaper = n, SalesMan = o }).ToList(); List <assignNewspaperVM> objConter = new List <assignNewspaperVM>(); foreach (var item in cus) { assignNewspaperVM counter = new assignNewspaperVM(); counter.Paper = item.NewsPaper.NewsPaperName; counter.phone = item.Customer.MPhone; counter.CustomerName = item.Customer.FirstName; counter.Newspapername = item.NewsPaper.NewsPaperName; counter.Address = item.Customer.Address; counter.Distributor = item.SalesMan.FullName; counter.EndedDate = item.ServiceAssign.EndedDate; counter.PaperDispatchDate = item.ServiceAssign.PaperDispatchDate; var date = item.ServiceAssign.EndedDate; counter.endDate = ADTOBS.EngToNep(date).ToString(); var dispatch = item.ServiceAssign.PaperDispatchDate; counter.dispatch = ADTOBS.EngToNep(dispatch).ToString(); counter.CusId = item.Customer.CustomerId; counter.CustomerId = item.Customer.Id; objConter.Add(counter); } return(View(objConter.AsEnumerable())); }
// GET: ServiceAssigns public ActionResult Index() { var cus = (from s in db.ServiceAssign from c in db.Customer from n in db.Service from i in db.SalesMan where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.SalesManId == i.Id select new { Customer = c, ServiceAssign = s, NewsPaper = n, SalesMan = i }).ToList(); var uniqCustomer = from m in cus group m by new { m.Customer.Id } into mygroup select mygroup.FirstOrDefault(); List <assignNewspaperVM> objConter = new List <assignNewspaperVM>(); foreach (var item in uniqCustomer) { assignNewspaperVM counter = new assignNewspaperVM(); counter.Paper = item.NewsPaper.NewsPaperName; counter.phone = item.Customer.MPhone; counter.CustomerType = item.Customer.CustomerType; counter.CustomerName = item.Customer.FirstName; counter.Newspapername = item.NewsPaper.NewsPaperName; counter.Address = item.Customer.Address; counter.Distributor = item.SalesMan.FullName; counter.EndedDate = item.ServiceAssign.EndedDate; counter.PaperDispatchDate = item.ServiceAssign.PaperDispatchDate; counter.CusId = item.Customer.CustomerId; counter.CustomerId = item.Customer.Id; objConter.Add(counter); } return(View(objConter.AsEnumerable())); }
// GET: ServiceAssigns public ActionResult Index() { //var cus = (from s in db.ServiceAssign // from c in db.Customer // from n in db.Service // from o in db.SalesMan // where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.SalesManId == o.Id // select new // { // Customer = c, // ServiceAssign = s, // NewsPaper = n, // SalesMan = o // }).ToList(); //var uniqCustomer =(from m in cus // group m by new { m.Customer.CustomerId } // into mygroup // select mygroup.FirstOrDefault()).ToList(); var cus = (from s in db.ServiceAssign from c in db.Customer from n in db.Service from i in db.SalesMan where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.SalesManId == i.Id select new { Customer = c, ServiceAssign = s, NewsPaper = n, SalesMan = i }).ToList(); var uniqCustomer = from m in cus group m by new { m.Customer.Id } into mygroup select mygroup.FirstOrDefault(); List <assignNewspaperVM> objConter = new List <assignNewspaperVM>(); foreach (var item in uniqCustomer) { assignNewspaperVM counter = new assignNewspaperVM(); counter.Paper = item.NewsPaper.NewsPaperName; counter.phone = item.Customer.MPhone; counter.CustomerName = item.Customer.FirstName; counter.Newspapername = item.NewsPaper.NewsPaperName; counter.Address = item.Customer.Address; counter.Distributor = item.SalesMan.FullName; counter.EndedDate = item.ServiceAssign.EndedDate; counter.PaperDispatchDate = item.ServiceAssign.PaperDispatchDate; //var dispatch = item.ServiceAssign.PaperDispatchDate; //counter.dispatch = ADTOBS.EngToNep(dispatch).ToString(); counter.CusId = item.Customer.CustomerId; counter.CustomerId = item.Customer.Id; objConter.Add(counter); } return(View(objConter.AsEnumerable())); //return View(db.ServiceAssign.ToList()); }