public RW_INPUT_CA_LEVEL_1 getDataForCA()
{
RW_INPUT_CA_LEVEL_1 ca = new RW_INPUT_CA_LEVEL_1();
ca.Material_Cost = txtMaterialCostFactor.Text != "" ? float.Parse(txtMaterialCostFactor.Text) : 0;
return(ca);
}
public RW_INPUT_CA_LEVEL_1 getDataforCA()
{
RW_INPUT_CA_LEVEL_1 ca = new RW_INPUT_CA_LEVEL_1();
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * 6.895f : 0;
ca.Stored_Temp = txtMinimumOperatingTemp.Text != "" ? float.Parse(txtMinimumOperatingTemp.Text) + 273 : 0;
return(ca);
}
private void ShowDataToControl(int ID)
{
RW_INPUT_CA_LEVEL_1_BUS caBus = new RW_INPUT_CA_LEVEL_1_BUS();
RW_INPUT_CA_LEVEL_1 ca = caBus.getData(ID);
txtEquipmentCost.Text = ca.Equipment_Cost.ToString();
txtProductionCost.Text = ca.Production_Cost.ToString();
txtInjureCost.Text = ca.Injure_Cost.ToString();
txtEnvironmentCost.Text = ca.Environment_Cost.ToString();
txtMassInvert.Text = ca.Mass_Inventory.ToString();
txtMassComponent.Text = ca.Mass_Component.ToString();
txtToxicPercent.Text = ca.Toxic_Percent.ToString();
txtPersonDensity.Text = ca.Personal_Density.ToString();
for (int i = 0; i < itemsFluid.Length; i++)
{
if (itemsFluid[i] == ca.API_FLUID)
{
cbFluid.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsFluidPhase.Length; i++)
{
if (itemsFluidPhase[i] == ca.SYSTEM)
{
cbFluidPhase.SelectedIndex = i + 1;
break;
}
}
//for(int i = 0; i < itemsRe)
cbReleaseDuration.Text = ca.Release_Duration;
for (int i = 0; i < itemsMittigationSystem.Length; i++)
{
if (itemsMittigationSystem[i] == ca.Mitigation_System)
{
cbMittigationSystem.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsDetectionType.Length; i++)
{
if (itemsDetectionType[i] == ca.Detection_Type)
{
cbDetectionType.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsIsulationType.Length; i++)
{
if (itemsIsulationType[i] == ca.Isulation_Type)
{
cbIsulationType.SelectedIndex = i + 1;
break;
}
}
}
public RW_INPUT_CA_LEVEL_1 getDataforCA(int id, string temperatureUnit, string pressureUnit)//thao
{
RW_INPUT_CA_LEVEL_1 ca = new RW_INPUT_CA_LEVEL_1();
BUS_UNITS convUnit = new BUS_UNITS();
ca.ID = id;
switch (temperatureUnit)
{
case "DEG_C":
ca.Stored_Temp = txtMinimumOperatingTemp.Text != "" ? float.Parse(txtMinimumOperatingTemp.Text) + 273 : 0;
break;
case "DEG_F":
ca.Stored_Temp = txtMinimumOperatingTemp.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMinimumOperatingTemp.Text)) + 273 : 0;
break;
case "K":
ca.Stored_Temp = txtMinimumOperatingTemp.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMinimumOperatingTemp.Text)) + 273 : 0;
break;
}
switch (pressureUnit)
{
case "psi":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * 6.895f : 0;
break;
case "KSI":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.ksi * 6.895f : 0;
break;
case "bar":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.bar * 6.895f : 0;
break;
case "MPa":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.MPa * 6.895f : 0;
break;
case "NpM2":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.NpM2 * 6.895f : 0;
break;
case "NpCM2":
ca.Stored_Pressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.NpCM2 * 6.895f : 0;
break;
}
return(ca);
}
public RW_INPUT_CA_LEVEL_1 getData(int ID)
{
RW_INPUT_CA_LEVEL_1 ca = new RW_INPUT_CA_LEVEL_1();
ca.ID = ID;
ca.API_FLUID = cbFluid.Text;
ca.SYSTEM = cbFluidPhase.Text;
ca.Equipment_Cost = txtEquipmentCost.Text != "" ? float.Parse(txtEquipmentCost.Text) : 0;
ca.Production_Cost = txtProductionCost.Text != "" ? float.Parse(txtProductionCost.Text) : 0;
ca.Injure_Cost = txtInjureCost.Text != "" ? float.Parse(txtInjureCost.Text) : 0;
ca.Environment_Cost = txtEnvironmentCost.Text != "" ? float.Parse(txtEnvironmentCost.Text) : 0;
ca.Detection_Type = cbDetectionType.Text;
ca.Isulation_Type = cbIsulationType.Text;
ca.Mass_Inventory = txtMassInvert.Text != "" ? float.Parse(txtMassInvert.Text) : 0;
ca.Mass_Component = txtMassComponent.Text != "" ? float.Parse(txtMassComponent.Text) : 0;
ca.Mitigation_System = cbMittigationSystem.Text;
ca.Toxic_Percent = txtToxicPercent.Text != "" ? float.Parse(txtToxicPercent.Text) : 0;
ca.Release_Duration = cbReleaseDuration.Text;
ca.Personal_Density = txtPersonDensity.Text != "" ? float.Parse(txtPersonDensity.Text) : 0;
return(ca);
}
public RW_INPUT_CA_LEVEL_1 GetData(int ID)
{
RW_INPUT_CA_LEVEL_1 obj = new RW_INPUT_CA_LEVEL_1();
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi] SELECT [API_FLUID]" +
",[SYSTEM]" +
",[Release_Duration]" +
",[Detection_Type]" +
",[Isulation_Type]" +
",[Mitigation_System]" +
",[Equipment_Cost]" +
",[Injure_Cost]" +
",[Evironment_Cost]" +
",[Toxic_Percent]" +
",[Personal_Density]" +
",[Material_Cost]" +
",[Production_Cost]" +
",[Mass_Inventory]" +
",[Mass_Component]" +
",[Stored_Pressure]" +
",[Stored_Temp]" +
" FROM [rbi].[dbo].[RW_INPUT_CA_LEVEL1] WHERE [ID] = '" + ID + "'";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj.ID = ID;
try
{
obj.API_FLUID = reader.GetString(0);
}
catch
{
obj.API_FLUID = "";
}
try
{
obj.SYSTEM = reader.GetString(1);
}
catch
{
obj.SYSTEM = "Liquid";
}
try
{
obj.Release_Duration = reader.GetString(2);
}
catch
{
obj.Release_Duration = "";
}
try
{
obj.Detection_Type = reader.GetString(3);
}
catch
{
obj.Detection_Type = "";
}
try
{
obj.Isulation_Type = reader.GetString(4);
}
catch
{
obj.Isulation_Type = "";
}
try
{
obj.Mitigation_System = reader.GetString(5);
}
catch
{
obj.Mitigation_System = "";
}
try
{
obj.Equipment_Cost = (float)reader.GetDouble(6);
}
catch
{
obj.Equipment_Cost = 0;
}
try
{
obj.Injure_Cost = (float)reader.GetDouble(7);
}
catch
{
obj.Injure_Cost = 0;
}
try
{
obj.Environment_Cost = (float)reader.GetDouble(8);
}
catch
{
obj.Environment_Cost = 0;
}
try
{
obj.Toxic_Percent = (float)reader.GetDouble(9);
}
catch
{
obj.Toxic_Percent = 0;
}
try
{
obj.Personal_Density = (float)reader.GetDouble(10);
}
catch
{
obj.Personal_Density = 0;
}
try
{
obj.Material_Cost = (float)reader.GetDouble(11);
}
catch
{
obj.Material_Cost = 0;
}
try
{
obj.Production_Cost = (float)reader.GetDouble(12);
}
catch
{
obj.Production_Cost = 0;
}
try
{
obj.Mass_Inventory = (float)reader.GetDouble(13);
}
catch
{
obj.Mass_Inventory = 0;
}
try
{
obj.Mass_Component = (float)reader.GetDouble(14);
}
catch
{
obj.Mass_Component = 0;
}
try
{
obj.Stored_Pressure = (float)reader.GetDouble(15);
}
catch
{
obj.Stored_Pressure = 0;
}
try
{
obj.Stored_Temp = (float)reader.GetDouble(16);
}
catch
{
obj.Stored_Temp = 0;
}
}
}
}
}
catch
{
obj.ID = 0;
//MessageBox.Show("GET DATA FAIL!" + ex.ToString(), "ERROR!");
}
finally
{
conn.Close();
}
return(obj);
}
private void btnImport_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(WaitForm2));
// data from file
SITES_BUS busSite = new SITES_BUS();
FACILITY_BUS busFacility = new FACILITY_BUS();
MANUFACTURER_BUS busManufacture = new MANUFACTURER_BUS();
DESIGN_CODE_BUS busDesign = new DESIGN_CODE_BUS();
EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS();
COMPONENT_MASTER_BUS busComMaster = new COMPONENT_MASTER_BUS();
RW_ASSESSMENT_BUS busAss = new RW_ASSESSMENT_BUS();
RW_EQUIPMENT_BUS busEq = new RW_EQUIPMENT_BUS();
RW_COMPONENT_BUS buscom = new RW_COMPONENT_BUS();
RW_EXTCOR_TEMPERATURE_BUS busExcort = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM_BUS busStream = new RW_STREAM_BUS();
RW_MATERIAL_BUS busMaterial = new RW_MATERIAL_BUS();
RW_COATING_BUS busCoat = new RW_COATING_BUS();
RW_INPUT_CA_LEVEL_1_BUS busInputCA = new RW_INPUT_CA_LEVEL_1_BUS();
FACILITY_RISK_TARGET_BUS busRiskTarget = new FACILITY_RISK_TARGET_BUS();
Bus_PLANT_PROCESS_Excel busExcelProcess = new Bus_PLANT_PROCESS_Excel();
busExcelProcess.path = txtPathFileExcel.Text;
List <SITES> listSite = busExcelProcess.getAllSite();
foreach (SITES s in listSite)
{
if (!busSite.checkExist(s.SiteName))
{
busSite.add(s);
}
else
{
busSite.edit(s);
}
}
List <FACILITY> listFacility = busExcelProcess.getFacility();
foreach (FACILITY f in listFacility)
{
if (busFacility.checkExist(f.FacilityName))
{
busFacility.edit(f);
}
else
{
busFacility.add(f);
int FaciID = busFacility.getLastFacilityID();
FACILITY_RISK_TARGET riskTarget = new FACILITY_RISK_TARGET();
riskTarget.FacilityID = FaciID;
busRiskTarget.add(riskTarget);
}
}
List <string> manufacture = busExcelProcess.getAllManufacture();
for (int i = 0; i < manufacture.Count; i++)
{
MANUFACTURER manu = new MANUFACTURER();
manu.ManufacturerID = busManufacture.getIDbyName(manufacture[i]);
manu.ManufacturerName = manufacture[i];
if (busManufacture.getIDbyName(manufacture[i]) == 0)
{
busManufacture.add(manu);
}
else
{
busManufacture.edit(manu);
}
}
List <String> designcode = busExcelProcess.getAllDesigncode();
for (int i = 0; i < designcode.Count; i++)
{
DESIGN_CODE design = new DESIGN_CODE();
design.DesignCodeID = busDesign.getIDbyName(designcode[i]);
design.DesignCode = designcode[i];
design.DesignCodeApp = "";
if (design.DesignCodeID == 0)
{
busDesign.add(design);
}
else
{
busDesign.edit(design);
}
}
List <EQUIPMENT_MASTER> listEpMaster = busExcelProcess.getEquipmentMaster();
foreach (EQUIPMENT_MASTER eqM in listEpMaster)
{
if (busEqMaster.check(eqM.EquipmentNumber))
{
busEqMaster.edit(eqM);
}
else
{
busEqMaster.add(eqM);
}
}
List <COMPONENT_MASTER> listComMaster = busExcelProcess.getComponentMaster();
foreach (COMPONENT_MASTER comM in listComMaster)
{
if (busComMaster.checkExist(comM.ComponentNumber))
{
busComMaster.edit(comM);
}
else
{
busComMaster.add(comM);
}
}
List <RW_ASSESSMENT> listRW_Assessment = busExcelProcess.getAssessment();
List <int> editExcel = new List <int>();
List <int> addExcel = new List <int>();
foreach (RW_ASSESSMENT rwAss in listRW_Assessment)
{
//kiem tra xem Proposal add bang file Excel hay add bang tay
List <int[]> ID_checkAddbyExcel = busAss.getCheckAddExcel_ID(rwAss.ComponentID, rwAss.EquipmentID);
if (ID_checkAddbyExcel.Count != 0)
{
for (int i = 0; i < ID_checkAddbyExcel.Count; i++)
{
if (ID_checkAddbyExcel[i][0] != 0) //kiem tra xem co phai Assessment nay duoc them tu file Excel ko, !=0 la them tu file Excel
{
rwAss.ID = ID_checkAddbyExcel[i][1];
editExcel.Add(rwAss.ID);
busAss.edit(rwAss);
}
}
}
else
{
rwAss.AddByExcel = 1;
busAss.add(rwAss);
int assID = busAss.getLastID();
addExcel.Add(assID);
RW_INPUT_CA_LEVEL_1 inputCA = new RW_INPUT_CA_LEVEL_1();
inputCA.ID = assID;
busInputCA.add(inputCA);
}
}
List <RW_EQUIPMENT> listRw_eq = busExcelProcess.getRwEquipment();
for (int i = 0; i < listRw_eq.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_eq[i].ID == editExcel[j])
{
busEq.edit(listRw_eq[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_eq[i].ID == addExcel[j])
{
busEq.add(listRw_eq[i]);
}
}
}
}
List <RW_COMPONENT> listRw_com = busExcelProcess.getRwComponent();
for (int i = 0; i < listRw_com.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_com[i].ID == editExcel[j])
{
buscom.edit(listRw_com[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_com[i].ID == addExcel[j])
{
buscom.add(listRw_com[i]);
}
}
}
}
List <RW_EXTCOR_TEMPERATURE> listRw_extcor = busExcelProcess.getRwExtTemp();
//MessageBox.Show(listRw_extcor.Count.ToString());
for (int i = 0; i < listRw_extcor.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_extcor[i].ID == editExcel[j])
{
//MessageBox.Show("add file excel");
busExcort.edit(listRw_extcor[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_extcor[i].ID == addExcel[j])
{
//MessageBox.Show("add file excel");
busExcort.add(listRw_extcor[i]);
}
}
}
}
List <RW_STREAM> listRw_stream = busExcelProcess.getRwStream();
for (int i = 0; i < listRw_stream.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_stream[i].ID == editExcel[j])
{
busStream.edit(listRw_stream[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_stream[i].ID == addExcel[j])
{
busStream.add(listRw_stream[i]);
}
}
}
}
List <RW_MATERIAL> listRw_material = busExcelProcess.getRwMaterial();
for (int i = 0; i < listRw_material.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_material[i].ID == editExcel[j])
{
busMaterial.edit(listRw_material[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_material[i].ID == addExcel[j])
{
busMaterial.add(listRw_material[i]);
}
}
}
}
List <RW_COATING> listRw_coat = busExcelProcess.getRwCoating();
for (int i = 0; i < listRw_coat.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (listRw_coat[i].ID == editExcel[j])
{
busCoat.edit(listRw_coat[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (listRw_coat[i].ID == addExcel[j])
{
busCoat.add(listRw_coat[i]);
}
}
}
}
ButtonOKClicked = true;
SplashScreenManager.CloseForm();
MessageBox.Show("All data have been saved! You need to add Risk Target in Facility!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Close();
}
public void delete(RW_INPUT_CA_LEVEL_1 obj)
{
DAL.Delete(obj.ID);
}
public void edit(RW_INPUT_CA_LEVEL_1 obj)
{
DAL.Edit(obj.ID, obj.API_FLUID, obj.SYSTEM, obj.Release_Duration, obj.Detection_Type, obj.Isulation_Type, obj.Mitigation_System, obj.Equipment_Cost, obj.Injure_Cost, obj.Environment_Cost, obj.Toxic_Percent, obj.Personal_Density, obj.Material_Cost, obj.Production_Cost, obj.Mass_Inventory, obj.Mass_Component, obj.Stored_Pressure, obj.Stored_Temp);
}
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);
}
