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); }