public RW_EQUIPMENT getData1()
{
RW_EQUIPMENT eq = new RW_EQUIPMENT();
eq.CommissionDate = dateComissionDate.DateTime;
return(eq);
}
public RW_EQUIPMENT getData(int ID)
{
RW_EQUIPMENT eq = new RW_EQUIPMENT();
RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS();
eq.ID = ID;
eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0;
eq.ContainsDeadlegs = chkContainsDeadlegs.Checked ? 1 : 0;
eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0;
eq.HighlyDeadlegInsp = chkHighlyEffectiveInspection.Checked ? 1 : 0;
eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0;
eq.ExternalEnvironment = cbExternalEnvironment.Text;
eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0;
eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0;
eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0;
eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0;
eq.MinReqTemperaturePressurisation = txtMinRequiredTemperature.Text != "" ? float.Parse(txtMinRequiredTemperature.Text) : 0;
eq.OnlineMonitoring = cbOnlineMonitoring.Text;
eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0;
eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0;
eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0;
eq.PWHT = chkPWHT.Checked ? 1 : 0;
eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0;
eq.ManagementFactor = (float)numSystemManagementFactor.Value;
eq.ThermalHistory = cbThermalHistory.Text;
eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0;
eq.Volume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0;
//eq.CommissionDate =
return(eq);
}
public RW_EQUIPMENT getDataEquipment()
{
RW_EQUIPMENT eq = new RW_EQUIPMENT();
eq.AdminUpsetManagement = sheetEquipment[12] == "True" ? 1 : 0;
eq.ContainsDeadlegs = sheetEquipment[13] == "True" ? 1 : 0;
eq.CyclicOperation = sheetEquipment[15] == "True" ? 1 : 0;
eq.HighlyDeadlegInsp = sheetEquipment[14] == "True" ? 1 : 0;
eq.DowntimeProtectionUsed = sheetEquipment[16] == "True" ? 1 : 0;
eq.ExternalEnvironment = sheetEquipment[28];
eq.HeatTraced = sheetEquipment[18] == "True" ? 1 : 0;
eq.InterfaceSoilWater = sheetEquipment[20] == "True" ? 1 : 0;
eq.LinerOnlineMonitoring = sheetEquipment[25] == "True" ? 1 : 0;
eq.MaterialExposedToClExt = sheetEquipment[24] == "True" ? 1 : 0;
eq.MinReqTemperaturePressurisation = sheetEquipment[22] != "" ? float.Parse(sheetEquipment[22]) : 0;
eq.OnlineMonitoring = sheetEquipment[30];
eq.PresenceSulphidesO2 = sheetEquipment[26] == "True" ? 1 : 0;
eq.PresenceSulphidesO2Shutdown = sheetEquipment[27] == "True" ? 1 : 0;
eq.PressurisationControlled = sheetEquipment[21] == "True" ? 1 : 0;
eq.PWHT = sheetEquipment[19] == "True" ? 1 : 0;
eq.SteamOutWaterFlush = sheetEquipment[17] == "True" ? 1 : 0;
eq.ManagementFactor = sheetEquipment[32] != "" ? float.Parse(sheetEquipment[32]) : 0;
eq.ThermalHistory = sheetEquipment[29];
eq.YearLowestExpTemp = sheetEquipment[23] == "True" ? 1 : 0;
eq.Volume = sheetEquipment[31] != "" ? float.Parse(sheetEquipment[31]) : 0;
eq.CommissionDate = Convert.ToDateTime(sheetEquipment[8]);
Debug.WriteLine("commission date " + eq.CommissionDate);
return(eq);
}
public RW_EQUIPMENT getData(int ID)
{
RW_EQUIPMENT eq = new RW_EQUIPMENT();
eq.ID = ID;
eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0;
eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0;
eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0;
eq.ExternalEnvironment = cbAdjustmentSettlement.Text;
eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0;
eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0;
eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0;
eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0;
eq.MinReqTemperaturePressurisation = txtMinRequiredTemperature.Text != "" ? float.Parse(txtMinRequiredTemperature.Text) : 0;
eq.OnlineMonitoring = cbOnlineMonitoring.Text;
eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0;
eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0;
eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0;
eq.PWHT = chkPWHT.Checked ? 1 : 0;
eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0;
eq.ManagementFactor = (float)numSystemManagementFactor.Value;
eq.ThermalHistory = cbThermalHistory.Text;
eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0;
eq.Volume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0;
eq.TypeOfSoil = cbTypeSoild.Text;
eq.EnvironmentSensitivity = cbEnvironmentalSensitivity.Text;
eq.AdjustmentSettle = cbAdjustmentSettlement.Text;
eq.ComponentIsWelded = chkComponentWelded.Checked ? 1 : 0;
eq.TankIsMaintained = chkTankMaintainedAccordance.Checked ? 1 : 0;
//tank shell
//tank bottom
eq.DistanceToGroundWater = txtDistanceGroundWater.Text != "" ? float.Parse(txtDistanceGroundWater.Text) : 0;
return(eq);
}
public RW_EQUIPMENT getData(int ID, string temUnit, string volUnit)
{
RW_EQUIPMENT eq = new RW_EQUIPMENT();
RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS();
BUS_UNITS convUnit = new BUS_UNITS();
eq.ID = ID;
eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0;
eq.ContainsDeadlegs = chkContainsDeadlegs.Checked ? 1 : 0;
eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0;
eq.HighlyDeadlegInsp = chkHighlyEffectiveInspection.Checked ? 1 : 0;
eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0;
eq.ExternalEnvironment = cbExternalEnvironment.Text;
eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0;
eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0;
eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0;
eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0;
double minReqTem = 0;
if (temUnit == "DEG_C")
{
minReqTem = txtMinRequiredTemperature.Text != "" ? double.Parse(txtMinRequiredTemperature.Text) : 0;
}
else if (temUnit == "DEG_F")
{
minReqTem = txtMinRequiredTemperature.Text != "" ? convUnit.FahToCel(double.Parse(txtMinRequiredTemperature.Text)) : 0; // mai
}
else
{
minReqTem = txtMinRequiredTemperature.Text != "" ? convUnit.KenvinToCel(double.Parse(txtMinRequiredTemperature.Text)) : 0; // mai
}
eq.MinReqTemperaturePressurisation = (float)minReqTem;
eq.OnlineMonitoring = cbOnlineMonitoring.Text;
eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0;
eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0;
eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0;
eq.PWHT = chkPWHT.Checked ? 1 : 0;
eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0;
int equipmentID = assBus.getEquipmentID(ID);
float FMS = busFacility.getFMS(busEquipmentMaster.getFacilityID(equipmentID));
eq.ManagementFactor = FMS;
eq.ThermalHistory = cbThermalHistory.Text;
eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0;
double equipVolume = 0;
if (volUnit == "m3")
{
equipVolume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0;
}
else
{
equipVolume = txtMinRequiredTemperature.Text != "" ? (float.Parse(txtEquipmentVolume.Text) * convUnit.ft3) : 0; // mai
}
eq.Volume = (float)equipVolume;
//eq.CommissionDate =
return(eq);
}
public RW_EQUIPMENT getdata(int ID)
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
RW_EQUIPMENT obj = new RW_EQUIPMENT();
String sql = "Use[rbi] Select[ID]" +
",[CommissionDate]" +
",[AdminUpsetManagement]" +
",[ContainsDeadlegs]" +
",[CyclicOperation]" +
",[HighlyDeadlegInsp]" +
",[DowntimeProtectionUsed]" +
",[ExternalEnvironment]" +
",[HeatTraced]" +
",[InterfaceSoilWater]" +
",[LinerOnlineMonitoring]" +
",[MaterialExposedToClExt]" +
",[MinReqTemperaturePressurisation]" +
",[OnlineMonitoring]" +
",[PresenceSulphidesO2]" +
",[PresenceSulphidesO2Shutdown]" +
",[PressurisationControlled]" +
",[PWHT]" +
",[SteamOutWaterFlush]" +
",[ManagementFactor]" +
",[ThermalHistory]" +
",[YearLowestExpTemp]" +
",[Volume]" +
",[TypeOfSoil]" +
",[EnvironmentSensitivity]" +
",[DistanceToGroundWater]" +
",[AdjustmentSettle]" +
",[ComponentIsWelded]" +
",[TankIsMaintained]" +
"From [dbo].[RW_EQUIPMENT] 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 = reader.GetInt32(0);
obj.CommissionDate = reader.GetDateTime(1);
obj.AdminUpsetManagement = Convert.ToInt32(reader.GetBoolean(2));
obj.ContainsDeadlegs = Convert.ToInt32(reader.GetBoolean(3));
obj.CyclicOperation = Convert.ToInt32(reader.GetBoolean(4));
obj.HighlyDeadlegInsp = Convert.ToInt32(reader.GetBoolean(5));
obj.DowntimeProtectionUsed = Convert.ToInt32(reader.GetBoolean(6));
if (!reader.IsDBNull(7))
{
obj.ExternalEnvironment = reader.GetString(7);
}
obj.HeatTraced = Convert.ToInt32(reader.GetBoolean(8));
obj.InterfaceSoilWater = Convert.ToInt32(reader.GetBoolean(9));
obj.LinerOnlineMonitoring = Convert.ToInt32(reader.GetBoolean(10));
obj.MaterialExposedToClExt = Convert.ToInt32(reader.GetBoolean(11));
if (!reader.IsDBNull(12))
{
obj.MinReqTemperaturePressurisation = (float)reader.GetDouble(12);
}
if (!reader.IsDBNull(13))
{
obj.OnlineMonitoring = reader.GetString(13);
}
obj.PresenceSulphidesO2 = Convert.ToInt32(reader.GetBoolean(14));
obj.PresenceSulphidesO2Shutdown = Convert.ToInt32(reader.GetBoolean(15));
obj.PressurisationControlled = Convert.ToInt32(reader.GetBoolean(16));
obj.PWHT = Convert.ToInt32(reader.GetBoolean(17));
obj.SteamOutWaterFlush = Convert.ToInt32(reader.GetBoolean(18));
if (!reader.IsDBNull(19))
{
obj.ManagementFactor = (float)reader.GetDouble(19);
}
if (!reader.IsDBNull(20))
{
obj.ThermalHistory = reader.GetString(20);
}
obj.YearLowestExpTemp = Convert.ToInt32(reader.GetBoolean(21));
if (!reader.IsDBNull(22))
{
obj.Volume = (float)reader.GetDouble(22);
}
if (!reader.IsDBNull(23))
{
obj.TypeOfSoil = reader.GetString(23);
}
if (!reader.IsDBNull(24))
{
obj.EnvironmentSensitivity = reader.GetString(24);
}
if (!reader.IsDBNull(25))
{
obj.DistanceToGroundWater = (float)reader.GetDouble(25);
}
if (!reader.IsDBNull(26))
{
obj.AdjustmentSettle = reader.GetString(26);
}
obj.ComponentIsWelded = Convert.ToInt32(reader.GetBoolean(27));
obj.TankIsMaintained = Convert.ToInt32(reader.GetBoolean(28));
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL");
}
finally
{
conn.Close();
}
return(obj);
}
public void delete(RW_EQUIPMENT obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_EQUIPMENT obj)
{
DAL.edit(obj.ID, obj.AdminUpsetManagement, obj.ContainsDeadlegs, obj.CyclicOperation, obj.HighlyDeadlegInsp, obj.DowntimeProtectionUsed, obj.ExternalEnvironment, obj.HeatTraced, obj.InterfaceSoilWater, obj.LinerOnlineMonitoring, obj.MaterialExposedToClExt, obj.MinReqTemperaturePressurisation, obj.OnlineMonitoring, obj.PresenceSulphidesO2, obj.PresenceSulphidesO2Shutdown, obj.PressurisationControlled, obj.PWHT, obj.SteamOutWaterFlush, obj.ManagementFactor, obj.ThermalHistory, obj.YearLowestExpTemp, obj.Volume, obj.TypeOfSoil, obj.EnvironmentSensitivity, obj.DistanceToGroundWater, obj.AdjustmentSettle, obj.ComponentIsWelded, obj.TankIsMaintained);
}
public void ShowDataToControl(int ID, string temUnit, string volumeUnit)
{
RW_EQUIPMENT_BUS bus = new RW_EQUIPMENT_BUS();
RW_EQUIPMENT eq = bus.getData(ID);
chkAministrativeControl.Checked = Convert.ToBoolean(eq.AdminUpsetManagement);
chkCylicOperation.Checked = Convert.ToBoolean(eq.CyclicOperation);
chkDowntimeProtection.Checked = Convert.ToBoolean(eq.DowntimeProtectionUsed);
for (int i = 0; i < itemsAdjustmentSettlement.Length; i++)
{
if (eq.ExternalEnvironment == itemsAdjustmentSettlement[i])
{
cbAdjustmentSettlement.SelectedIndex = i + 1;
break;
}
}
chkHeatTraced.Checked = Convert.ToBoolean(eq.HeatTraced);
chkInterfaceSoilWater.Checked = Convert.ToBoolean(eq.InterfaceSoilWater);
chkLinerOnlineMonitoring.Checked = Convert.ToBoolean(eq.LinerOnlineMonitoring);
chkMaterialExposedFluid.Checked = Convert.ToBoolean(eq.MaterialExposedToClExt);
if (temUnit == "DEG_C")
{
txtMinRequiredTemperature.Text = eq.MinReqTemperaturePressurisation.ToString();
}
else if (temUnit == "DEG_F")
{
txtMinRequiredTemperature.Text = (convUnit.CelToFah(eq.MinReqTemperaturePressurisation)).ToString(); // mai
}
else
{
txtMinRequiredTemperature.Text = (convUnit.CelToKenvin(eq.MinReqTemperaturePressurisation)).ToString(); // mai
}
for (int i = 0; i < itemsOnlineMonitoring.Length; i++)
{
if (eq.OnlineMonitoring == itemsOnlineMonitoring[i])
{
cbOnlineMonitoring.SelectedIndex = i + 1;
break;
}
}
chkPresenceSulphideOperation.Checked = Convert.ToBoolean(eq.PresenceSulphidesO2);
chkPresenceSulphideShutdown.Checked = Convert.ToBoolean(eq.PresenceSulphidesO2Shutdown);
chkPressurisationControlled.Checked = Convert.ToBoolean(eq.PressurisationControlled);
chkPWHT.Checked = Convert.ToBoolean(eq.PWHT);
chkSteamedOutPriorWaterFlushing.Checked = Convert.ToBoolean(eq.SteamOutWaterFlush);
numSystemManagementFactor.Value = (decimal)eq.ManagementFactor;
for (int i = 0; i < itemsThermalHistory.Length; i++)
{
if (eq.ThermalHistory == itemsThermalHistory[i])
{
cbThermalHistory.SelectedIndex = i + 1;
break;
}
}
chkEquipmentOperatingManyYear.Checked = Convert.ToBoolean(eq.YearLowestExpTemp);
if (volumeUnit == "m3")
{
txtEquipmentVolume.Text = eq.Volume.ToString(); //mai
}
else if (volumeUnit == "ft3")
{
txtEquipmentVolume.Text = (eq.Volume / convUnit.ft3).ToString(); // mai
}
for (int i = 0; i < itemsExternalEnvironment.Length; i++)
{
if (eq.ExternalEnvironment == itemsExternalEnvironment[i])
{
cbExternalEnviroment.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsTypeSoil.Length; i++)
{
if (eq.TypeOfSoil == itemsTypeSoil[i])
{
cbTypeSoild.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsEnvironmental.Length; i++)
{
if (eq.EnvironmentSensitivity == itemsEnvironmental[i])
{
cbEnvironmentalSensitivity.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < itemsAdjustmentSettlement.Length; i++)
{
if (eq.AdjustmentSettle == itemsAdjustmentSettlement[i])
{
cbAdjustmentSettlement.SelectedIndex = i + 1;
break;
}
}
chkComponentWelded.Checked = Convert.ToBoolean(eq.ComponentIsWelded);
chkTankMaintainedAccordance.Checked = Convert.ToBoolean(eq.TankIsMaintained);
txtDistanceGroundWater.Text = eq.DistanceToGroundWater.ToString();
}
