public SellingListQueryViewModel GetSellingBySalesAndDay(int jobNumber, DateTime begin, DateTime end) { var result = new SellingListQueryViewModel(); BizModel context = new BizModel(); var sellingRepo = new BizRepository <Selling>(context); var salesManRepo = new BizRepository <SalesMan>(context); var temp = from selling in sellingRepo.GetAll() join sales in salesManRepo.GetAll() on selling.SalesJobNumber equals sales.JobNumber where selling.SalesJobNumber == jobNumber && selling.SellingDay >= begin && selling.SellingDay < end select new SellingQueryViewModel { PartNo = selling.PartNo, Quantity = selling.Quantity, SalesJobNumber = selling.SalesJobNumber, SalesName = sales.Name, SellingDay = selling.SellingDay, SellingId = selling.SellingId, UnitPrice = selling.UnitPrice, TotalPrice = selling.UnitPrice * selling.Quantity }; result.Items = temp.ToList(); return(result); }
public SellingListQueryViewModel GetSellingBySalesMan(int JobNumber) { var result = new SellingListQueryViewModel(); result.Item = new List <SellingQueryViewModel>(); BizModel context = new BizModel(); BizRepository <Selling> SellingRepo = new BizRepository <Selling>(context); BizRepository <SalesMan> SalesManRepo = new BizRepository <SalesMan>(context); var temp = from p in SellingRepo.GetAll() join s in SalesManRepo.GetAll() on p.SalesJobNumber equals s.JobNumber where s.JobNumber == JobNumber select new SellingQueryViewModel { PartNo = p.PartNo, Quantity = p.Quantity, UnitPrice = p.UnitPrice, SalesJobNumber = s.JobNumber, SalesName = s.Name, SellingDay = p.SellingDay, SellingId = p.SellingId, TotalPrice = p.UnitPrice * p.Quantity }; result.Item = temp.ToList(); return(result); }