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