public TPlaningAllDTO GetInspectionPlanAll(string PID, string uploadPath, string actionPath)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
TPlaningAllDTO obj = new TPlaningAllDTO();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
string procName = "sp_T_Planing_AllReport";
try
{
dataTable = new DataTable();
adapter = new SqlDataAdapter();
SqlConnection conn = OpenConnection();
command = new SqlCommand(procName, conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@PID", PID));
da.SelectCommand = command;
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
#region T_Planing
obj.T_PlaningDT = ds.Tables[0].Copy();
obj.T_PlaningDT.TableName = "TPlaning";
obj.T_Planing_FilesDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[1].Copy(), "TPlaing_File", 2, uploadPath + "/" + PID);
obj.T_Planing_FilesDT.TableName = "TPlaing_File";
#endregion
#region T_Planing_Action_SiteSurvey
obj.T_Planing_SiteSurveyDT = ds.Tables[2].Copy();
obj.T_Planing_SiteSurveyDT.TableName = "Sitesurvey";
obj.T_Planing_SiteSurvey_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[3].Copy(), "TPlaing_File", 2, actionPath + "/SiteSurvey/" + PID + "/1");
obj.T_Planing_SiteSurvey_File1DT.TableName = "TPlaing_File";
obj.T_Planing_SiteSurvey_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[4].Copy(), "TPlaing_File", 2, actionPath + "/SiteSurvey/" + PID + "/2");
obj.T_Planing_SiteSurvey_File2DT.TableName = "TPlaing_File";
#endregion
#region Site Preparation
obj.T_Planing_SitePreparationDT = ds.Tables[5].Copy();
obj.T_Planing_SitePreparationDT.TableName = "SitePreparation";
obj.T_Planing_SitePreparation_FileDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[6].Copy(), "TPlaing_File", 4, actionPath + "/SitePreparation/" + PID + "/1");
obj.T_Planing_SitePreparation_FileDT.TableName = "TPlaing_File";
obj.T_Planing_SitePreparation_UnderDT = DTO.Util.ConvertX.ConvertToSitePreparationUnder(ds.Tables[7].Copy());
obj.T_Planing_SitePreparationDT.TableName = "SitePreparation_under";
#endregion
#region Weather Collection
obj.T_Planing_WeatherCollectionDT = ds.Tables[8].Copy();
#endregion
#region Before Coating Removal
obj.T_Planing_BFRemovalDT = ds.Tables[9].Copy();
obj.T_Planing_BFRemovalDT.TableName = "BeforeCoatingRemoval";
obj.T_Planing_BFRemoval_ConditionDT = ds.Tables[10].Copy();
obj.T_Planing_BFRemoval_ConditionDT.TableName = "BeforeCoatingRemoval_Condition";
obj.T_Planing_BFRemoval_ConditionDT.Columns.Add("File", typeof(byte[]));
foreach (DataRow drTemp in obj.T_Planing_BFRemoval_ConditionDT.Rows)
{
drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/BFRemoval/" + PID + "/3", drTemp["FileName"].ToString());
}
obj.T_Planing_BFRemoval_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[11].Copy(), "TPlaing_File", 2, actionPath + "/BFRemoval/" + PID + "/1");
obj.T_Planing_BFRemoval_File1DT.TableName = "TPlaing_File";
obj.T_Planing_BFRemoval_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[12].Copy(), "TPlaing_File", 2, actionPath + "/BFRemoval/" + PID + "/2");
obj.T_Planing_BFRemoval_File2DT.TableName = "TPlaing_File";
#endregion
#region After Coating Removal
obj.T_Planing_AFRemovalDT = ds.Tables[13].Copy();
obj.T_Planing_AFRemovalDT.TableName = "AfterCoatingRemoval";
obj.T_Planing_AFRemoval_DefectDT = ds.Tables[14].Copy();
obj.T_Planing_AFRemoval_DefectDT.TableName = "AfterCoatingRemoval_Defect";
foreach (DataRow drTemp in obj.T_Planing_AFRemoval_DefectDT.Rows)
{
drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/AfterRemoval/" + PID + "/1", drTemp["FileName"].ToString());
}
obj.T_Planing_AFRemoval_WallThicknessDT = ds.Tables[15].Copy();
obj.T_Planing_AFRemoval_WallThicknessDT.TableName = "AfterCoatingRemoval_WallThickness";
#endregion
#region AppliedCoating
obj.T_Planing_AppliedCoatingDT = ds.Tables[16].Copy();
obj.T_Planing_AppliedCoatingDT.TableName = "AppliedCoating";
obj.T_Planing_AppliedCoating_SurfaceProfileDT = ds.Tables[17].Copy();
obj.T_Planing_AppliedCoating_SurfaceProfileDT.TableName = "AppliedCoating_SurfaceProfile";
foreach (DataRow drTemp in obj.T_Planing_AppliedCoating_SurfaceProfileDT.Rows)
{
drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/AppliedCoating/" + PID + "/1", drTemp["FileName"].ToString());
}
obj.T_Planing_AppliedCoating_InformationDT = ds.Tables[18].Copy();
obj.T_Planing_AppliedCoating_InformationDT.TableName = "AppliedCoating_Information";
#endregion
#region After AppliedCoating
obj.T_Planing_AfterAppliedCoatingDT = ds.Tables[19].Copy();
obj.T_Planing_AfterAppliedCoatingDT.TableName = "AfterAppliedCoating";
obj.T_Planing_AfterAppliedCoating_DryFilmThicknessDT = ds.Tables[20].Copy();
obj.T_Planing_AfterAppliedCoating_DryFilmThicknessDT.TableName = "AfterAppliedCoating_DryFilmThickness";
obj.T_Planing_AfterAppliedCoating_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[21].Copy(), "TPlaing_File", 2, actionPath + "/AfterAppliedCoating/" + PID + "/1");
obj.T_Planing_AfterAppliedCoating_File1DT.TableName = "TPlaing_File";
obj.T_Planing_AfterAppliedCoating_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[22].Copy(), "TPlaing_File", 2, actionPath + "/AfterAppliedCoating/" + PID + "/2");
obj.T_Planing_AfterAppliedCoating_File2DT.TableName = "TPlaing_File";
#endregion
#region Site Recovery
obj.T_Planing_SiteRecoveryDT = ds.Tables[23].Copy();
obj.T_Planing_SiteRecoveryDT.TableName = "SiteRecovery";
obj.T_Planing_SiteRecovery_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[24].Copy(), "TPlaing_File", 2, actionPath + "/SiteRecovery/" + PID + "/1");
obj.T_Planing_SiteRecovery_File1DT.TableName = "TPlaing_File";
obj.T_Planing_SiteRecovery_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[25].Copy(), "TPlaing_File", 2, actionPath + "/SiteRecovery/" + PID + "/2");
obj.T_Planing_SiteRecovery_File2DT.TableName = "TPlaing_File";
#endregion
}
}
catch (Exception ex) { }
finally
{
CloseConnection();
}
return(obj);
}
public TPlaningAllDTO GetInspectionPlanAll(string PID, string uploadPath)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
TPlaningAllDTO obj = new TPlaningAllDTO();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
string procName = "sp_T_Planing_AllReport";
try
{
dataTable = new DataTable();
adapter = new SqlDataAdapter();
SqlConnection conn = OpenConnection();
command = new SqlCommand(procName, conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@PID", PID));
da.SelectCommand = command;
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
#region T_Planing
obj.T_PlaningDT = ds.Tables[0].Copy();
obj.T_PlaningDT.TableName = "TPlaning";
obj.T_Planing_FilesDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[1].Copy(), "TPlaing_File", 2, uploadPath);
obj.T_Planing_FilesDT.TableName = "TPlaing_File";
#endregion
#region T_Planing_Action_SiteSurvey
obj.T_Planing_SiteSurveyDT = ds.Tables[2].Copy();
obj.T_Planing_SiteSurveyDT.TableName = "Sitexurvey";
obj.T_Planing_SiteSurvey_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[3].Copy(), "TPlaing_File", 2, uploadPath);
obj.T_Planing_SiteSurvey_File1DT.TableName = "TPlaing_File";
obj.T_Planing_SiteSurvey_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[4].Copy(), "TPlaing_File", 2, uploadPath);
obj.T_Planing_SiteSurvey_File2DT.TableName = "TPlaing_File";
#endregion
#region Site Preparation
obj.T_Planing_SitePreparationDT = ds.Tables[5].Copy();
obj.T_Planing_SitePreparationDT.TableName = "SitePreparation";
obj.T_Planing_SitePreparation_FileDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[6].Copy(), "TPlaing_File", 4, uploadPath);
obj.T_Planing_SitePreparation_FileDT.TableName = "TPlaing_File";
obj.T_Planing_SitePreparation_UnderDT = DTO.Util.ConvertX.ConvertToSitePreparationUnder(ds.Tables[7].Copy());
obj.T_Planing_SitePreparationDT.TableName = "SitePreparation_under";
obj.T_Planing_WeatherCollectionDT = ds.Tables[8].Copy();
#endregion
}
}
catch (Exception ex) { }
finally
{
CloseConnection();
}
return(obj);
}
