public void showDatatoControl(int ID)
{
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
EQUIPMENT_MASTER_BUS equipmentMasterBus = new EQUIPMENT_MASTER_BUS();
DESIGN_CODE_BUS designCodeBus = new DESIGN_CODE_BUS();
SITES_BUS siteBus = new SITES_BUS();
FACILITY_BUS facilityBus = new FACILITY_BUS();
MANUFACTURER_BUS manuBus = new MANUFACTURER_BUS();
RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS();
COMPONENT_MASTER_BUS comMaBus = new COMPONENT_MASTER_BUS();
COMPONENT_TYPE__BUS comTypeBus = new COMPONENT_TYPE__BUS();
API_COMPONENT_TYPE_BUS apiComponentBus = new API_COMPONENT_TYPE_BUS();
int[] equipmentID_componentID = rwAssBus.getEquipmentID_ComponentID(ID);
EQUIPMENT_MASTER eqMa = equipmentMasterBus.getData(equipmentID_componentID[0]);
COMPONENT_MASTER comMa = comMaBus.getData(equipmentID_componentID[1]);
RW_ASSESSMENT ass = rwAssBus.getData(ID);
txtAssessmentName.Text = ass.ProposalName;
dateAssessmentDate.DateTime = ass.AssessmentDate;
txtRiskAnalysisPeriod.Text = ass.RiskAnalysisPeriod.ToString();
txtEquipmentNumber.Text = eqMa.EquipmentNumber;
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(eqMa.EquipmentTypeID);
txtSites.Text = siteBus.getSiteName(eqMa.SiteID);
txtDesignCode.Text = designCodeBus.getDesignCodeName(eqMa.DesignCodeID);
txtFacility.Text = facilityBus.getFacilityName(eqMa.FacilityID);
txtManufacturer.Text = manuBus.getManuName(eqMa.ManufacturerID);
dateComissionDate.DateTime = eqMa.CommissionDate;
txtEquipmentName.Text = eqMa.EquipmentName;
txtProcessDesciption.Text = eqMa.ProcessDescription;
txtComponentNumber.Text = comMa.ComponentNumber;
txtComponentType.Text = comTypeBus.getComponentTypeName(comMa.ComponentTypeID);
txtAPIComponentType.Text = apiComponentBus.getAPIComponentTypeName(comMa.APIComponentTypeID);
txtComponentName.Text = comMa.ComponentName;
chkRiskLinksEquipmentRisk.Checked = comMa.IsEquipmentLinked == 1 ? true : false;
for (int i = 0; i < itemsAssessmentMethod.Length; i++)
{
if (ass.AssessmentMethod == i)
{
cbAsessmentMethod.SelectedIndex = i + 1;
break;
}
}
}
private void ShowDataToControl(int ID)
{
COMPONENT_MASTER com = componentMaster_Bus.getData(ID);
int eqID = componentMaster_Bus.getEquipmentID(ID);
//Equipment Number
List <string> eqNum = equipmentBus.getListEquipmentNumber();
cbEquipmentNumber.Properties.Items.Clear();
cbEquipmentNumber.Properties.Items.Add("", -1, -1);
for (int i = 0; i < eqNum.Count; i++)
{
cbEquipmentNumber.Properties.Items.Add(eqNum[i], i, i);
if (eqNum[i] == equipmentBus.getEquipmentNumber(eqID))
{
cbEquipmentNumber.SelectedIndex = i + 1;
}
}
cbEquipmentNumber.Enabled = false;
//Equipment Type
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(equipmentBus.getEquipmentTypeID(eqID));
txtEquipmentType.ReadOnly = true;
txtEquipmentType.Enabled = false;
//Sites
cbSites.Properties.Items.Add(siteBus.getSiteName(equipmentBus.getSiteID(eqID)), 0, 0);
cbSites.SelectedIndex = 0;
cbSites.Enabled = false;
//Facility
int faciID = equipmentBus.getFacilityID(eqID);
cbFacility.Properties.Items.Add(facilityBus.getFacilityName(faciID), 0, 0);
cbFacility.SelectedIndex = 0;
cbFacility.Enabled = false;
//Component Number
txtComponentNumber.Text = componentMaster_Bus.getComponentNumber(ID);
//<lọc dữ liệu cho trường hợp tank>
int _equipmentTypeID = equipmentBus.getEqTypeID(ID);
if (_equipmentTypeID == 11)
{
string[] componentTypeName = { "Fixed Roof", "Floating Roof", "Shell", "Tank Bottom" };
string[] APIcomp = { "COURSE-1", "COURSE-10", "COURSE-2", "COURSE-3", "COURSE-4", "COURSE-5", "COURSE-6", "COURSE-7", "COURSE-8", "COURSE-9", "TANKBOTTOM" };
cbComponentType.Properties.Items.Clear();
cbComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < componentTypeName.Length; i++)
{
cbComponentType.Properties.Items.Add(componentTypeName[i], i, i);
if (componentTypeName[i] == componentBus.getComponentTypeName(componentMaster_Bus.getComponentTypeID(ID)))
{
cbComponentType.SelectedIndex = i + 1;
}
}
cbAPIComponentType.Properties.Items.Clear();
cbAPIComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < APIcomp.Length; i++)
{
cbAPIComponentType.Properties.Items.Add(APIcomp[i], i, i);
if (APIcomp[i] == API_BUS.getAPIComponentTypeName(componentMaster_Bus.getAPIComponentTypeID(eqID)))
{
cbAPIComponentType.SelectedIndex = i + 1;
}
}
}
else
{
//get data for API component
listAPIComponent = API_BUS.getDataSource();
cbAPIComponentType.Properties.Items.Clear();
cbAPIComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listAPIComponent.Count; i++)
{
cbAPIComponentType.Properties.Items.Add(listAPIComponent[i].APIComponentTypeName, i, i);
if (listAPIComponent[i].APIComponentTypeName == API_BUS.getAPIComponentTypeName(componentMaster_Bus.getAPIComponentTypeID(eqID)))
{
cbAPIComponentType.SelectedIndex = i + 1;
}
}
//get data for component type
listComponent = componentBus.getDataSource();
cbComponentType.Properties.Items.Clear();
cbComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listComponent.Count; i++)
{
cbComponentType.Properties.Items.Add(listComponent[i].ComponentTypeName, i, i);
if (listComponent[i].ComponentTypeName == componentBus.getComponentTypeName(componentMaster_Bus.getComponentTypeID(ID)))
{
cbComponentType.SelectedIndex = i + 1;
}
}
}
//</lọc data cho tank>
txtComponentName.Text = componentMaster_Bus.getComponentName(ID);
chkLinks.Checked = com.IsEquipmentLinked == 1 ? true : false;
txtDescription.Text = com.ComponentDesc;
}
private void addDatatoControl()
{
//get data for site
listSite = siteBus.getData();
cbSites.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listSite.Count; i++)
{
cbSites.Properties.Items.Add(listSite[i].SiteName, i, i);
if (listSite[i].SiteName == this.siteName)
{
cbSites.SelectedIndex = i + 1;
//get list facility name
List <string> faciName = facilityBus.getListFacilityName(listSite[i].SiteID);
cbFacility.Properties.Items.Clear();
for (int j = 0; j < faciName.Count; j++)
{
cbFacility.Properties.Items.Add(faciName[j], j, j);
if (faciName[j] == this.facilityName)
{
cbFacility.SelectedIndex = j;
}
}
}
}
//get data for equipment number
listEquipment = equipmentBus.getDataSource();
cbEquipmentNumber.Properties.Items.Clear();
cbEquipmentNumber.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listEquipment.Count; i++)
{
cbEquipmentNumber.Properties.Items.Add(listEquipment[i].EquipmentNumber, i, i);
if (this.equipmentNumber == listEquipment[i].EquipmentNumber)
{
cbEquipmentNumber.SelectedIndex = i + 1;
}
}
//<lọc dữ liệu cho trường hợp tank>
int _siteID = siteBus.getIDbyName(this.siteName);
int _facilityID = facilityBus.getIDbyName_SiteID(_siteID, this.facilityName);
int _equipmentTypeID = equipmentBus.getEquipmentTypeID(_siteID, _facilityID);
if (_equipmentTypeID == 11)
{
string[] componentTypeName = { "Fixed Roof", "Floating Roof", "Shell", "Tank Bottom" };
cbComponentType.Properties.Items.Clear();
for (int i = 0; i < componentTypeName.Length; i++)
{
cbComponentType.Properties.Items.Add(componentTypeName[i], i, i);
}
}
else
{
//get data for API component
listAPIComponent = API_BUS.getDataSource();
cbAPIComponentType.Properties.Items.Clear();
cbAPIComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listAPIComponent.Count; i++)
{
cbAPIComponentType.Properties.Items.Add(listAPIComponent[i].APIComponentTypeName, i, i);
}
//get data for component type
listComponent = componentBus.getDataSource();
cbComponentType.Properties.Items.Clear();
cbComponentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listComponent.Count; i++)
{
cbComponentType.Properties.Items.Add(listComponent[i].ComponentTypeName, i, i);
}
}
//</lọc data cho tank>
//get equipment type name
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(_equipmentTypeID);
}
public void showDatatoControl(int ID)
{
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
EQUIPMENT_MASTER_BUS equipmentMasterBus = new EQUIPMENT_MASTER_BUS();
DESIGN_CODE_BUS designCodeBus = new DESIGN_CODE_BUS();
SITES_BUS siteBus = new SITES_BUS();
FACILITY_BUS facilityBus = new FACILITY_BUS();
MANUFACTURER_BUS manuBus = new MANUFACTURER_BUS();
RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS();
COMPONENT_MASTER_BUS comMaBus = new COMPONENT_MASTER_BUS();
COMPONENT_TYPE__BUS comTypeBus = new COMPONENT_TYPE__BUS();
API_COMPONENT_TYPE_BUS apiComponentBus = new API_COMPONENT_TYPE_BUS();
int[] equipmentID_componentID = rwAssBus.getEquipmentID_ComponentID(ID);
EQUIPMENT_MASTER eqMa = equipmentMasterBus.getData(equipmentID_componentID[0]);
COMPONENT_MASTER comMa = comMaBus.getData(equipmentID_componentID[1]);
RW_ASSESSMENT ass = rwAssBus.getData(ID);
txtAssessmentName.Text = ass.ProposalName;
dateAssessmentDate.DateTime = ass.AssessmentDate;
txtRiskAnalysisPeriod.Text = ass.RiskAnalysisPeriod.ToString();
txtEquipmentNumber.Text = eqMa.EquipmentNumber;
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(eqMa.EquipmentTypeID);
txtSites.Text = siteBus.getSiteName(eqMa.SiteID);
txtDesignCode.Text = designCodeBus.getDesignCodeName(eqMa.DesignCodeID);
txtFacility.Text = facilityBus.getFacilityName(eqMa.FacilityID);
txtManufacturer.Text = manuBus.getManuName(eqMa.ManufacturerID);
dateComissionDate.DateTime = eqMa.CommissionDate;
txtEquipmentName.Text = eqMa.EquipmentName;
txtProcessDesciption.Text = eqMa.ProcessDescription;
txtComponentNumber.Text = comMa.ComponentNumber;
txtComponentType.Text = comTypeBus.getComponentTypeName(comMa.ComponentTypeID);
txtAPIComponentType.Text = apiComponentBus.getAPIComponentTypeName(comMa.APIComponentTypeID);
txtComponentName.Text = comMa.ComponentName;
chkRiskLinksEquipmentRisk.Checked = comMa.IsEquipmentLinked == 1 ? true : false;
//foreach(RW_ASSESSMENT a in listAssessment)
//{
// if(a.ID == ID)
// {
// txtAssessmentName.Text = a.ProposalName;
// ProposalName = a.ProposalName;
// dateAssessmentDate.DateTime = a.AssessmentDate;
// txtRiskAnalysisPeriod.Text = a.RiskAnalysisPeriod.ToString();
// foreach (EQUIPMENT_MASTER e in listEquipmentMaster)
// {
// if (e.EquipmentID == a.EquipmentID)
// {
// txtEquipmentNumber.Text = e.EquipmentNumber;
// dateComissionDate.DateTime = e.CommissionDate;
// txtEquipmentName.Text = e.EquipmentName;
// foreach (EQUIPMENT_TYPE t in listEquipmentType)
// {
// if (t.EquipmentTypeID == e.EquipmentTypeID)
// txtEquipmentType.Text = t.EquipmentTypeName;
// }
// foreach (DESIGN_CODE d in listDesignCode)
// {
// if (d.DesignCodeID == e.DesignCodeID)
// txtDesignCode.Text = d.DesignCode;
// }
// foreach (FACILITY f in listFacility)
// {
// if (e.FacilityID == f.FacilityID)
// txtFacility.Text = f.FacilityName;
// }
// foreach (SITES s in listSite)
// {
// if (s.SiteID == e.SiteID)
// txtSites.Text = s.SiteName;
// }
// foreach (MANUFACTURER m in listManu)
// {
// if (m.ManufacturerID == e.ManufacturerID)
// txtManufacturer.Text = m.ManufacturerName;
// }
// }
// break;
// }
// foreach (COMPONENT_MASTER c in listComMa)
// {
// if (c.ComponentID == a.ComponentID)
// {
// txtComponentNumber.Text = c.ComponentNumber;
// foreach (COMPONENT_TYPE t in listComponentType)
// {
// if (c.ComponentTypeID == t.ComponentTypeID)
// {
// txtComponentType.Text = t.ComponentTypeName;
// }
// }
// txtComponentName.Text = c.ComponentName;
// foreach (API_COMPONENT_TYPE a1 in listAPICom)
// {
// if (a1.APIComponentTypeID == c.APIComponentTypeID)
// {
// txtAPIComponentType.Text = a1.APIComponentTypeName;
// }
// }
// }
// break;
// }
//}
//foreach (RW_ASSESSMENT a in listAssessment)
//{
// if (a.ID == assID)
// {
// txtAssessmentName.Text = a.ProposalName;
// }
//}
//đổ dữ liệu lên control cho Equipment
}
public List <RiskSummary> getData()
{
RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS();
List <int> allIDAssessment = assBus.getAllID();
List <RiskSummary> dataRisk = new List <RiskSummary>();
for (int i = 0; i < allIDAssessment.Count; i++)
{
RiskSummary risk = new RiskSummary();
RW_FULL_POF_BUS busPoF = new RW_FULL_POF_BUS();
RW_FULL_POF fullPoF = busPoF.getData(allIDAssessment[i]);
//RW_CA_LEVEL_1_BUS busCA = new RW_CA_LEVEL_1_BUS();
//RW_CA_LEVEL_1 CA = busCA.getData(allIDAssessment[i]);
//get EquipmentID ----> get EquipmentTypeName and APIComponentType
int equipmentID = assBus.getEquipmentID(allIDAssessment[i]);
EQUIPMENT_MASTER_BUS eqMaBus = new EQUIPMENT_MASTER_BUS();
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
String equipmentTypename = eqTypeBus.getEquipmentTypeName(eqMaBus.getEquipmentTypeID(equipmentID));
COMPONENT_MASTER_BUS comMasterBus = new COMPONENT_MASTER_BUS();
API_COMPONENT_TYPE_BUS apiBus = new API_COMPONENT_TYPE_BUS();
int apiID = comMasterBus.getAPIComponentTypeID(equipmentID);
String API_ComponentType_Name = apiBus.getAPIComponentTypeName(apiID);
RW_INPUT_CA_LEVEL_1_BUS busInputCA = new RW_INPUT_CA_LEVEL_1_BUS();
RW_INPUT_CA_LEVEL_1 inputCA = busInputCA.getData(allIDAssessment[i]);
SITES_BUS busSite = new SITES_BUS();
FACILITY_BUS busFacility = new FACILITY_BUS();
RW_ASSESSMENT_BUS busAssessment = new RW_ASSESSMENT_BUS();
risk.SitesName = busSite.getSiteName(eqMaBus.getSiteID(equipmentID));
risk.FacilityName = busFacility.getFacilityName(eqMaBus.getFacilityID(equipmentID));
risk.AssessmentName = busAssessment.getAssessmentName(allIDAssessment[i]);
risk.EquipmentName = eqMaBus.getEquipmentName(equipmentID);
risk.EquipmentNumber = eqMaBus.getEquipmentNumber(equipmentID); //Equipment Name or Equipment Number can dc gan lai
risk.EquipmentDesc = eqMaBus.getEquipmentDesc(equipmentID); //Equipment Description gan lai
risk.EquipmentType = equipmentTypename; //Equipment type
risk.ComponentName = comMasterBus.getComponentName(equipmentID); //component name
risk.RepresentFluid = inputCA.API_FLUID; //Represent fluid
risk.FluidPhase = inputCA.SYSTEM; //fluid phase
risk.currentRisk = 0; //current risk
//risk.cofcatFlammable = CA.CA_inj_flame; //cofcat. Flammable
//risk.cofcatPeople = CA.FC_inj;//cofcat people
//risk.cofcatAsset = CA.FC_prod;//cofcat assessment
//risk.cofcatEnv = CA.FC_envi;//cofcat envroment
//risk.cofcatReputation = 0; //cof reputation
//risk.cofcatCombined = CA.FC_total; //combined
//risk.componentMaterialGrade; //component material glade
risk.initThinningPoF = fullPoF.ThinningAP1; //Thinning POF
risk.initEnvCracking = fullPoF.SCCAP1; //Cracking env
risk.initOtherPoF = fullPoF.HTHA_AP1 + fullPoF.BrittleAP1; //OtherPOF
risk.initPoF = risk.initThinningPoF + risk.initEnvCracking + risk.initOtherPoF; //Init POF
risk.extThinningPoF = fullPoF.ExternalAP1; //Ext Thinning POF
risk.extEnvCrackingPoF = 0; //ExtEnv Cracking
risk.extOtherPoF = 0; //Ext Other POF
risk.extPoF = risk.extThinningPoF + risk.extEnvCrackingPoF + risk.extOtherPoF; //Ext POF
risk.PoF = risk.initPoF + risk.extPoF; //POF
//risk.CurrentRiskCalculation = fullPoF.PoFAP1 * CA.FC_total; //Current risk
//risk.futureRisk = fullPoF.PoFAP2 * CA.FC_total;
dataRisk.Add(risk);
}
return(dataRisk);
}
