public async Task <IActionResult> GetPreviousPeriodBills([FromBody] JqueryDataWithExtraParameterAC param)
{
string userId = HttpContext.User.Claims.FirstOrDefault(c => c.Type == "user_id").Value;
var results = await _iBillProcessRepository.GetPreviousPeriodBills(param, Convert.ToInt64(userId));
return(new JsonResult(new JqueryDataTablesResult <CurrentBillAC>
{
Draw = param.DataTablesParameters.Draw,
Data = results.Items,
RecordsFiltered = results.TotalSize,
RecordsTotal = results.TotalSize
}));
}
public JqueryDataTablesPagedResults <MemoReportListAC> GetAccountMemoReport(JqueryDataWithExtraParameterAC param)
{
JqueryDataTablesPagedResults <MemoReportListAC> _searchData = new JqueryDataTablesPagedResults <MemoReportListAC>();
int totalsize = 0;
List <MemoReportListAC> _searchDataList = new List <MemoReportListAC>();
int skip = (param.DataTablesParameters.Start / param.DataTablesParameters.Length) * param.DataTablesParameters.Length;
int take = param.DataTablesParameters.Length;
SortedList sl = new SortedList();
sl.Add("SkipRecord", skip);
sl.Add("Length", take);
sl.Add("SearchValue", param.DataTablesParameters.Search.Value);
sl.Add("SMonth", param.Month);
sl.Add("SYear", param.Year);
sl.Add("ProviderId", param.ProviderId);
DataSet ds = _objDalmysql.GetDataSet("usp_GetMemoListReportWithPagging", sl);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null)
{
_searchDataList = _objDal.ConvertDataTableToGenericList <MemoReportListAC>(ds.Tables[0]).ToList();
}
if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
{
totalsize = Convert.ToInt16(ds.Tables[1].Rows[0]["TotalSize"]);
}
}
return(new JqueryDataTablesPagedResults <MemoReportListAC>
{
Items = _searchDataList,
TotalSize = totalsize
});
}
public JqueryDataTablesPagedResults <UserConsumptionReportAC> GetUserConsumptionSearchReportList(JqueryDataWithExtraParameterAC param, long userId)
{
JqueryDataTablesPagedResults <OperatorLogReportAC> _searchData = new JqueryDataTablesPagedResults <OperatorLogReportAC>();
int totalsize = 0;
List <UserConsumptionReportAC> _searchDataList = new List <UserConsumptionReportAC>();
try
{
int skip = (param.DataTablesParameters.Start / param.DataTablesParameters.Length) * param.DataTablesParameters.Length;
int take = param.DataTablesParameters.Length;
int? sortColumnNumber = null;
string sortType = string.Empty;
if (param.DataTablesParameters.Order.Length > 0)
{
sortColumnNumber = param.DataTablesParameters.Order[0].Column;
sortType = param.DataTablesParameters.Order[0].Dir.ToString();
}
if (param.Month > 0 && param.Year > 0)
{
SortedList sl = new SortedList();
sl.Add("SkipRecord", skip);
sl.Add("Length", take);
sl.Add("SearchValue", param.DataTablesParameters.Search.Value);
sl.Add("SMonth", param.Month);
sl.Add("SYear", param.Year);
sl.Add("ProviderId", param.ProviderId);
sl.Add("BillStatusId", param.StatusId); // pass 5 if close bill else open bill
DataSet ds = _objDalmysql.GetDataSet("usp_GetUserConsumptionReportWithPagging", sl);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null)
{
_searchDataList = _objDal.ConvertDataTableToGenericList <UserConsumptionReportAC>(ds.Tables[0]).ToList();
}
if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
{
totalsize = Convert.ToInt16(ds.Tables[1].Rows[0]["TotalSize"]);
}
}
return(new JqueryDataTablesPagedResults <UserConsumptionReportAC>
{
Items = _searchDataList,
TotalSize = totalsize
});
}
else
{
return(new JqueryDataTablesPagedResults <UserConsumptionReportAC>
{
Items = new List <UserConsumptionReportAC>(),
TotalSize = 0
});
}
}
catch (Exception e)
{
return(null);
}
}
public JqueryDataTablesPagedResults <AccountBillReportAC> GetAccountBillSearchReportList(JqueryDataWithExtraParameterAC param, long userId)
{
JqueryDataTablesPagedResults <AccountBillReportAC> _searchData = new JqueryDataTablesPagedResults <AccountBillReportAC>();
int totalsize = 0;
List <AccountBillReportAC> _searchDataList = new List <AccountBillReportAC>();
try
{
int skip = (param.DataTablesParameters.Start / param.DataTablesParameters.Length) * param.DataTablesParameters.Length;
int take = param.DataTablesParameters.Length;
int? sortColumnNumber = null;
string sortType = string.Empty;
if (param.DataTablesParameters.Order.Length > 0)
{
sortColumnNumber = param.DataTablesParameters.Order[0].Column;
sortType = param.DataTablesParameters.Order[0].Dir.ToString();
}
SortedList sl = new SortedList();
sl.Add("SkipRecord", skip);
sl.Add("Length", take);
sl.Add("SearchValue", param.DataTablesParameters.Search.Value);
sl.Add("SMonth", param.Month);
sl.Add("SYear", param.Year);
sl.Add("ProviderId", param.ProviderId);
sl.Add("UserId", param.UserId);
sl.Add("BusinessUnitId", param.BusinessUnitId);
sl.Add("CostCenterId", param.CostCenterId);
DataSet ds = _objDalmysql.GetDataSet("usp_GetEmpBillListReportWithPagging", sl);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null)
{
_searchDataList = _objDal.ConvertDataTableToGenericList <AccountBillReportAC>(ds.Tables[0]).ToList();
}
if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
{
totalsize = Convert.ToInt16(ds.Tables[1].Rows[0]["TotalSize"]);
}
}
return(new JqueryDataTablesPagedResults <AccountBillReportAC>
{
Items = _searchDataList,
TotalSize = totalsize
});
}
catch (Exception e)
{
return(null);
}
}
public JqueryDataTablesPagedResults <OperatorLogReportAC> GetOperatorCallLogSearchReportList(JqueryDataWithExtraParameterAC param, long userId)
{
JqueryDataTablesPagedResults <OperatorLogReportAC> _searchData = new JqueryDataTablesPagedResults <OperatorLogReportAC>();
int totalsize = 0;
List <OperatorLogReportAC> _searchDataList = new List <OperatorLogReportAC>();
try
{
int skip = (param.DataTablesParameters.Start / param.DataTablesParameters.Length) * param.DataTablesParameters.Length;
int take = param.DataTablesParameters.Length;
int? sortColumnNumber = null;
string sortType = string.Empty;
if (param.DataTablesParameters.Order.Length > 0)
{
sortColumnNumber = param.DataTablesParameters.Order[0].Column;
sortType = param.DataTablesParameters.Order[0].Dir.ToString();
}
SortedList sl = new SortedList();
sl.Add("SkipRecord", skip);
sl.Add("Length", take);
sl.Add("SearchValue", param.DataTablesParameters.Search.Value);
sl.Add("SMonth", param.Month);
sl.Add("SYear", param.Year);
sl.Add("EmployeeName", param.EmployeeName);
if (param.start != null)
{
DateTime StartDate = new DateTime();
StartDate = param.start ?? System.DateTime.Now;
DateTime newStartDate = StartDate.AddDays(1);
int dateFrom = Convert.ToInt32(newStartDate.ToString("yyyyMMdd"));
sl.Add("DateFrom", dateFrom);
}
else
{
sl.Add("DateFrom", 0);
}
if (param.end != null)
{
DateTime EndDate = new DateTime();
EndDate = param.end ?? System.DateTime.Now;
DateTime newEndDate = EndDate.AddDays(1);
int Dateto = Convert.ToInt32(newEndDate.ToString("yyyyMMdd"));
sl.Add("DateTo", Dateto);
}
else
{
sl.Add("DateTo", 0);
}
DataSet ds = _objDalmysql.GetDataSet("usp_GetCallLogReportWithPagging", sl);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null)
{
_searchDataList = _objDal.ConvertDataTableToGenericList <OperatorLogReportAC>(ds.Tables[0]).ToList();
}
if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
{
totalsize = Convert.ToInt16(ds.Tables[1].Rows[0]["TotalSize"]);
}
}
return(new JqueryDataTablesPagedResults <OperatorLogReportAC>
{
Items = _searchDataList,
TotalSize = totalsize
});
}
catch (Exception e)
{
return(null);
}
}
