public ActionResult ReportCategoryWiseSaleProfitLoss(string companyId, string branchId, string categoryId, string subCategoryId, string supplierId, string productId, string productCode, string dateFrom, string dateTo)
{
try
{
var dataSet = _rawSqlService.GetCategoryWiseSaleProfitLoss(companyId, branchId, supplierId, categoryId, subCategoryId, productId, productCode, dateFrom, dateTo);
return(View(dataSet));
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
//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.GetCategoryWiseSaleProfitLoss(companyId, branchId, supplierId, categoryId, subCategoryId, productId, productCode, dateFrom, dateTo));
// }
// return View(sales);
//}
//catch (Exception ex)
//{
// return JavaScript($"ShowResult('{ex.Message}','failure')");
//}
}