public List <SearchDaliyCashSheetReportResultVM> SearchDailyCashSeetReport(SearchDailyCashSheetParameterVM model, string sortColumn, string sortDirection)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@PageNum", Value = model.PageNum
},
new SqlParameter {
ParameterName = "@PageSize", Value = model.PageSize
},
new SqlParameter {
ParameterName = "@SortColumn", Value = sortColumn
},
new SqlParameter {
ParameterName = "@SortDirection", Value = sortDirection
},
new SqlParameter {
ParameterName = "@CreatedBy", Value = model.UserId
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("GetDailyCashSheetList", parameters);
var dailycashsheet = new List <SearchDaliyCashSheetReportResultVM>();
dailycashsheet = DALHelper.CreateListFromTable <SearchDaliyCashSheetReportResultVM>(dt);
return(dailycashsheet);
}
public ActionResult SearchDaliyCashReport(SearchDailyCashSheetParameterVM model)
{
try
{
object sortColumn = "";
object sortDirection = "";
if (model.order.Count == 0)
{
sortColumn = "CreatedOn";
sortDirection = "desc";
}
else
{
sortColumn = model.columns[Convert.ToInt32(model.order[0].column)].data ?? (object)DBNull.Value;
sortDirection = model.order[0].dir ?? (object)DBNull.Value;
}
model.PageSize = Constants.PAGESIZE;
model.UserId = LogInManager.LoggedInUserId;
var DailyCashSheet = dailyCashSheetRepository.SearchDailyCashSeetReport(model, Convert.ToString(sortColumn), Convert.ToString(sortDirection));
var ConvertAmountToUserCurrency = DailyCashSheet.Select(m => new
{
TotalAmount = CurrencyManager.ParseAmountToUserCurrency(m.TotalAmount, LogInManager.CurrencyCode),
RowNum = m.RowNum,
CreatedDate = m.CreatedDate,
TotalCount = m.TotalCount
}).ToList();
int totalRecords = 0;
var dbRecords = DailyCashSheet.Select(m => m.TotalCount).FirstOrDefault();
if (dbRecords != 0)
{
totalRecords = Convert.ToInt32(dbRecords);
}
#region Record Activity Log
RecordActivityLog.RecordActivity(Pages.DAILY_CASHSHEET_REPORT, "Searched daily cashsheet report.");
#endregion
return(Json(new
{
IsSuccess = true,
CurrentPage = model.PageNum,
PageSize = Constants.PAGESIZE,
TotalRecords = totalRecords,
data = ConvertAmountToUserCurrency
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "SearchBreakfastReport");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}