private void getData(int ID)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_EXTCOR_TEMPERATURE_BUS tempBus = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM objSteam = SteamBus.getData(ID);
RW_EXTCOR_TEMPERATURE extTemp = tempBus.getData(ID);
txtFlowRate.Text = objSteam.FlowRate.ToString();
txtMaxOperatingPressure.Text = objSteam.MaxOperatingPressure.ToString();
txtMinOperatingPressure.Text = objSteam.MinOperatingPressure.ToString();
txtMaximumOperatingTemp.Text = objSteam.MaxOperatingTemperature.ToString();
txtMinimumOperatingTemp.Text = objSteam.MinOperatingTemperature.ToString();
txtCriticalExposure.Text = objSteam.CriticalExposureTemperature.ToString();
txtOperatingHydrogen.Text = objSteam.H2SPartialPressure.ToString();
txtOp12.Text = extTemp.Minus12ToMinus8.ToString();
txtOp8.Text = extTemp.Minus8ToPlus6.ToString();
txtOp6.Text = extTemp.Plus6ToPlus32.ToString();
txtOp32.Text = extTemp.Plus32ToPlus71.ToString();
txtOp71.Text = extTemp.Plus71ToPlus107.ToString();
txtOp107.Text = extTemp.Plus107ToPlus121.ToString();
txtOp121.Text = extTemp.Plus121ToPlus135.ToString();
txtOp135.Text = extTemp.Plus135ToPlus162.ToString();
txtOp162.Text = extTemp.Plus162ToPlus176.ToString();
txtOp176.Text = extTemp.MoreThanPlus176.ToString();
}
public RW_EXTCOR_TEMPERATURE getDataExtcorTemp(int ID)
{
RW_EXTCOR_TEMPERATURE ext = new RW_EXTCOR_TEMPERATURE();
ext.ID = ID;
ext.Minus12ToMinus8 = txtOp12.Text != "" ? float.Parse(txtOp12.Text) : 0;
ext.Minus8ToPlus6 = txtOp8.Text != "" ? float.Parse(txtOp8.Text) : 0;
ext.Plus6ToPlus32 = txtOp6.Text != "" ? float.Parse(txtOp6.Text) : 0;
ext.Plus32ToPlus71 = txtOp32.Text != "" ? float.Parse(txtOp32.Text) : 0;
ext.Plus71ToPlus107 = txtOp71.Text != "" ? float.Parse(txtOp71.Text) : 0;
ext.Plus107ToPlus121 = txtOp107.Text != "" ? float.Parse(txtOp107.Text) : 0;
ext.Plus121ToPlus135 = txtOp121.Text != "" ? float.Parse(txtOp121.Text) : 0;
ext.Plus135ToPlus162 = txtOp135.Text != "" ? float.Parse(txtOp135.Text) : 0;
ext.Plus162ToPlus176 = txtOp162.Text != "" ? float.Parse(txtOp162.Text) : 0;
ext.MoreThanPlus176 = txtOp176.Text != "" ? float.Parse(txtOp176.Text) : 0;
return(ext);
}
public RW_EXTCOR_TEMPERATURE getData(int ID)
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
RW_EXTCOR_TEMPERATURE obj = new RW_EXTCOR_TEMPERATURE();
String sql = "Use[rbi] Select[ID]" +
",[Minus12ToMinus8]" +
",[Minus8ToPlus6]" +
",[Plus6ToPlus32]" +
",[Plus32ToPlus71]" +
",[Plus71ToPlus107]" +
",[Plus107ToPlus121]" +
",[Plus121ToPlus135]" +
",[Plus135ToPlus162]" +
",[Plus162ToPlus176]" +
",[MoreThanPlus176]" +
"From [dbo].[RW_EXTCOR_TEMPERATURE] 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);
if (!reader.IsDBNull(1))
{
obj.Minus12ToMinus8 = (float)reader.GetDouble(1);
}
if (!reader.IsDBNull(2))
{
obj.Minus8ToPlus6 = (float)reader.GetDouble(2);
}
if (!reader.IsDBNull(3))
{
obj.Plus6ToPlus32 = (float)reader.GetDouble(3);
}
if (!reader.IsDBNull(4))
{
obj.Plus32ToPlus71 = (float)reader.GetDouble(4);
}
if (!reader.IsDBNull(5))
{
obj.Plus71ToPlus107 = (float)reader.GetDouble(5);
}
if (!reader.IsDBNull(6))
{
obj.Plus107ToPlus121 = (float)reader.GetDouble(6);
}
if (!reader.IsDBNull(7))
{
obj.Plus121ToPlus135 = (float)reader.GetDouble(7);
}
if (!reader.IsDBNull(8))
{
obj.Plus135ToPlus162 = (float)reader.GetDouble(8);
}
if (!reader.IsDBNull(9))
{
obj.Plus162ToPlus176 = (float)reader.GetDouble(9);
}
if (!reader.IsDBNull(10))
{
obj.MoreThanPlus176 = (float)reader.GetDouble(10);
}
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL");
}
finally
{
conn.Close();
}
return(obj);
}
private void ShowDataToForm(int ID, string temperatureUnit, string pressureUnit, string flowRateUnit)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_EXTCOR_TEMPERATURE_BUS tempBus = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM objSteam = SteamBus.getData(ID);
RW_EXTCOR_TEMPERATURE extTemp = tempBus.getData(ID);
BUS_UNITS convUnit = new BUS_UNITS();
switch (temperatureUnit)
{
case "DEG_C":
txtMaximumOperatingTemp.Text = objSteam.MaxOperatingTemperature.ToString();
txtMinimumOperatingTemp.Text = objSteam.MinOperatingTemperature.ToString();
txtCriticalExposure.Text = objSteam.CriticalExposureTemperature.ToString();
break;
case "DEG_F":
txtMaximumOperatingTemp.Text = convUnit.CelToFah(objSteam.MaxOperatingTemperature).ToString();
txtMinimumOperatingTemp.Text = convUnit.CelToFah(objSteam.MinOperatingTemperature).ToString();
txtCriticalExposure.Text = convUnit.CelToFah(objSteam.CriticalExposureTemperature).ToString();
Console.WriteLine("Hha");
break;
case "K":
txtMaximumOperatingTemp.Text = convUnit.CelToKenvin(objSteam.MaxOperatingTemperature).ToString();
txtMinimumOperatingTemp.Text = convUnit.CelToKenvin(objSteam.MinOperatingTemperature).ToString();
txtCriticalExposure.Text = convUnit.CelToKenvin(objSteam.CriticalExposureTemperature).ToString();
break;
}
switch (pressureUnit)
{
case "psi":
txtMaxOperatingPressure.Text = objSteam.MaxOperatingPressure.ToString();
txtMinOperatingPressure.Text = objSteam.MinOperatingPressure.ToString();
txtOperatingHydrogen.Text = objSteam.H2SPartialPressure.ToString();
break;
case "KSI":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.ksi).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.ksi).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.ksi).ToString();
break;
case "bar":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.bar).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.bar).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.bar).ToString();
break;
case "MPa":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.MPa).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.MPa).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.MPa).ToString();
break;
case "N/m2":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.NpM2).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.NpM2).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.NpM2).ToString();
break;
case "N/cm2":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.NpCM2).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.NpCM2).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.NpCM2).ToString();
break;
}
switch (flowRateUnit)
{
case "ft3/hr":
txtFlowRate.Text = (objSteam.FlowRate / convUnit.ft3).ToString();
break;
case "m3/hr":
txtFlowRate.Text = objSteam.FlowRate.ToString();
break;
}
txtOp12.Text = extTemp.Minus12ToMinus8.ToString();
txtOp8.Text = extTemp.Minus8ToPlus6.ToString();
txtOp6.Text = extTemp.Plus6ToPlus32.ToString();
txtOp32.Text = extTemp.Plus32ToPlus71.ToString();
txtOp71.Text = extTemp.Plus71ToPlus107.ToString();
txtOp107.Text = extTemp.Plus107ToPlus121.ToString();
txtOp121.Text = extTemp.Plus121ToPlus135.ToString();
txtOp135.Text = extTemp.Plus135ToPlus162.ToString();
txtOp162.Text = extTemp.Plus162ToPlus176.ToString();
txtOp176.Text = extTemp.MoreThanPlus176.ToString();
}
public void delete(RW_EXTCOR_TEMPERATURE obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_EXTCOR_TEMPERATURE obj)
{
DAL.edit(obj.ID, obj.Minus12ToMinus8, obj.Minus8ToPlus6, obj.Plus6ToPlus32, obj.Plus32ToPlus71, obj.Plus71ToPlus107, obj.Plus107ToPlus121, obj.Plus121ToPlus135, obj.Plus135ToPlus162, obj.Plus162ToPlus176, obj.MoreThanPlus176);
}
