public ActionResult ReportCounterWiseSale(string companyId, string branchId, string dateFrom, string dateTo)
{
try
{
if (!string.IsNullOrEmpty(dateFrom))
{
DateTime?dfrom = Convert.ToDateTime(dateFrom);
dfrom = new DateTime(dfrom.Value.Year, dfrom.Value.Month, dfrom.Value.Day, 0, 0, 0);
dateFrom = dfrom.Value.ToString(CultureInfo.InvariantCulture);
}
if (!string.IsNullOrEmpty(dateTo))
{
DateTime?dto = Convert.ToDateTime(dateTo);
dto = new DateTime(dto.Value.Year, dto.Value.Month, dto.Value.Day, 23, 59, 59);
dateTo = dto.Value.ToString(CultureInfo.InvariantCulture);
}
IEnumerable <SuperShopSaleViewModel> sales = new List <SuperShopSaleViewModel>();
if (!string.IsNullOrEmpty(companyId))
{
sales = Mapper.Map <IEnumerable <SuperShopSaleViewModel> >(_rawSqlService.GetCounterWiseSale(companyId, branchId, dateFrom, dateTo));
}
return(View(sales));
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}