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 string GetInvoicesAndSummary(string filter, string FromDate, string ToDate, string Customer, string InvoiceType, string Company, string Status, string Search)
{
try
{
AppUA appUA = Session["AppUA"] as AppUA;
CustomerInvoiceBundleViewModel Result = new CustomerInvoiceBundleViewModel();
Permission permission = Session["UserRights"] as Permission;
string permissionAccess = permission.SubPermissionList.Where(li => li.Name == "PBAccess").First().AccessCode;
if (permissionAccess.Contains("R") || permissionAccess.Contains("W"))
{
Result.PBAccess = true;
}
else
{
Result.PBAccess = false;
}
DateTime?FDate = string.IsNullOrEmpty(FromDate) ? (DateTime?)null : DateTime.Parse(FromDate);
DateTime?TDate = string.IsNullOrEmpty(ToDate) ? (DateTime?)null : DateTime.Parse(ToDate);
Result.CustomerInvoiceSummary = Mapper.Map <CustomerInvoiceSummary, CustomerInvoiceSummaryViewModel>(_customerInvoicesBusiness.GetCustomerInvoicesSummaryForSA());
Result.CustomerInvoices = Mapper.Map <List <CustomerInvoice>, List <CustomerInvoicesViewModel> >(_customerInvoicesBusiness.GetAllCustomerInvoicesForSA(FDate, TDate, Customer, InvoiceType, Company, Status, Search, Result.PBAccess));
if (filter != null && filter == "OD")
{
Result.CustomerInvoices = Result.CustomerInvoices.Where(m => m.PaymentDueDate < common.GetCurrentDateTime() && m.BalanceDue > 0).ToList();
}
else if (filter != null && filter == "OI")
{
Result.CustomerInvoices = Result.CustomerInvoices.Where(m => m.PaymentDueDate >= common.GetCurrentDateTime() && m.BalanceDue > 0).ToList();
}
else if (filter != null && filter == "FP")
{
Result.CustomerInvoices = Result.CustomerInvoices.Where(m => m.BalanceDue <= 0).ToList();
}
return(JsonConvert.SerializeObject(new { Result = "OK", Records = Result }));
}
catch (Exception ex)
{
AppConstMessage cm = c.GetMessage(ex.Message);
return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message }));
}
}