public TXSItemUOMDetail changeItems(int id, string userid, string userName) { TXSItemUOMDetail obj = new TXSItemUOMDetail(); obj.Txsitem = db.TxsitemDetail.Where(x => x.UserName == userName && x.Id == userid && x.ItmId == id).OrderByDescending(x => x.ItmId).FirstOrDefault(); obj.Txuom = db.Txsuomdetail.Where(x => x.Uomid == Convert.ToInt32(obj.Txsitem.ItmUom)).FirstOrDefault(); return(obj); }
public IActionResult PrintAllPurchase(string id) { //var user = await _userManager.GetUserAsync(User); //if (User == null) //{ // throw new ApplicationException($"Unable to load user with ID '{_userManager.GetUserId(User)}'."); //} TXTPurchaseDetailView lstPurchase = new TXTPurchaseDetailView(); lstPurchase.lstMaster = db.TxtpurchaseMaster.Where(x => x.Id == UId && x.UserName == UName).ToList(); lstPurchase.detail.detail = db.TxtpurchaseDetail.Where(x => x.Id == UId && x.UserName == UName).OrderBy(x => x.PurSerialNo).ToList(); lstPurchase.lstBank = db.TxsbankDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstCurrency = db.TxscurrencyDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstStore = db.TxsstoreDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstSupplier = db.TxssupplierDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstSite = db.TxssiteDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstItem = db.TxsitemDetail.Where(x => x.UserName == UName).ToList(); lstPurchase.lstTax = db.TxstaxDetail.Where(x => x.UserName == UName && x.TaxType == "PURCHASE" && x.TaxActive == true).ToList(); lstPurchase.lstExcise = db.TxstaxDetail.Where(x => x.UserName == UName && x.TaxType == "SALE" && x.TaxActive == true).ToList(); for (int i = 0; i < lstPurchase.detail.detail.Count; i++) { PDEF pDEF = new PDEF(); TXSItemUOMDetail item = new TXSItemUOMDetail(); int itmid = (int)lstPurchase.detail.detail[i].ItmId; if (itmid != -1) { item = changeItems(itmid, UId, UName); pDEF.UOM = item.Txuom.Uomname; pDEF.lastPrice = item.Txsitem.ItmSp; } pDEF.subAmount = lstPurchase.detail.detail[i].PurQty * lstPurchase.detail.detail[i].PurRate; pDEF.AmtAfterExcise = pDEF.subAmount + lstPurchase.detail.detail[i].PurExAmt; pDEF.AmtAfterDiscount = pDEF.subAmount + lstPurchase.detail.detail[i].PurExAmt - lstPurchase.detail.detail[i].PurDiscountAmt; lstPurchase.detail.pdef.Add(pDEF); lstPurchase.detail.detail[i].PurGrossAmt = lstPurchase.detail.detail[i].PurNetAmt * lstPurchase.master.PurExRate; } //lstSite = db.TxssiteDetail.Where(x => x.Id == user.Id && x.UserName == user.UserName).ToList(); return(new ViewAsPdf("ReportAllPurchase", lstPurchase) { // CustomSwitches = "--page-offset 0 --footer-center Page: [page]/[toPage]\ --footer-font-size 12"}; CustomSwitches = "--footer-center \" Page: [page]/[toPage]\"" + " --footer-line --footer-font-size \"10\" --footer-spacing 1 --footer-font-name \"Segoe UI\"" }); }