public ExcelHelper GetExcelFile()
{
if (_SingleExcelHelper == null)
{
_SingleExcelHelper = new ExcelHelper();
_SingleExcelHelper.Create();
}
return _SingleExcelHelper;
}
public ExcelHelper GetExcelFileByPath(string FilePath)
{
if (_SingleExcelHelper == null)
{
_SingleExcelHelper = new ExcelHelper();
_SingleExcelHelper.GetCreated(FilePath);
_FilePath = FilePath;
}
return _SingleExcelHelper;
}
public void Release()
{
if (xlWorkBook != null)
{
xlWorkBook = null;
}
if (xlApp != null)
{
xlApp.Quit();
xlApp = null;
_SingleExcelHelper = null;
GC.Collect();
GC.WaitForPendingFinalizers();
}
}
public bool GetResourceReport()
{
try
{
DataTable departmentNamesWithTeamSize = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByManCount_ExcelTeam");
DataView dv = departmentNamesWithTeamSize.DefaultView;
dv.Sort = departmentNamesWithTeamSize.Columns[0].Caption;
DataTable sortedDepartmentNamesWithTeamSize = dv.ToTable();
for (int i = 0; i < departmentNamesWithTeamSize.Rows.Count; i++)
{
DataTable teamNamesWithTeamSize = spHelper.GetData_withSpNameAndParameter("sp_FunctionTeam_MH_Report_ByManCount_byTeamName", sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0].ToString());
xlHelper = xlHelper.GetExcelFileByPath(Environment.CurrentDirectory + @"\PKL_Kaynak.xlsm");
#region HS Kadro Data
DataTable departmentNameWithTeamSize = sortedDepartmentNamesWithTeamSize.Clone();
departmentNameWithTeamSize.Rows.Add(sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray);
xlHelper.ExportDataTable2TemplateSheetExpress(departmentNameWithTeamSize, "HS Kadro-Data", 1, true);
xlHelper.ExportDataTable2TemplateSheetExpress(teamNamesWithTeamSize, "HS Kadro-Data", 49, true);
#endregion
#region Ekip Bazında Data
DataTable squadNamesWithMh = spHelper.GetData_withSpNameAndParameter("sp_FunctionTeam_MH_Report_ByTeam_WithParameterTeamName", sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0].ToString());
xlHelper.ExportDataTable2TemplateSheetExpress(squadNamesWithMh, "Ekip Bazında-Data", 1, true);
#endregion
#region HS Kaynak Planı
DataTable hsSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByPlatform");
xlHelper.ExportDataTable2TemplateSheetExpress(hsSourcePlan, "HS Kaynak Planı", 1, true);
//
hsSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByPlatform_Cumulative_Excel");
xlHelper.ExportDataTable2TemplateSheetExpress(hsSourcePlan, "HS Kaynak Planı", 12, false);
//
hsSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_GetDate");
xlHelper.ExportDataTable2TemplateSheetExpress(hsSourcePlan, "HS Kaynak Planı", 25, false);
//
hsSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByPlatform_LastWeek");
xlHelper.ExportDataTable2TemplateSheetExpress(hsSourcePlan, "HS Kaynak Planı", 59, false);
//
hsSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByPlatform_LastWeek_Cumulative");
xlHelper.ExportDataTable2TemplateSheetExpress(hsSourcePlan, "HS Kaynak Planı", 70, false);
//
#endregion
#region MP Kaynak Planı
DataTable mpSourcePlan = spHelper.GetData_withSpName("sp_FunctionTeam_GetDate");
xlHelper.ExportDataTable2TemplateSheetExpress(mpSourcePlan, "MP Kaynak Planı", 25, false);
#endregion
#region Proje Bazında Grafik
DataTable graphicsBasedOnProject = spHelper.GetData_withSpName("sp_FunctionTeam_MH_Report_ByProject");
xlHelper.ExportDataTable2TemplateSheetExpress(graphicsBasedOnProject, "Proje Bazında-Grafik", 11, true);
#endregion
if (sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0].ToString().Contains("/"))
{
xlHelper.SaveCopyAs(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\" + sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0].ToString().Split('/')[0].Trim() + "_" + sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0].ToString().Split('/')[1].Trim() + "_Report", ".xlsm");
xlHelper.ForceRelease();
}
else
{
xlHelper.SaveCopyAs(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\" + sortedDepartmentNamesWithTeamSize.Rows[i].ItemArray[0] + "_Report", ".xlsm");
xlHelper.ForceRelease();
}
}
return true;
}
catch (Exception)
{
throw;
return false;
}
}
public ReportManager()
{
xlHelper = new ExcelHelper();
}