public IActionResult printGarardadProductPackings(string kind, Models.reports.rep_JameGarardadProductPackings.Model model)
{
ViewBag.kind = kind;
if (ModelState.IsValid)
{
ViewBag.table = printGarardadProductPackingsdata(model);
}
ViewData["listcustumer"] = db.TblCustomers.Include(a => a.TblContracts).Where(a => a.FkSalmali == User._getuserSalMaliDef()
&&
a.TblContracts.Any()).OrderBy(a => a.Code).Select(a => new web_sard.Models.tbls.customer.customer(a, db, web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, true)).ToList();
return(View(model));
}
public Models.reports.rep_JameGarardadProductPackings.Report printGarardadProductPackingsdata(Models.reports.rep_JameGarardadProductPackings.Model model)
{
var sal = User._getuserSalMaliDef();
var x = (from n in db.TblStoreLogs
where n.FkSalmali == User._getuserSalMaliDef() &&
model.kindContract == n.FkContractType &&
(model.pakings == null ? true : (model.pakings ?? new Guid[0]).Contains(n.FkPacking ?? Guid.Empty)) &&
(model.prodocts == null ? true : (model.prodocts ?? new Guid[0]).Contains(n.FkProduct ?? Guid.Empty))
select new Models.reports.rep_JameGarardadProductPackings.row
{
Contract = ((double?)(db.TblContracts.SingleOrDefault(a => a.Id == n.FkContract) ?? new web_db._Weighing.TblContract()).Code),
Customer = (db.TblCustomers.SingleOrDefault(a => a.Id == n.FkCustomer) ?? new TblCustomer()).Title,
Location1 = (db.TblLocations.SingleOrDefault(a => a.Id == n.FkLocation1) ?? new
web_db._Weighing.TblLocation()).CodeFull,
Location2 = (db.TblLocations.SingleOrDefault(a => a.Id == n.FkLocation2) ?? new web_db._Weighing.TblLocation()).CodeFull,
Product = (db.TblProducts.SingleOrDefault(a => a.Id == n.FkProduct) ?? new web_db._Weighing.TblProduct()).Title,
Packing = (db.TblPackings.SingleOrDefault(a => a.Id == n.FkPacking) ?? new web_db._Weighing.TblPacking()).Title,
log = n
});
return(new Models.reports.rep_JameGarardadProductPackings.Report {
rows = x.ToList(), model = model
});
}
