public List <AccountBillReportAC> ExportAccountBillReportList(SearchReportAC param, long userId) { List <AccountBillReportAC> _searchDataList = new List <AccountBillReportAC>(); try { SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); 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_GetEmpBillListExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <AccountBillReportAC>(ds.Tables[0]).ToList(); } } return(_searchDataList); } catch (Exception e) { return(new List <AccountBillReportAC>()); } }
public List <ReimbursementBillReportAC> ExportReimbursementBillReportList(SearchReportAC param, long userId) { List <ReimbursementBillReportAC> _searchDataList = new List <ReimbursementBillReportAC>(); try { SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); sl.Add("SMonth", param.Month); sl.Add("SYear", param.Year); sl.Add("Status", 0); DataSet ds = _objDalmysql.GetDataSet("usp_GetReimbursementBillsExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <ReimbursementBillReportAC>(ds.Tables[0]).ToList(); } } return(_searchDataList); } catch (Exception e) { return(new List <ReimbursementBillReportAC>()); } }
public List <AuditLogReportAC> ExportAuditLogReportList(SearchReportAC param, long userId) { List <AuditLogReportAC> _searchDataList = new List <AuditLogReportAC>(); try { SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); sl.Add("ActionId", Convert.ToInt32(param.ActionId)); sl.Add("UserId", 0); 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_GetAuditReportExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <AuditLogReportAC>(ds.Tables[0]).ToList(); } } return(_searchDataList); } catch (Exception e) { return(new List <AuditLogReportAC>()); } }
public List <PackageDetailListAC> ExportVendorWisePackageDetailList(SearchReportAC searchReportAC) { SortedList sl = new SortedList(); sl.Add("SearchValue", searchReportAC.SearchValue); List <PackageDetailListAC> searchDataList = new List <PackageDetailListAC>(); DataSet ds = _objDalmysql.GetDataSet("usp_GetVendorWisePackageExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { searchDataList = _objDal.ConvertDataTableToGenericList <PackageDetailListAC>(ds.Tables[0]).ToList(); } } return(searchDataList); }
public List <TransferDeActivatedReportAC> ExportTransferredDeactivatedList(SearchReportAC searchReportAC) { List <TransferDeActivatedReportAC> searchDataList = new List <TransferDeActivatedReportAC>(); SortedList sl = new SortedList(); sl.Add("SearchValue", searchReportAC.SearchValue); DataSet ds = _objDalmysql.GetDataSet("usp_GetTransferredDeactivatedExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { searchDataList = _objDal.ConvertDataTableToGenericList <TransferDeActivatedReportAC>(ds.Tables[0]).ToList(); } } return(searchDataList); }
public List <MemoReportListAC> ExportAccountMemoReportList(SearchReportAC param) { List <MemoReportListAC> searchDataList = new List <MemoReportListAC>(); SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); sl.Add("SMonth", param.Month); sl.Add("SYear", param.Year); sl.Add("ProviderId", param.ProviderId); DataSet ds = _objDalmysql.GetDataSet("usp_GetMemoListReportExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { searchDataList = _objDal.ConvertDataTableToGenericList <MemoReportListAC>(ds.Tables[0]).ToList(); } } return(searchDataList); }
public List <UserConsumptionReportAC> ExportUserConsumptionReportList(SearchReportAC param, long userId) { List <UserConsumptionReportAC> _searchDataList = new List <UserConsumptionReportAC>(); try { if (param.Month > 0 && param.Year > 0) { SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); sl.Add("SMonth", param.Month); sl.Add("SYear", param.Year); sl.Add("ProviderId", param.ProviderId); sl.Add("BillStatusId", param.StatusId);// pass 5 for close bill DataSet ds = _objDalmysql.GetDataSet("usp_GetUserConsumptionReportExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <UserConsumptionReportAC>(ds.Tables[0]).ToList(); } } return(_searchDataList); } else { return(new List <UserConsumptionReportAC>()); } } catch (Exception e) { return(new List <UserConsumptionReportAC>()); } }
public List <HighestUserConsumptionReportAC> GetUsersHighestConsumptionReport(SearchReportAC param, long userId) { List <HighestUserConsumptionReportAC> _searchDataList = new List <HighestUserConsumptionReportAC>(); try { if (param.Month > 0 && param.Year > 0 && param.MultipleItems != null && param.MultipleItems.Count() > 0) { string TypeIds = string.Empty; List <long> idlst = new List <long>(); idlst = param.MultipleItems.Select(x => x.Id).ToList(); TypeIds = string.Join(",", idlst.Distinct().Select(x => x.ToString()).ToArray()); SortedList sl = new SortedList(); sl.Add("SMonth", param.Month); sl.Add("SYear", param.Year); sl.Add("ProviderId", param.ProviderId); sl.Add("TransTypeIds", TypeIds); DataSet ds = _objDalmysql.GetDataSet("usp_GetUsersHighestComputionReportProviderWise", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <HighestUserConsumptionReportAC>(ds.Tables[0]).ToList(); } } } return(_searchDataList); } catch (Exception e) { return(new List <HighestUserConsumptionReportAC>()); } }
public List <MultipleLinesUserListReportAC> ExportMultipleLinesUserListReportList(SearchReportAC param, long userId) { List <MultipleLinesUserListReportAC> _searchDataList = new List <MultipleLinesUserListReportAC>(); try { SortedList sl = new SortedList(); sl.Add("SearchValue", param.SearchValue); DataSet ds = _objDalmysql.GetDataSet("usp_GetUserWithMultipleLinesExport", sl); if (ds != null) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null) { _searchDataList = _objDal.ConvertDataTableToGenericList <MultipleLinesUserListReportAC>(ds.Tables[0]).ToList(); } } return(_searchDataList); } catch (Exception e) { return(new List <MultipleLinesUserListReportAC>()); } }