public PartialViewResult Payment(long Id) { ViewBag.Title = Constant.VENDOR_PAYMENT; var AnnualBudgetId = new BaseController(_repAnnualBudget).budgetList; var vpvm = new VendorPaymentViewModel(); vpvm.VendorInfo = _repPurchaseAsset.GetAssetPurchaseDetails().Where(x => x.Id == Id).SingleOrDefault(); var PaidAmtObj = _repPurchaseAsset.VendorPaymentDetails() .Where(x => x.AssetPurchaseId == Id) .Where(x => x.AnnualBudgetId == AnnualBudgetId).ToList(); var lstVendorPayment = new List <VendorPaymentViewModel>(); vpvm.AlreadyPaidAmount = 0; vpvm.PaymentConfirmedBy = ""; if (PaidAmtObj != null) { for (int i = 0; i < PaidAmtObj.Count; i++) { var vpv = new VendorPaymentViewModel(); vpv.AlreadyPaidAmount = PaidAmtObj[i].PaidAmount; vpv.PaymentConfirmedBy = PaidAmtObj[i].PaymentConfirmedBy; lstVendorPayment.Add(vpv); } } vpvm.AlreadyPaidList = lstVendorPayment; return(PartialView(vpvm)); }
public ActionResult DepreciationInAYear() { ViewBag.Title = Constant.DEPRECIATION_IN_A_YEAR; var diayVm = new DepreciationInAYearViewModel(); var yearList = _repDepreciation.GetYearOfDepreciation(); decimal totalPurchaseValue = 0; decimal totalCurrentValue = 0; var lstYear = new List <string>(); var lstTotalPurchaseValue = new List <decimal>(); var lstTotalDepnValue = new List <decimal>(); foreach (var item1 in yearList) { var purchaseDetails = _repPurchaseAsset.GetPurchaseDetailsByYear().Where(x => x.Year == item1.Year).ToList(); foreach (var item2 in purchaseDetails) { //Check if item is in Purchase Return var checkPurchaseReturnObj = _repPurchaseAsset.GetPurchaseReturnDetails() .Where(x => x.AssetPurchaseId == item2.AssetPurchaseId).SingleOrDefault(); //Check if item is in Scrap var checkScrapObj = _repAsset.GetScrap().Where(x => x.PurchaseId == item2.AssetPurchaseId).SingleOrDefault(); if (checkPurchaseReturnObj == null && checkScrapObj == null) { totalCurrentValue += Decimal.Parse(CurrentItemValue.GetCurrentValue(item2.AssetPurchaseId).ToString("#.##")); var totalPurchaseValueObj = _repPurchaseAsset.GetAssetPurchaseDetails() .Where(x => x.Id == item2.AssetPurchaseId) .SingleOrDefault(); if (totalPurchaseValueObj != null) { totalPurchaseValue += totalPurchaseValueObj.PricePerUnit; } } } lstTotalPurchaseValue.Add(totalPurchaseValue); lstTotalDepnValue.Add(totalPurchaseValue - totalCurrentValue); lstYear.Add(item1.Year); } diayVm.YearList = lstYear.ToArray(); diayVm.TotalDepreciationValue = lstTotalDepnValue.ToArray(); return(View(diayVm)); }
private decimal AssetValueWithDepreciation() { decimal totalCurrentValue = 0; foreach (var item in _repPurchaseAsset.GetAssetPurchaseDetails()) { //Check if item is in Purchase Return var checkPurchaseReturnObj = _repPurchaseAsset.GetPurchaseReturnDetails() .Where(x => x.AssetPurchaseId == item.Id).SingleOrDefault(); //Check if item is in Scrap var checkScrapObj = _repAsset.GetScrap().Where(x => x.PurchaseId == item.Id).SingleOrDefault(); if (checkPurchaseReturnObj == null && checkScrapObj == null) { totalCurrentValue += Decimal.Parse(CurrentItemValue.GetCurrentValue(item.Id).ToString("#.##")); } } return(totalCurrentValue); }
public ViewResult ListDepreciationValue() { ViewBag.Title = Constant.LIST_DEPRECIATION; var ldvm = new ListDepreciationViewModel(); var listPurchaseNo = _repDepreciation.ListPurchaseNo(); //ldvm.PurchasedDateString = listPurchaseNo.Skip(0).Take(10); var listDepreciation = new List <ListDepreciationViewModel>(); foreach (var item in listPurchaseNo) { var ldvmObj = new ListDepreciationViewModel(); ldvmObj.AssetPurchaseId = item.AssetPurchaseId; ldvmObj.PurchaseNo = item.PurchaseNo; ldvmObj.AssetName = item.AssetName; ldvmObj.PurchasedPrice = item.PurchasedPrice; ldvmObj.CurrentAssetValue = Decimal.Parse(CurrentItemValue.GetCurrentValue(item.AssetPurchaseId).ToString("#.##")); var purchasedPrice = _repPurchaseAsset.GetAssetPurchaseDetails() .Where(x => x.Id == item.AssetPurchaseId) .SingleOrDefault().PricePerUnit; ldvmObj.DepRateList = _repDepreciation.GetDepreciation() .Where(x => x.AssetPurchaseId == item.AssetPurchaseId) .Select(x => new DepreciationRateViewModel() { AssetPurchaseId = x.AssetPurchaseId, PurchasedDate = x.PurchasedDate, Year = x.Year, Rate = x.Rate, DepreciationType = x.DepreciationType, DepreciationMaturityDate = x.DepreciationMaturityDate, DepreciationEntryDate = x.DepreciationEntryDate, //CurrentAssetValue = Decimal.Parse(CurrentItemValue.GetCurrentValue(x.AssetPurchaseId).ToString("#.##")) //CurrentAssetValue = Decimal.Parse(GetCurrentAssetValue(purchasedPrice, // x.PurchasedDate, // x.Rate, // "fixed").ToString("#.##")) }).OrderByDescending(x => x.Year).ToList(); listDepreciation.Add(ldvmObj); } ldvm.ListDepreciation = listDepreciation.Skip(0).Take(10).ToList(); ldvm.TotalDateCount = _repDepreciation.ListPurchaseNo().Count(); ldvm.DateCount = listDepreciation.Skip(0).Take(10).ToList().Count(); return(View(ldvm)); }