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); } }