public DepositAndWithdrawals GetDepositAndWithdrawalDetails(Guid ID) { DepositAndWithdrawals depositAndWithdrawalsObj = new DepositAndWithdrawals(); depositAndWithdrawalsObj = _depositAndWithdrawalsRepository.GetDepositAndWithdrawalDetails(ID); if (depositAndWithdrawalsObj != null) { depositAndWithdrawalsObj.AmountFormatted = _commonBusiness.ConvertCurrency(depositAndWithdrawalsObj.Amount, 2); } return(depositAndWithdrawalsObj); }
public CustomerCreditNotes GetCustomerCreditNoteDetails(Guid ID) { CustomerCreditNotes custCreditNotesObj = new CustomerCreditNotes(); custCreditNotesObj = _customerCreditNotesRepository.GetCustomerCreditNoteDetails(ID); if (custCreditNotesObj != null) { custCreditNotesObj.creditAmountFormatted = _commonBusiness.ConvertCurrency(custCreditNotesObj.Amount, 2); custCreditNotesObj.adjustedAmountFormatted = _commonBusiness.ConvertCurrency(custCreditNotesObj.adjustedAmount, 2); } return(custCreditNotesObj); }
public ActionResult OutstandingSummary(OutstandingSummaryViewModel data) { CustomerInvoiceSummaryViewModel CustomerInvoiceSummary = Mapper.Map <CustomerInvoiceSummary, CustomerInvoiceSummaryViewModel>(_customerInvoiceBusiness.GetCustomerInvoicesSummaryForSA()); SupplierInvoiceSummaryViewModel SupplierInvoiceSummary = Mapper.Map <SupplierInvoiceSummary, SupplierInvoiceSummaryViewModel>(_supplierInvoicesBusiness.GetSupplierInvoicesSummary(data.IsInternal)); data.OutstandingInv = CustomerInvoiceSummary.OpenAmount + CustomerInvoiceSummary.OverdueAmount; data.OuttandingPay = SupplierInvoiceSummary.OpenAmount + SupplierInvoiceSummary.OverdueAmount; data.OutstandingInvFormatted = _commonBusiness.ConvertCurrency(data.OutstandingInv, 2); data.OuttandingPayFormatted = _commonBusiness.ConvertCurrency(data.OuttandingPay, 2); data.invCount = CustomerInvoiceSummary.OpenInvoices + CustomerInvoiceSummary.OverdueInvoices; data.payCount = SupplierInvoiceSummary.OpenInvoices + SupplierInvoiceSummary.OverdueInvoices; return(PartialView("_OutstandingSummary", data)); }
public SpecialInvPayments GetOutstandingSpecialAmountByCustomer(string ID) { SpecialInvPayments SpecialObj = _SpecialInvPaymentsRepository.GetOutstandingSpecialAmountByCustomer(ID); decimal temp = Decimal.Parse(SpecialObj.InvoiceOutstanding); SpecialObj.InvoiceOutstanding = _commonBusiness.ConvertCurrency(temp, 0); return(SpecialObj); }
public CustomerPayments GetOutstandingAmountByCustomer(string CustomerID) { CustomerPayments CustomerPayObj = _customerPaymentsRepository.GetOutstandingAmountByCustomer(CustomerID); decimal temp = Decimal.Parse(CustomerPayObj.OutstandingAmount); CustomerPayObj.OutstandingAmount = _commonBusiness.ConvertCurrency(temp, 0); return(CustomerPayObj); }
public string GetAllDepositAndWithdrawals(string FromDate, string ToDate, string DepositOrWithdrawal, string chqclr) { try { List <DepositAndWithdrwalViewModel> depositAndWithdrwalsList = Mapper.Map <List <DepositAndWithdrawals>, List <DepositAndWithdrwalViewModel> >(_depositAndWithdrawalsBusiness.GetAllDepositAndWithdrawals(FromDate, ToDate, DepositOrWithdrawal, chqclr)); var totalWdl = depositAndWithdrwalsList.Where(amt => amt.TransactionType == "W").Sum(amt => amt.Amount); var totalDpt = depositAndWithdrwalsList.Where(amt => amt.TransactionType == "D").Sum(amt => amt.Amount); string totalWdlFormatted = _commonBusiness.ConvertCurrency(totalWdl, 2); string totalDptFormatted = _commonBusiness.ConvertCurrency(totalDpt, 2); return(JsonConvert.SerializeObject(new { Result = "OK", Records = depositAndWithdrwalsList, totalWdl = totalWdlFormatted, totalDpt = totalDptFormatted })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public SupplierPayments GetOutstandingAmountBySupplier(string SupplierID) { SupplierPayments PayObj = _supplierPaymentsRepository.GetOutstandingAmountBySupplier(SupplierID); decimal temp = Decimal.Parse(PayObj.OutstandingAmount); PayObj.OutstandingAmount = _commonBusiness.ConvertCurrency(temp, 0); return(PayObj); }
public OtherIncome GetOtherIncomeDetails(Guid ID) { OtherIncome otherIncomeObj = new OtherIncome(); otherIncomeObj = _iOtherIncomeRepository.GetOtherIncomeDetails(ID); if (otherIncomeObj != null) { otherIncomeObj.creditAmountFormatted = _commonBusiness.ConvertCurrency(otherIncomeObj.Amount, 2); } return(otherIncomeObj); }
public string GetSupplierInvoiceDetails(string ID) { try { SupplierInvoicesViewModel SupplierInvoiceObj = Mapper.Map <SupplierInvoices, SupplierInvoicesViewModel>(_supplierInvoicesBusiness.GetSupplierInvoiceDetails(Guid.Parse(ID))); if (SupplierInvoiceObj != null) { SupplierInvoiceObj.AccountCode = SupplierInvoiceObj.AccountCode + ":" + SupplierInvoiceObj.IsEmp; SupplierInvoiceObj.TotalInvoiceAmountstring = _commonBusiness.ConvertCurrency(SupplierInvoiceObj.TotalInvoiceAmount, 0); SupplierInvoiceObj.BalanceDuestring = _commonBusiness.ConvertCurrency(SupplierInvoiceObj.BalanceDue, 0); SupplierInvoiceObj.PaidAmountstring = _commonBusiness.ConvertCurrency((SupplierInvoiceObj.TotalInvoiceAmount - SupplierInvoiceObj.BalanceDue), 0); } return(JsonConvert.SerializeObject(new { Result = "OK", Records = SupplierInvoiceObj })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public MonthlyRecap GetMonthlyRecap(MonthlyRecap data) { MonthlyRecap Result = _dashboardRepository.GetMonthlyRecap(data); if (Result != null) { foreach (MonthlyRecapItem m in Result.MonthlyRecapItemList) { Result.TotalIncome = Result.TotalIncome + m.INAmount; Result.TotalExpense = Result.TotalExpense + m.ExAmount; } Result.TotalProfit = Result.TotalIncome - Result.TotalExpense; //decimal n = (Result.MonthlyRecapItemList[11].INAmount - Result.MonthlyRecapItemList[0].INAmount); //decimal d = Result.MonthlyRecapItemList[0].INAmount; //if (d == 0) { d = 1; } //Result.IncomePercentage = n /d * 100; //n = (Result.MonthlyRecapItemList[11].ExAmount - Result.MonthlyRecapItemList[0].ExAmount); //d = Result.MonthlyRecapItemList[0].ExAmount; //if (d == 0) { d = 1; } //Result.ExpensePercentage = n/ d * 100; //n = ((Result.MonthlyRecapItemList[11].INAmount - Result.MonthlyRecapItemList[11].ExAmount) - (Result.MonthlyRecapItemList[0].INAmount - Result.MonthlyRecapItemList[0].ExAmount)); //d = (Result.MonthlyRecapItemList[0].INAmount - Result.MonthlyRecapItemList[0].ExAmount); //if (d == 0) { d = 1; } //Result.ProfitPercentage = n/d * 100; Result.Caption = Result.MonthlyRecapItemList[0].Period + "-" + Result.MonthlyRecapItemList[11].Period; Result.FormattedTotalIncome = _commonBusiness.ConvertCurrency(Result.TotalIncome, 2); Result.FormattedTotalExpense = _commonBusiness.ConvertCurrency(Result.TotalExpense, 2); Result.FormattedTotalProfit = _commonBusiness.ConvertCurrency(Result.TotalProfit, 2); } return(Result); }
public string GetAllOtherIncome(string IncomeDate, string DefaultDate) { try { List <OtherIncomeViewModel> otherIncomeList = Mapper.Map <List <OtherIncome>, List <OtherIncomeViewModel> >(_otherIncomeBusiness.GetAllOtherIncome(IncomeDate, DefaultDate)); var totalAmt = otherIncomeList.Sum(amt => amt.Amount); string totalAmtFormatted = _commonBusiness.ConvertCurrency(totalAmt, 2); return(JsonConvert.SerializeObject(new { Result = "OK", Records = otherIncomeList, TotalAmt = totalAmtFormatted })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public string GetBankWiseBalance(string Date) { try { List <OtherExpenseViewModel> otherExpenseList = Mapper.Map <List <OtherExpense>, List <OtherExpenseViewModel> >(_otherExpenseBusiness.GetBankWiseBalance(Date)); string TotalAmountFormatted = _commonBusiness.ConvertCurrency(otherExpenseList.Sum(OE => OE.TotalAmount), 2); string TotalUnClrAmtFormatted = _commonBusiness.ConvertCurrency(otherExpenseList.Sum(OE => OE.UnClearedAmount), 2); string TotalUnderClrAmtFormatted = _commonBusiness.ConvertCurrency(otherExpenseList.Sum(OE => OE.UnderClearingAmount), 2); string ActualBlnceFormatted = _commonBusiness.ConvertCurrency(otherExpenseList.Sum(OE => OE.TotalAmount) + otherExpenseList.Sum(OE => OE.UnClearedAmount), 2); return(JsonConvert.SerializeObject(new { Result = "OK", Records = otherExpenseList, TotalAmount = TotalAmountFormatted, TotalUnClrAmt = TotalUnClrAmtFormatted, TotalUnderClrAmt = TotalUnderClrAmtFormatted, ActualBlnce = ActualBlnceFormatted })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = ex.Message })); } }
public string GetCustomerInvoiceDetails(string ID) { try { CustomerInvoicesViewModel CustomerInvoiceObj = Mapper.Map <CustomerInvoice, CustomerInvoicesViewModel>(_customerInvoicesBusiness.GetCustomerInvoiceDetails(Guid.Parse(ID))); if (CustomerInvoiceObj != null) { CustomerInvoiceObj.TotalInvoiceAmountstring = _commonBusiness.ConvertCurrency(CustomerInvoiceObj.TotalInvoiceAmount, 0); CustomerInvoiceObj.BalanceDuestring = _commonBusiness.ConvertCurrency(CustomerInvoiceObj.BalanceDue, 0); CustomerInvoiceObj.PaidAmountstring = _commonBusiness.ConvertCurrency((CustomerInvoiceObj.TotalInvoiceAmount - CustomerInvoiceObj.BalanceDue), 0); } return(JsonConvert.SerializeObject(new { Result = "OK", Records = CustomerInvoiceObj })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public CustomerInvoiceSummary GetCustomerInvoicesSummaryForSA() { try { CustomerInvoiceSummary result = new CustomerInvoiceSummary(); result = _customerInvoicesRepository.GetCustomerInvoicesSummaryForSA(); if (result != null) { result.OpenAmountFormatted = _commonBusiness.ConvertCurrency(result.OpenAmount, 2); result.PaidAmountFormatted = _commonBusiness.ConvertCurrency(result.PaidAmount, 2); result.OverdueAmountFormatted = _commonBusiness.ConvertCurrency(result.OverdueAmount, 2); } return(result); } catch (Exception ex) { throw ex; } }
public OtherExpSummary GetOtherExpSummary(int month, int year, string Company) { OtherExpSummary result = _otherExpenseRepository.GetOtherExpSummary(month, year, Company); if (result != null) { int r = 150; int g = 120; int b = 80; string color = "rgba($r$,$g$,$b$,0.6)"; foreach (OtherExpSummaryItem s in result.ItemsList) { Random rnd = new Random(); s.color = color.Replace("$r$", r.ToString()).Replace("$g$", g.ToString()).Replace("$b$", b.ToString()); b = b + 50; g = g + 30; r = r + g; if (b > 250) { b = 0; } if (g > 250) { g = 0; } if (r > 250) { r = 0; } s.AmountFormatted = _commonBusiness.ConvertCurrency(s.Amount, 2); result.Total = result.Total + s.Amount; } result.TotalFormatted = _commonBusiness.ConvertCurrency(result.Total, 2); result.Month = new DateTime(2010, month, 1).ToString("MMM") + " " + year; } return(result); }
public PurchaseDetailReport GetPurchaseDetails(DateTime?FromDate, DateTime?ToDate, string CompanyCode, string search, Boolean IsInternal, Guid Supplier, string InvoiceType, Guid SubType, string AccountCode) { PurchaseDetailReport purchasedetailObj = new PurchaseDetailReport(); List <PurchaseDetailReport> purchaseDetailReportList = null; try { purchaseDetailReportList = _reportRepository.GetPurchaseDetails(FromDate, ToDate, CompanyCode, search, IsInternal, Supplier, InvoiceType, SubType, AccountCode); decimal purchaseDetailSum = purchaseDetailReportList.Where(PD => PD.RowType != "T").Sum(PD => PD.BalanceDue); decimal purchaseDetailInvoiceAmount = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.InvoiceAmount); decimal purchaseDetailPaidAmount = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.PaidAmount); decimal purchaseDetailPaymentProcessed = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.PaymentProcessed); decimal purchaseDetailsTax = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.Tax); decimal purchaseDetailTotal = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.TotalInvoice); purchasedetailObj.purchaseDetailSum = _commonBusiness.ConvertCurrency(purchaseDetailSum, 2); purchasedetailObj.purchaseDetailPaid = _commonBusiness.ConvertCurrency(purchaseDetailPaidAmount, 2); purchasedetailObj.purchaseDetailInvoice = _commonBusiness.ConvertCurrency(purchaseDetailInvoiceAmount, 2); purchasedetailObj.purchaseDetailPaymentProcess = _commonBusiness.ConvertCurrency(purchaseDetailPaymentProcessed, 2); purchasedetailObj.purchaseDetailsTaxAmount = _commonBusiness.ConvertCurrency(purchaseDetailsTax, 2); purchasedetailObj.purchaseDetailsTotalAmount = _commonBusiness.ConvertCurrency(purchaseDetailTotal, 2); purchasedetailObj.purchaseDetailReportList = purchaseDetailReportList; } catch (Exception ex) { throw ex; } return(purchasedetailObj); }