public RW_COATING getDataCoating()
{
RW_COATING coat = new RW_COATING();
try
{
coat.ExternalCoating = sheetCoating[3] == "True" ? 1 : 0;
coat.ExternalInsulation = sheetCoating[12] == "True" ? 1 : 0;
coat.InternalCladding = sheetCoating[7] == "True" ? 1 : 0;
coat.InternalCoating = sheetCoating[2] == "True" ? 1 : 0;
coat.ExternalCoatingQuality = sheetCoating[5];
coat.ExternalInsulationType = sheetCoating[14];
coat.InsulationContainsChloride = sheetCoating[13] == "True" ? 1 : 0;
coat.InternalLinerCondition = sheetCoating[11];
coat.InternalLinerType = sheetCoating[10];
coat.InternalLining = sheetCoating[9] == "True" ? 1 : 0;
coat.CladdingCorrosionRate = sheetCoating[8] != "" ? float.Parse(sheetCoating[8]) : 0;
coat.SupportConfigNotAllowCoatingMaint = sheetCoating[6] == "True" ? 1 : 0;
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
return(coat);
}
public RW_COATING getData(int ID, string corrosionRate)
{
RW_COATING coat = new RW_COATING();
BUS_UNITS convUnit = new BUS_UNITS();
coat.ID = ID;
coat.ExternalCoating = chkExternalCoat.Checked ? 1 : 0;
coat.ExternalInsulation = chkExternalIsulation.Checked ? 1 : 0;
coat.InternalCladding = chkInternalCladding.Checked ? 1 : 0;
coat.InternalCoating = chkInternalCoat.Checked ? 1 : 0;
coat.InternalLining = chkInternalLining.Checked ? 1 : 0;
coat.ExternalCoatingDate = dateExternalCoating.DateTime;
coat.ExternalCoatingQuality = cbExternalCoatQuality.Text;
coat.ExternalInsulationType = cbExternalIsulation.Text;
coat.InternalLinerCondition = cbInternalLinerCondition.Text;
coat.InsulationContainsChloride = chkInsulationContainsChlorides.Checked ? 1 : 0;
coat.InternalLinerType = cbInternalLinerType.Text;
if (corrosionRate == "mm/yr")
{
coat.CladdingCorrosionRate = txtCladdingCorrosionRate.Text == "" ? 0 : float.Parse(txtCladdingCorrosionRate.Text);
}
else
{
coat.CladdingCorrosionRate = txtCladdingCorrosionRate.Text == "" ? 0 : (float.Parse(txtCladdingCorrosionRate.Text) * (float)convUnit.mil);
}
coat.SupportConfigNotAllowCoatingMaint = chkSupport.Checked ? 1 : 0;
coat.InsulationCondition = cbIsulationCondition.Text;
return(coat);
}
public RW_COATING getData(int ID)
{
RW_COATING coat = new RW_COATING();
coat.ID = ID;
coat.ExternalCoating = chkExternalCoat.Checked ? 1 : 0;
coat.ExternalInsulation = chkExternalIsulation.Checked ? 1 : 0;
coat.InternalCladding = chkInternalCladding.Checked ? 1 : 0;
coat.InternalCoating = chkInternalCoat.Checked ? 1 : 0;
coat.InternalLining = chkInternalLining.Checked ? 1 : 0;
coat.ExternalCoatingDate = dateExternalCoating.DateTime;
coat.ExternalCoatingQuality = cbExternalCoatQuality.Text;
coat.ExternalInsulationType = cbExternalIsulation.Text;
coat.InternalLinerCondition = cbInternalLinerCondition.Text;
coat.InsulationContainsChloride = chkInsulationContainsChlorides.Checked ? 1 : 0;
coat.InternalLinerType = cbInternalLinerType.Text;
coat.CladdingCorrosionRate = txtCladdingCorrosionRate.Text == "" ? 0 : float.Parse(txtCladdingCorrosionRate.Text);
coat.SupportConfigNotAllowCoatingMaint = chkSupport.Checked ? 1 : 0;
coat.InsulationCondition = cbIsulationCondition.Text;
return(coat);
}
public void delete(RW_COATING obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_COATING obj)
{
DAL.edit(obj.ID, obj.ExternalCoating, obj.ExternalInsulation, obj.InternalCladding, obj.InternalCoating, obj.InternalLining, obj.ExternalCoatingDate, obj.ExternalCoatingQuality, obj.ExternalInsulationType, obj.InsulationCondition, obj.InsulationContainsChloride, obj.InternalLinerCondition, obj.InternalLinerType, obj.CladdingCorrosionRate, obj.SupportConfigNotAllowCoatingMaint);
}
public void ShowDatatoControl(int ID)
{
RW_COATING_BUS BUS = new RW_COATING_BUS();
RW_COATING coat = BUS.getData(ID);
String[] extQuality = { "No coating or poor quality", "Medium coating quality", "High coating quality" };
String[] inType = { "Organic", "Castable refractory", "Strip lined alloy", "Castable refractory severe condition", "Glass lined", "Acid Brick", "Fibreglass" };
String[] inCon = { "Good", "Average", "Poor", "Unknown" };
String[] extType = { "Foam Glass", "Pearlite", "Fibreglass", "Mineral Wool", "Calcium Silicate", "Asbestos" };
String[] isuCon = { "Above average", "Average", "Below average" };
if (coat.ExternalCoating == 1)
{
chkExternalCoat.Checked = true;
}
else
{
chkExternalCoat.Checked = false;
}
if (coat.ExternalInsulation == 1)
{
chkExternalIsulation.Checked = true;
}
else
{
chkExternalIsulation.Checked = false;
}
if (coat.InternalCladding == 1)
{
chkInternalCladding.Checked = true;
}
else
{
chkInternalCladding.Checked = false;
}
if (coat.InternalCoating == 1)
{
chkInternalCoat.Checked = true;
}
else
{
chkInternalCoat.Checked = false;
}
if (coat.InternalLining == 1)
{
chkInternalLining.Checked = true;
}
else
{
chkInternalLining.Checked = false;
}
dateExternalCoating.DateTime = coat.ExternalCoatingDate;
for (int i = 0; i < extQuality.Length; i++)
{
if (coat.ExternalCoatingQuality == extQuality[i])
{
cbExternalCoatQuality.SelectedIndex = i;
break;
}
}
for (int i = 0; i < extType.Length; i++)
{
if (coat.ExternalInsulationType == extType[i])
{
cbExternalIsulation.SelectedIndex = i + 1;
break;
}
}
for (int i = 0; i < inCon.Length; i++)
{
if (coat.InternalLinerCondition == inCon[i])
{
cbInternalLinerCondition.SelectedIndex = i + 1;
break;
}
}
if (coat.InsulationContainsChloride == 1)
{
chkInsulationContainsChlorides.Checked = true;
}
else
{
chkInsulationContainsChlorides.Checked = false;
}
for (int i = 0; i < inType.Length; i++)
{
if (coat.InternalLinerType == inType[i])
{
cbInternalLinerType.SelectedIndex = i + 1;
break;
}
}
txtCladdingCorrosionRate.Text = coat.CladdingCorrosionRate.ToString();
if (coat.SupportConfigNotAllowCoatingMaint == 1)
{
chkSupport.Checked = true;
}
else
{
chkSupport.Checked = false;
}
for (int i = 0; i < isuCon.Length; i++)
{
if (coat.InsulationCondition == isuCon[i])
{
cbIsulationCondition.SelectedIndex = i + 1;
break;
}
}
}
public RW_COATING getData(int ID)
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
RW_COATING obj = new RW_COATING();
String sql = " Use [rbi] Select [ID], [ExternalCoating]" +
",[ExternalInsulation]" +
",[InternalCladding]" +
",[InternalCoating]" +
",[InternalLining]" +
",[ExternalCoatingDate]" +
",[ExternalCoatingQuality]" +
",[ExternalInsulationType]" +
",[InsulationCondition]" +
",[InsulationContainsChloride]" +
",[InternalLinerCondition]" +
",[InternalLinerType]" +
",[CladdingThickness]" +
",[CladdingCorrosionRate]" +
",[SupportConfigNotAllowCoatingMaint]" +
"From [dbo].[RW_COATING] 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.ExternalCoating = Convert.ToInt32(reader.GetBoolean(1));
obj.ExternalInsulation = Convert.ToInt32(reader.GetBoolean(2));
obj.InternalCladding = Convert.ToInt32(reader.GetBoolean(3));
obj.InternalCoating = Convert.ToInt32(reader.GetBoolean(4));
obj.InternalLining = Convert.ToInt32(reader.GetBoolean(5));
if (!reader.IsDBNull(6))
{
obj.ExternalCoatingDate = reader.GetDateTime(6);
}
if (!reader.IsDBNull(7))
{
obj.ExternalCoatingQuality = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
obj.ExternalInsulationType = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
obj.InsulationCondition = reader.GetString(9);
}
obj.InsulationContainsChloride = Convert.ToInt32(reader.GetBoolean(10));
if (!reader.IsDBNull(11))
{
obj.InternalLinerCondition = reader.GetString(11);
}
if (!reader.IsDBNull(12))
{
obj.InternalLinerType = reader.GetString(12);
}
if (!reader.IsDBNull(13))
{
obj.CladdingThickness = (float)reader.GetDouble(13);
}
if (!reader.IsDBNull(14))
{
obj.CladdingCorrosionRate = (float)reader.GetDouble(14);
}
obj.SupportConfigNotAllowCoatingMaint = Convert.ToInt32(reader.GetBoolean(15));
Console.WriteLine(obj.ExternalCoatingQuality);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(obj);
}
public List <RW_COATING> getDataSource()
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
List <RW_COATING> list = new List <RW_COATING>();
RW_COATING obj = null;
String sql = " Use [rbi] Select [ID]" +
",[ExternalCoating]" +
",[ExternalInsulation]" +
",[InternalCladding]" +
",[InternalCoating]" +
",[InternalLining]" +
",[ExternalCoatingDate]" +
",[ExternalCoatingQuality]" +
",[ExternalInsulationType]" +
",[InsulationCondition]" +
",[InsulationContainsChloride]" +
",[InternalLinerCondition]" +
",[InternalLinerType]" +
",[CladdingThickness]" +
",[CladdingCorrosionRate]" +
",[ConfigNotAllowCoatingMaint]" +
"From [dbo].[RW_COATING] ";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj = new RW_COATING();
obj.ID = reader.GetInt32(0);
obj.ExternalCoating = reader.GetInt32(1);
obj.ExternalInsulation = reader.GetInt32(2);
obj.InternalCladding = reader.GetInt32(3);
obj.InternalCoating = reader.GetInt32(4);
obj.InternalLining = reader.GetInt32(5);
if (!reader.IsDBNull(6))
{
obj.ExternalCoatingDate = reader.GetDateTime(6);
}
if (!reader.IsDBNull(7))
{
obj.ExternalCoatingQuality = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
obj.ExternalInsulationType = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
obj.InsulationCondition = reader.GetString(9);
}
obj.InsulationContainsChloride = reader.GetInt32(10);
if (!reader.IsDBNull(11))
{
obj.InternalLinerCondition = reader.GetString(11);
}
if (!reader.IsDBNull(12))
{
obj.InternalLinerType = reader.GetString(12);
}
if (!reader.IsDBNull(13))
{
obj.CladdingThickness = reader.GetFloat(13);
}
if (!reader.IsDBNull(14))
{
obj.CladdingCorrosionRate = reader.GetFloat(14);
}
obj.SupportConfigNotAllowCoatingMaint = reader.GetInt32(15);
list.Add(obj);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
