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