public ActionResult ReportSaleClosing(string dateFrom, string dateTo) { try { var identity = (LoginIdentity)Thread.CurrentPrincipal.Identity; 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(dateFrom)) { sales = Mapper.Map <IEnumerable <SuperShopSaleViewModel> >(_rawSqlService.GetAllSaleClosing(identity.CompanyId, identity.BranchId, dateFrom, dateTo, identity.Name)); } return(View(sales)); } catch (Exception ex) { return(JavaScript($"ShowResult('{ex.Message}','failure')")); } }