public ActionResult RdlcReportSaleClosing(string companyId, string branchId, string dateFrom, string dateTo, string salePersonId)
{
try
{
//if (branchId == "null")
//{
// branchId = "";
//}
//if (dateFrom == "null")
//{
// dateFrom = "";
//}
//if (dateTo == "null")
//{
// dateTo = "";
//}
//if (salePersonId == "null")
//{
// salePersonId = "";
//}
//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);
//}
//
//if (!string.IsNullOrEmpty(companyId))
//{
// dataSet = _rawSqlService.ReportGetAllSaleClosing(companyId, branchId, dateFrom, dateTo, salePersonId);
// //sales = Mapper.Map<IEnumerable<SuperShopSaleViewModel>>(_rawSqlService.GetAllSaleClosing(companyId, branchId, dateFrom, dateTo, salePersonId));
//}
var dataSet = _rawSqlService.ReportGetAllSaleClosing(companyId, branchId, dateFrom, dateTo, salePersonId);
ReportDataSource rpt = new ReportDataSource("Sale", dataSet.Tables[0]);
RdlcReportViewerWithDate.reportDataSource = rpt;
string rPath = "RdlcReport/RptSaleClosing.rdlc";
Response.Redirect("~/ReportViewer/RdlcReportViewerWithDate.aspx?rPath=" + rPath + "&dfrom=" + dateFrom + "&dto=" + dateTo + "&companyId=" + companyId + "&branchId=" + branchId);
return(View());
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}