public RW_INPUT_CA_TANK getData(int ID)
{
RW_INPUT_CA_TANK obj = new RW_INPUT_CA_TANK();
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi] " +
"SELECT [FLUID_HEIGHT]" +
",[SHELL_COURSE_HEIGHT]" +
",[TANK_DIAMETTER]" +
",[Prevention_Barrier]" +
",[Environ_Sensitivity]" +
",[P_lvdike]" +
",[P_onsite]" +
",[P_offsite]" +
",[Soil_Type]" +
",[TANK_FLUID]" +
",[API_FLUID]" +
",[SW]" +
" FROM [rbi].[dbo].[RW_INPUT_CA_TANK] 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;
obj.FLUID_HEIGHT = (float)reader.GetDouble(0);
obj.SHELL_COURSE_HEIGHT = (float)reader.GetDouble(1);
obj.TANK_DIAMETTER = (float)reader.GetDouble(2);
obj.Prevention_Barrier = reader.GetInt32(3);
obj.Environ_Sensitivity = reader.GetString(4);
obj.P_lvdike = (float)reader.GetDouble(5);
obj.P_onsite = (float)reader.GetDouble(6);
obj.P_offsite = (float)reader.GetDouble(7);
obj.Soil_Type = reader.GetString(8);
obj.TANK_FLUID = reader.GetString(9);
obj.API_FLUID = reader.GetString(10);
obj.SW = (float)reader.GetDouble(11);
}
}
}
}
catch
{
MessageBox.Show("GET DATA FAIL!", "ERROR!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(obj);
}
public RW_INPUT_CA_TANK getDataforTank(int ID)
{
RW_INPUT_CA_TANK ca = new RW_INPUT_CA_TANK();
ca.ID = ID;
return(ca);
}
public RW_INPUT_CA_TANK getDataCATank()
{
RW_INPUT_CA_TANK ca = new RW_INPUT_CA_TANK();
ca.API_FLUID = cbFluid.Text;
return(ca);
}
//public RW_STREAM getData2()
//{
// UCOperatingCondition ucOperating = new UCOperatingCondition();
// RW_STREAM temp = new RW_STREAM();
// temp = ucOperating.getData();
// return temp;
//}
public RW_INPUT_CA_TANK getDataforTank(int ID)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
tank.ID = ID;
tank.P_lvdike = txtPercentageLeavingDike.Text != "" ? float.Parse(txtPercentageLeavingDike.Text) : 9;
tank.P_offsite = txtPercentageFluidGoingOffsite.Text != "" ? float.Parse(txtPercentageFluidGoingOffsite.Text) : 9;
tank.P_onsite = txtPercentageLeavingRemainsOnSite.Text != "" ? float.Parse(txtPercentageLeavingRemainsOnSite.Text) : 9;
tank.FLUID_HEIGHT = txtFluidHeight.Text != "" ? float.Parse(txtFluidHeight.Text) : 0;
tank.TANK_FLUID = txbModelFluid.Text;
//MessageBox.Show(tank.FLUID_HEIGHT.ToString());
//Console.WriteLine("tank height" + tank.FLUID_HEIGHT);
if (tank.TANK_FLUID == "Gasoline")
{
tank.API_FLUID = "C6-C8";
}
else if (tank.TANK_FLUID == "Light Diesel Oil")
{
tank.API_FLUID = "C9-C12";
}
else if (tank.TANK_FLUID == "Heavy Diesel Oil")
{
tank.API_FLUID = "C13-C16";
}
else if (tank.TANK_FLUID == "Fuel Oil" || tank.TANK_FLUID == "Crude Oil")
{
tank.API_FLUID = "C17-C25";
}
else
{
tank.API_FLUID = "C25+";
}
return(tank);
}
//public RW_STREAM getData2()
//{
// UCOperatingCondition ucOperating = new UCOperatingCondition();
// RW_STREAM temp = new RW_STREAM();
// temp = ucOperating.getData();
// return temp;
//}
public RW_INPUT_CA_TANK getDataforTank(int ID)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
tank.ID = ID;
tank.P_lvdike = txtPercentageLeavingDike.Text != "" ? float.Parse(txtPercentageLeavingDike.Text) : 0;
tank.P_offsite = txtPercentageFluidGoingOffsite.Text != "" ? float.Parse(txtPercentageFluidGoingOffsite.Text) : 0;
tank.P_onsite = txtPercentageLeavingRemainsOnSite.Text != "" ? float.Parse(txtPercentageLeavingRemainsOnSite.Text) : 0;
tank.FLUID_HEIGHT = txtFluidHeight.Text != "" ? float.Parse(txtFluidHeight.Text) : 0;
tank.TANK_FLUID = cbFluidTank.Text;
if (tank.TANK_FLUID == "Gasoline")
{
tank.API_FLUID = "C6-C8";
}
else if (tank.TANK_FLUID == "Light Diesel Oil")
{
tank.API_FLUID = "C9-C12";
}
else if (tank.TANK_FLUID == "Heavy Diesel Oil")
{
tank.API_FLUID = "C13-C16";
}
else if (tank.TANK_FLUID == "Fuel Oil" || tank.TANK_FLUID == "Crude Oil")
{
tank.API_FLUID = "C17-C25";
}
else
{
tank.API_FLUID = "C25+";
}
return(tank);
}
public RW_INPUT_CA_TANK getDataforTank()
{
RW_INPUT_CA_TANK ca = new RW_INPUT_CA_TANK();
ca.ProductionCost = txtProductionCost.Text != "" ? float.Parse(txtProductionCost.Text) : 0;
return(ca);
}
public RW_INPUT_CA_TANK getDataforTank()
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0;
tank.Prevention_Barrier = chkPreventionBarrier.Checked ? 1 : 0;
tank.SHELL_COURSE_HEIGHT = txtShellCourseHeight.Text != "" ? float.Parse(txtShellCourseHeight.Text) : 0;
return(tank);
}
public RW_INPUT_CA_TANK getDataforTank(int ID)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
tank.ID = ID;
tank.Environ_Sensitivity = cbEnvironmentalSensitivity.Text;
tank.SW = txtDistanceGroundWater.Text != "" ? float.Parse(txtDistanceGroundWater.Text) : 0;
tank.Soil_Type = cbTypeSoild.Text;
return(tank);
}
public RW_INPUT_CA_TANK getDataCATank()
{
RW_INPUT_CA_TANK ca = new RW_INPUT_CA_TANK();
ca.ID = 1;
ca.TANK_FLUID = cbFluidTank.Text;
ca.FLUID_HEIGHT = txtFluidHeight.Text != "" ? float.Parse(txtFluidHeight.Text) : 0;
ca.P_lvdike = txtPercentageLeavingDike.Text != "" ? float.Parse(txtPercentageLeavingDike.Text) : 0;
ca.P_onsite = txtPercentageLeavingRemainsOnSite.Text != "" ? float.Parse(txtPercentageLeavingRemainsOnSite.Text) : 0;
ca.P_offsite = txtPercentageFluidGoingOffsite.Text != "" ? float.Parse(txtPercentageFluidGoingOffsite.Text) : 0;
return(ca);
}
public RW_INPUT_CA_TANK getDataforTank(int ID)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
tank.ID = ID;
tank.P_lvdike = txtPercentageLeavingDike.Text != "" ? float.Parse(txtPercentageLeavingDike.Text) : 0;
tank.P_offsite = txtPercentageFluidGoingOffsite.Text != "" ? float.Parse(txtPercentageFluidGoingOffsite.Text) : 0;
tank.P_onsite = txtPercentageLeavingRemainsOnSite.Text != "" ? float.Parse(txtPercentageLeavingRemainsOnSite.Text) : 0;
tank.FLUID_HEIGHT = txtFluidHeight.Text != "" ? float.Parse(txtFluidHeight.Text) : 0;
tank.TANK_FLUID = cbFluidTank.Text;
return(tank);
}
public RW_INPUT_CA_TANK getDataforTank(int ID, string diameter)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
BUS_UNITS convUnit = new BUS_UNITS();
tank.ID = ID;
if (diameter == "MM")
{
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0;
}
else if (diameter == "INCH")
{
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? (float)(double.Parse(txtTankDiameter.Text) * convUnit.inch) : 0; // in sang mm
}
//else tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0; // m sang mm
tank.ConcreteFoundation = chkConcreteAsphalt.Checked ? 1 : 0;
tank.Prevention_Barrier = chkPreventionBarrier.Checked ? 1 : 0;
return(tank);
}
public RW_INPUT_CA_TANK getDataforTank(int ID, string diameter)
{
RW_INPUT_CA_TANK tank = new RW_INPUT_CA_TANK();
BUS_UNITS convUnit = new BUS_UNITS();
tank.ID = ID;
if (diameter == "mm")
{
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0;
}
else if (diameter == "in")
{
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? (float)(double.Parse(txtTankDiameter.Text) * convUnit.inch) : 0; // in sang mm
}
else
{
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) * 1000 : 0; // m sang mm
}
tank.TANK_DIAMETTER = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0;
tank.Prevention_Barrier = chkPreventionBarrier.Checked ? 1 : 0;
tank.SHELL_COURSE_HEIGHT = txtShellCourseHeight.Text != "" ? float.Parse(txtShellCourseHeight.Text) : 0;
return(tank);
}
private void btnImport_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(WaitForm2));
SITES_BUS busSite = new SITES_BUS();
FACILITY_BUS busFacility = new FACILITY_BUS();
MANUFACTURER_BUS busManufacture = new MANUFACTURER_BUS();
DESIGN_CODE_BUS busDesignCode = new DESIGN_CODE_BUS();
FACILITY_RISK_TARGET_BUS busRiskTarget = new FACILITY_RISK_TARGET_BUS();
EQUIPMENT_MASTER_BUS busEquipMaster = new EQUIPMENT_MASTER_BUS();
COMPONENT_MASTER_BUS busCompMaster = new COMPONENT_MASTER_BUS();
RW_ASSESSMENT_BUS busAss = new RW_ASSESSMENT_BUS();
RW_EQUIPMENT_BUS busEquip = new RW_EQUIPMENT_BUS();
RW_COMPONENT_BUS busCom = new RW_COMPONENT_BUS();
RW_EXTCOR_TEMPERATURE_BUS busExtcor = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM_BUS busStream = new RW_STREAM_BUS();
RW_MATERIAL_BUS busMaterial = new RW_MATERIAL_BUS();
RW_COATING_BUS busCoating = new RW_COATING_BUS();
RW_INPUT_CA_TANK_BUS busInputCATank = new RW_INPUT_CA_TANK_BUS();
Bus_PLANT_PROCESS_Excel busExcel = new Bus_PLANT_PROCESS_Excel();
busExcel.path = txtPathFileExcel.Text;
//Sites
List <SITES> lstSite = busExcel.getAllSite();
foreach (SITES s in lstSite)
{
if (!busSite.checkExist(s.SiteName))
{
busSite.add(s);
}
else
{
busSite.edit(s);
}
}
//Facility
List <FACILITY> lstFacility = busExcel.getFacility();
foreach (FACILITY f in lstFacility)
{
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);
}
}
//Manufacture
List <string> manufacture = busExcel.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);
}
}
//Design Code
List <string> designCode = busExcel.getAllDesigncode();
for (int i = 0; i < designCode.Count; i++)
{
DESIGN_CODE design = new DESIGN_CODE();
design.DesignCodeID = busDesignCode.getIDbyName(designCode[i]);
design.DesignCode = designCode[i];
design.DesignCodeApp = "";
if (design.DesignCodeID == 0)
{
busDesignCode.add(design);
}
else
{
busDesignCode.edit(design);
}
}
//Equipment Master
List <EQUIPMENT_MASTER> lstEquipMaster = busExcel.getEquipmentMaster();
foreach (EQUIPMENT_MASTER eq in lstEquipMaster)
{
if (busEquipMaster.check(eq.EquipmentNumber))
{
busEquipMaster.edit(eq);
}
else
{
busEquipMaster.add(eq);
}
}
//Component Master
List <COMPONENT_MASTER> lstCompMaster = busExcel.getComponentMaster();
foreach (COMPONENT_MASTER com in lstCompMaster)
{
if (busCompMaster.checkExist(com.ComponentNumber))
{
com.ComponentID = busCompMaster.getIDbyName(com.ComponentNumber);
busCompMaster.edit(com);
}
else
{
busCompMaster.add(com);
}
}
//Rw Assessment
List <RW_ASSESSMENT> lstAssessment = busExcel.getAssessment();
List <int> editExcel = new List <int>();
List <int> addExcel = new List <int>();
foreach (RW_ASSESSMENT ass in lstAssessment)
{
List <int[]> ID_checkAddbyExcel = busAss.getCheckAddExcel_ID(ass.ComponentID, ass.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
{
ass.ID = ID_checkAddbyExcel[i][1];
editExcel.Add(ass.ID);
busAss.edit(ass);
}
}
}
else
{
ass.AddByExcel = 1;
busAss.add(ass);
int assID = busAss.getLastID();
addExcel.Add(assID);
RW_INPUT_CA_TANK inputCATank = new RW_INPUT_CA_TANK();
inputCATank.ID = assID;
busInputCATank.add(inputCATank);
}
}
//RW Equipment
List <RW_EQUIPMENT> lstEquipment = busExcel.getRwEquipmentTank();
for (int i = 0; i < lstEquipment.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstEquipment[i].ID == editExcel[j])
{
busEquip.edit(lstEquipment[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstEquipment[i].ID == addExcel[j])
{
busEquip.add(lstEquipment[i]);
}
}
}
}
//RW Component
List <RW_COMPONENT> lstComponent = busExcel.getRwComponentTank();
for (int i = 0; i < lstComponent.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstComponent[i].ID == editExcel[j])
{
busCom.edit(lstComponent[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstComponent[i].ID == addExcel[j])
{
busCom.add(lstComponent[i]);
}
}
}
}
//RW Extcor temperature
List <RW_EXTCOR_TEMPERATURE> lstExtcor = busExcel.getRwExtTemp();
for (int i = 0; i < lstExtcor.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstExtcor[i].ID == editExcel[j])
{
busExtcor.edit(lstExtcor[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstExtcor[i].ID == addExcel[j])
{
busExtcor.add(lstExtcor[i]);
}
}
}
}
//RW Stream
List <RW_STREAM> lstStream = busExcel.getRwStreamTank();
for (int i = 0; i < lstStream.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstStream[i].ID == editExcel[j])
{
busStream.edit(lstStream[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstStream[i].ID == addExcel[j])
{
busStream.add(lstStream[i]);
}
}
}
}
//RW Material
List <RW_MATERIAL> lstMaterial = busExcel.getRwMaterialTank();
for (int i = 0; i < lstMaterial.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstMaterial[i].ID == editExcel[j])
{
busMaterial.edit(lstMaterial[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstMaterial[i].ID == addExcel[j])
{
busMaterial.add(lstMaterial[i]);
}
}
}
}
//RW Coating
List <RW_COATING> lstCoating = busExcel.getRwCoating();
for (int i = 0; i < lstCoating.Count; i++)
{
if (editExcel.Count != 0)
{
for (int j = 0; j < editExcel.Count; j++)
{
if (lstCoating[i].ID == editExcel[j])
{
busCoating.edit(lstCoating[i]);
}
}
}
if (addExcel.Count != 0)
{
for (int j = 0; j < addExcel.Count; j++)
{
if (lstCoating[i].ID == addExcel[j])
{
busCoating.add(lstCoating[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_TANK obj)
{
DAL.Delete(obj.ID);
}
public void edit(RW_INPUT_CA_TANK obj)
{
DAL.Edit(obj.ID, obj.FLUID_HEIGHT, obj.SHELL_COURSE_HEIGHT, obj.TANK_DIAMETTER, obj.Prevention_Barrier, obj.Environ_Sensitivity, obj.P_lvdike, obj.P_onsite, obj.P_offsite, obj.Soil_Type, obj.TANK_FLUID, obj.API_FLUID, obj.SW, obj.ProductionCost);
}
