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