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