/// <summary>
/// Generates daily reports for multiple days.
/// </summary>
/// <param name="generateDate"></param>
/// <param name="ischecked"></param>
public void GenerateDailyRptForMultiDays(DateTime generateDate)
{
DateTime todayDate = DateTime.Now;
int delayDays = (generateDate - todayDate).Days; //get number for store procedure parameter
int startDelayDays = delayDays - 2; //get number for store procedure parameter
string StartDateStr = generateDate.AddDays(-3).ToString("yyyy-MM-dd");
string EndDateStr = generateDate.AddDays(-1).ToString("yyyy-MM-dd");
string filename1W = "Service and TricareDaily.xls";
string[] sheetnameW = new string[5] {
"ServiceMgRpt", "AssignedInAndOut_Service", "IM", "SR", "PM"
};
string[] ProcNamesW = new string[5] {
"ServiceMgRptByNumbers"
, "sp_TaskInAndOut_ServiceRPT"
, "IMRpt_TricareForMulti"
, "SRRpt_TricareForMulti"
, "PBLMRpt_TricareForMulti"
};
string[,] ParamsW = new string[5, 2] {
{ delayDays.ToString(), startDelayDays.ToString() }
, { "", "" }
, { delayDays.ToString(), startDelayDays.ToString() }
, { delayDays.ToString(), startDelayDays.ToString() }
, { delayDays.ToString(), startDelayDays.ToString() }
};
//prds.ExecuteProcWithParam(filename1W, ProcNamesW, sheetnameW, ParamsW, ischecked);
DBAccess dbAccess = new DBAccess();
dbAccess.ExecuteProcWithParam(filename1W, ProcNamesW, sheetnameW, ParamsW, true, generateDate);
//Annuity and Compensation daily reports
string AEfilename = "Annuity and EBusiness.xls";
string[] AEWorksheetName = new string[4] {
"AnnuityRpt",
"AnnuityStatus",
"AnnuityFinal",
"EBusinessRpt Grouped"
};
//Porcedure names and datatable names
string[] AEProcName = new string[6] {
"AnnuityRpt", //{1,1}
"AnnuityOpenPeriod", //{51,2}
"AnnuityUrgent", //{61,2}
"AnnuityStatus", //{1,1}
"AnnuityStatusUrgent", //{73,2}
"EBusinessRpt"
}; //{123,2}
//Params of procedures
string[,] AEParam = new string[6, 3] {
{ StartDateStr, EndDateStr, "1" },
{ StartDateStr, EndDateStr, "1" },
{ StartDateStr, EndDateStr, "1" },
{ "", "", "" },
{ "", "", "" },
{ StartDateStr, EndDateStr, "1" }
};
//Row number of excel when write the ds data into excel
int[] sheetWriteStartRow = new int[6] {
1, 89, 99, 1, 109, 2
};
DataSet dsOfAE = dbAccess.getDSByProcs(AEProcName, AEParam);
ExcelBus excelBiz = new ExcelBus();
excelBiz.AEExportDataToExcel(AEfilename, AEProcName, AEWorksheetName, dsOfAE, sheetWriteStartRow, generateDate);
//EBusiness backlog tickets
string[] ProcName = new string[1] {
"getEBusinessData"
};
string[,] Param = new string[1, 1] {
{ "" }
};
string[] sheetnameE = new string[1] {
"EBusiness Raw Data"
};
string filenameE = "EBusiness ticket.xls";
dbAccess.ExecuteProcWithParam(filenameE, ProcName, sheetnameE, Param, false, generateDate);
//Annuity backlog tickets
string[] ProcNameAnnuity = new string[1] {
"getAnnuityData"
};
string[,] ParamAnnuity = new string[1, 1] {
{ "" }
};
string[] sheetnameAnnuity = new string[1] {
"Annuity Raw Data"
};
string filenameAnnuity = "Annuity ticket.xls";
dbAccess.ExecuteProcWithParam(filenameAnnuity, ProcNameAnnuity, sheetnameAnnuity, ParamAnnuity, false, generateDate);
}
/// <summary>
/// Generates daily reports for multiple days.
/// </summary>
/// <param name="generateDate"></param>
/// <param name="ischecked"></param>
public void GenerateDailyRptForMultiDays(DateTime generateDate)
{
DateTime todayDate = DateTime.Now;
int delayDays = (generateDate - todayDate).Days;//get number for store procedure parameter
int startDelayDays = delayDays - 2;//get number for store procedure parameter
string StartDateStr = generateDate.AddDays(-3).ToString("yyyy-MM-dd");
string EndDateStr = generateDate.AddDays(-1).ToString("yyyy-MM-dd");
string filename1W = "Service and TricareDaily.xls";
string[] sheetnameW = new string[5] { "ServiceMgRpt", "AssignedInAndOut_Service", "IM", "SR", "PM" };
string[] ProcNamesW = new string[5] {
"ServiceMgRptByNumbers"
, "sp_TaskInAndOut_ServiceRPT"
, "IMRpt_TricareForMulti"
, "SRRpt_TricareForMulti"
, "PBLMRpt_TricareForMulti" };
string[,] ParamsW = new string[5, 2] {
{ delayDays.ToString(), startDelayDays.ToString() }
, { "", "" }
, { delayDays.ToString(), startDelayDays.ToString() }
, { delayDays.ToString(), startDelayDays.ToString() }
, { delayDays.ToString(), startDelayDays.ToString() }
};
//prds.ExecuteProcWithParam(filename1W, ProcNamesW, sheetnameW, ParamsW, ischecked);
DBAccess dbAccess = new DBAccess();
dbAccess.ExecuteProcWithParam(filename1W, ProcNamesW, sheetnameW, ParamsW, true, generateDate);
//Annuity and Compensation daily reports
string AEfilename = "Annuity and EBusiness.xls";
string[] AEWorksheetName = new string[4] {
"AnnuityRpt",
"AnnuityStatus" ,
"AnnuityFinal",
"EBusinessRpt Grouped"
};
//Porcedure names and datatable names
string[] AEProcName = new string[6] {
"AnnuityRpt", //{1,1}
"AnnuityOpenPeriod", //{51,2}
"AnnuityUrgent", //{61,2}
"AnnuityStatus", //{1,1}
"AnnuityStatusUrgent" ,//{73,2}
"EBusinessRpt"
}; //{123,2}
//Params of procedures
string[,] AEParam = new string[6, 3] {
{ StartDateStr,EndDateStr , "1" },
{ StartDateStr,EndDateStr, "1" },
{ StartDateStr,EndDateStr, "1" },
{"","",""},
{"","",""},
{ StartDateStr,EndDateStr, "1" }
};
//Row number of excel when write the ds data into excel
int[] sheetWriteStartRow = new int[6] { 1, 89, 99, 1, 109, 2 };
DataSet dsOfAE = dbAccess.getDSByProcs(AEProcName, AEParam);
ExcelBus excelBiz = new ExcelBus();
excelBiz.AEExportDataToExcel(AEfilename, AEProcName, AEWorksheetName, dsOfAE, sheetWriteStartRow, generateDate);
//EBusiness backlog tickets
string[] ProcName = new string[1] { "getEBusinessData" };
string[,] Param = new string[1, 1] { { "" } };
string[] sheetnameE = new string[1] { "EBusiness Raw Data" };
string filenameE = "EBusiness ticket.xls";
dbAccess.ExecuteProcWithParam(filenameE, ProcName, sheetnameE, Param, false, generateDate);
//Annuity backlog tickets
string[] ProcNameAnnuity = new string[1] { "getAnnuityData" };
string[,] ParamAnnuity = new string[1, 1] { { "" } };
string[] sheetnameAnnuity = new string[1] { "Annuity Raw Data" };
string filenameAnnuity = "Annuity ticket.xls";
dbAccess.ExecuteProcWithParam(filenameAnnuity, ProcNameAnnuity, sheetnameAnnuity, ParamAnnuity, false, generateDate);
}
