public void PrepareFilesForDailyReport(DateTime generateDate)
{
String dweek = generateDate.DayOfWeek.ToString();
DateTime priorWeekDate = generateDate.AddDays(-8);
DateTime priorWeekDateS = generateDate.AddDays(-10);
DateTime FridayDate = generateDate.AddDays(-3);
DateTime dTodayLinkDate = generateDate.AddDays(-1);
DateTime rTodayLinkDate = dweek == "Monday" ? generateDate.AddDays(-4) : generateDate.AddDays(-2);
string tldDate = dTodayLinkDate.ToString("yyyyMMdd");
string tlrDate = rTodayLinkDate.ToString("yyyyMMdd");
string pWeekDate = priorWeekDate.ToString("yyyyMMdd");
string rDatey = rTodayLinkDate.Year.ToString();
string rDatem = rTodayLinkDate.ToString("MM");
string rDated = rTodayLinkDate.ToString("dd");
string dDatey = dTodayLinkDate.Year.ToString();
string dDatem = dTodayLinkDate.ToString("MM");
string dDated = dTodayLinkDate.ToString("dd");
ExcelHelper excelHelper = new ExcelHelper();
//export today link
string ssisPathTodaylink = packagePath + "todaylink.dtsx";
string excelFullNameTodaylink = excelHelper.getFilenamePF(generateDate) + @"\" + dDatem + dDated + dDatey + "(Exclude Closed Before 6302009).xls";
excelHelper.ExportDataBySSIS(ssisPathTodaylink, excelFullNameTodaylink);
//export Tricare dump
string ssisPathTricareDaily = packagePath + "tricaredaily.dtsx";
string excelFullNameTricareDaily = excelHelper.getFilenamePF(generateDate) + @"\" + "Track Wise Dump-" + dDatem + dDated + dDatey + ".xls";
excelHelper.ExportDataBySSIS(ssisPathTricareDaily, excelFullNameTricareDaily);
//Annuity and Ebusiness report
File.Copy(finalReportsPath + tldDate + @"\" + "Annuity and EBusiness-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Annuity and EBusiness-" + dDatem + dDated + ".xls", true);
////business surpport backlog report
File.Copy(finalReportsPath + tldDate + @"\" + "Service and TricareDaily-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Service and TricareDaily-" + dDatem + dDated + ".xls", true);
////service remedy group level report
File.Copy(finalReportsPath + tldDate + @"\" + "Service Remedy Group Level Report-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Service Remedy Group Level Report-" + dDatem + dDated + ".xls", true);
////ebusiness dump
File.Copy(finalReportsPath + tldDate + @"\" + "EBusiness ticket-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "EBusiness ticket-" + dDatem + dDated + dDatey + ".xls", true);
////annuity backlog dump
File.Copy(finalReportsPath + tldDate + @"\" + "Annuity ticket-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Annuity ticket-" + dDatem + dDated + dDatey + ".xls", true);
System.Diagnostics.Process.Start("explorer.exe", excelHelper.getFilenamePF(generateDate));
}
public void PrepareFilesForDailyReport(DateTime generateDate)
{
String dweek = generateDate.DayOfWeek.ToString();
DateTime priorWeekDate = generateDate.AddDays(-8);
DateTime priorWeekDateS = generateDate.AddDays(-10);
DateTime FridayDate = generateDate.AddDays(-3);
DateTime dTodayLinkDate = generateDate.AddDays(-1);
DateTime rTodayLinkDate = dweek == "Monday" ? generateDate.AddDays(-4) : generateDate.AddDays(-2);
string tldDate = dTodayLinkDate.ToString("yyyyMMdd");
string tlrDate = rTodayLinkDate.ToString("yyyyMMdd");
string pWeekDate = priorWeekDate.ToString("yyyyMMdd");
string rDatey = rTodayLinkDate.Year.ToString();
string rDatem = rTodayLinkDate.ToString("MM");
string rDated = rTodayLinkDate.ToString("dd");
string dDatey = dTodayLinkDate.Year.ToString();
string dDatem = dTodayLinkDate.ToString("MM");
string dDated = dTodayLinkDate.ToString("dd");
ExcelHelper excelHelper = new ExcelHelper();
//export today link
string ssisPathTodaylink = packagePath + "todaylink.dtsx";
string excelFullNameTodaylink = excelHelper.getFilenamePF(generateDate) + @"\" + dDatem + dDated + dDatey + "(Exclude Closed Before 6302009).xls";
excelHelper.ExportDataBySSIS(ssisPathTodaylink, excelFullNameTodaylink);
//export Tricare dump
string ssisPathTricareDaily = packagePath + "tricaredaily.dtsx";
string excelFullNameTricareDaily = excelHelper.getFilenamePF(generateDate) + @"\" + "Track Wise Dump-" + dDatem + dDated + dDatey + ".xls";
excelHelper.ExportDataBySSIS(ssisPathTricareDaily, excelFullNameTricareDaily);
//Annuity and Ebusiness report
File.Copy(finalReportsPath + tldDate + @"\" + "Annuity and EBusiness-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Annuity and EBusiness-" + dDatem + dDated + ".xls", true);
////business surpport backlog report
File.Copy(finalReportsPath + tldDate + @"\" + "Service and TricareDaily-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Service and TricareDaily-" + dDatem + dDated + ".xls", true);
////service remedy group level report
File.Copy(finalReportsPath + tldDate + @"\" + "Service Remedy Group Level Report-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Service Remedy Group Level Report-" + dDatem + dDated + ".xls", true);
////ebusiness dump
File.Copy(finalReportsPath + tldDate + @"\" + "EBusiness ticket-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "EBusiness ticket-" + dDatem + dDated + dDatey + ".xls", true);
////annuity backlog dump
File.Copy(finalReportsPath + tldDate + @"\" + "Annuity ticket-" + dDatem + dDated + ".xls", excelHelper.getFilenamePF(generateDate) + @"\" + "Annuity ticket-" + dDatem + dDated + dDatey + ".xls", true);
System.Diagnostics.Process.Start("explorer.exe", excelHelper.getFilenamePF(generateDate));
}
