// GET: /SalesMan/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesMan salesman = db.SalesMan.Find(id);
var cus = (from s in db.ServiceAssign
from c in db.Customer
where s.SalesManId == id && s.CustomerId == c.Id
select new
{
customer = c,
ServiceAssign = s,
}).ToList(); // as IEnumerable<CounterVM>;
var uniqCustomer = from m in cus
group m by new { m.customer.Id }
into mygroup
select mygroup.FirstOrDefault();
List <SalesmanVM> objConter = new List <SalesmanVM>();
foreach (var item in uniqCustomer)
{
SalesmanVM counter = new SalesmanVM();
counter.salesman = salesman;
counter.CustomerId = item.customer.CustomerId;
counter.CustomerName = item.customer.FirstName;
counter.Address = item.customer.Address;
counter.Phone = item.customer.MPhone;
objConter.Add(counter);
}
if (objConter.AsEnumerable() == null)
{
return(HttpNotFound());
}
return(View(objConter.AsEnumerable()));
//if (salesman == null)
//{
// return HttpNotFound();
//}
//return View(salesman);
}
// GET: /SalesMan/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesMan salesman = db.SalesMan.Find(id);
var cus = (from s in db.ServiceAssign
from c in db.Customer
from p in db.Service
where s.SalesManId == id && s.CustomerId == c.Id && s.NewspaperId == p.Id
select new
{
customer = c,
ServiceAssign = s,
service = p,
}).ToList(); // as IEnumerable<CounterVM>;
ViewBag.Newspaper = new SelectList(db.Service.ToList(), "NewsPaperName", "NewspaperName");
if (!(cus.Count == 0))
{
List <SalesmanVM> objConter = new List <SalesmanVM>();
foreach (var item in cus)
{
SalesmanVM counter = new SalesmanVM();
counter.salesman = salesman;
counter.Customertype = item.customer.CustomerType;
counter.CustomerId = item.customer.CustomerId;
counter.CustomerName = item.customer.FirstName;
counter.Address = item.customer.Address;
counter.Phone = item.customer.MPhone;
counter.Newspaper = item.service.NewsPaperName;
counter.Quantity = Convert.ToInt32(item.ServiceAssign.Quantity).ToString();
counter.Ended = item.ServiceAssign.EndedDate;
counter.EndedDate = ADTOBS.EngToNep(item.ServiceAssign.EndedDate).ToString();
counter.Paperdispatchdate = ADTOBS.EngToNep(item.ServiceAssign.PaperDispatchDate).ToString();
objConter.Add(counter);
}
ViewBag.errmsg = "customer";
if (objConter.AsEnumerable() == null)
{
return(HttpNotFound());
}
return(View(objConter.AsEnumerable()));
}
else
{
SalesmanVM objsale = new SalesmanVM();
List <SalesmanVM> objConter = new List <SalesmanVM>();
objsale.salesman = salesman;
objConter.Add(objsale);
ViewBag.errmsg = "no cus";
return(View(objConter.AsEnumerable()));
}
}