public ActionResult Index(string companyId, string branchId, string dateFrom, string dateTo, string customerType, string phone, string supplierId)
{
try
{
DateTime?dfrom = null;
DateTime?dto = null;
if (!string.IsNullOrEmpty(dateFrom))
{
dfrom = Convert.ToDateTime(dateFrom);
dfrom = new DateTime(dfrom.Value.Year, dfrom.Value.Month, dfrom.Value.Day, 0, 0, 0);
}
if (!string.IsNullOrEmpty(dateTo))
{
dto = Convert.ToDateTime(dateTo);
dto = new DateTime(dto.Value.Year, dto.Value.Month, dto.Value.Day, 23, 59, 59);
}
SupplierViewModel suppliervm = new SupplierViewModel();
List <SupplierLedgerViewModel> supplierLedger = new List <SupplierLedgerViewModel>();
if (!string.IsNullOrEmpty(companyId) && !string.IsNullOrEmpty(branchId) && !string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(dateFrom) && !string.IsNullOrEmpty(dateTo))
{
suppliervm = Mapper.Map <SupplierViewModel>(_supplierService.GetSupplierBySupplierMobileNumber(phone));
supplierLedger = Mapper.Map <List <SupplierLedgerViewModel> >(_rawSqlService.GetAllSupplierLedger(companyId, branchId, dfrom.ToString(), dto.ToString(), "", phone, "").ToList());
}
else if (!string.IsNullOrEmpty(companyId) && !string.IsNullOrEmpty(branchId) && !string.IsNullOrEmpty(supplierId) && !string.IsNullOrEmpty(dateFrom) && !string.IsNullOrEmpty(dateTo))
{
suppliervm = Mapper.Map <SupplierViewModel>(_supplierService.GetSupplierBySupplierId(supplierId));
supplierLedger = Mapper.Map <List <SupplierLedgerViewModel> >(_rawSqlService.GetAllSupplierLedger(companyId, branchId, dfrom.ToString(), dto.ToString(), "", "", supplierId).ToList());
}
else if (!string.IsNullOrEmpty(companyId) && !string.IsNullOrEmpty(branchId) && !string.IsNullOrEmpty(phone))
{
suppliervm = Mapper.Map <SupplierViewModel>(_supplierService.GetSupplierBySupplierMobileNumber(phone));
supplierLedger = Mapper.Map <List <SupplierLedgerViewModel> >(_rawSqlService.GetAllSupplierLedger(companyId, branchId, "", "", "", phone, "").ToList());
}
else if (!string.IsNullOrEmpty(companyId) && !string.IsNullOrEmpty(branchId) && !string.IsNullOrEmpty(supplierId))
{
suppliervm = Mapper.Map <SupplierViewModel>(_supplierService.GetSupplierBySupplierId(supplierId));
supplierLedger = Mapper.Map <List <SupplierLedgerViewModel> >(_rawSqlService.GetAllSupplierLedger(companyId, branchId, "", "", "", "", supplierId).ToList());
}
return(View(new Tuple <IEnumerable <SupplierLedgerViewModel>, SupplierViewModel>(supplierLedger, suppliervm)));
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}