public void edit(RW_CORROSION_RATE_TANK obj)
{
DAL.edit(int.Parse(obj.CorrosionID), (int)(obj.ID), obj.SoilSideCorrosionRate, obj.ProductSideCorrosionRate, obj.PotentialCorrosion,
obj.TankPadMaterial, obj.TankDrainageType, obj.CathodicProtectionType, obj.TankBottomType, obj.SoilSideTemperature,
obj.ProductCondition, obj.ProductSideTemp, obj.SteamCoil, obj.WaterDrawOff,
obj.ProductSideBottom, obj.ModifiedSoilSideCorrosionRate, obj.ModifiedProductSideCorrosionRate, obj.FinalEstimatedCorrosionRate);
}
private void btnAddRow_Click(object sender, EventArgs e)
{
RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS();
RW_CORROSION_RATE_TANK obj = new RW_CORROSION_RATE_TANK();
RW_ASSESSMENT_BUS busAssessment = new RW_ASSESSMENT_BUS();
List <RW_ASSESSMENT> listAss = busAssessment.getDataSource();
//int ID = listAss.Max(RW_ASSESSMENT => RW_ASSESSMENT.ID);
obj.ID = Proposal_ID;
busConRate.add(obj);
unitdata(showData(Proposal_ID));
}
private List <RW_CORROSION_RATE_TANK> showData(int ID)
{
RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS();
List <RW_CORROSION_RATE_TANK> listConRate = busConRate.getDataSource(ID);
List <RW_CORROSION_RATE_TANK> listdata = new List <RW_CORROSION_RATE_TANK>();
foreach (RW_CORROSION_RATE_TANK ConRate in listConRate)
{
RW_CORROSION_RATE_TANK RwConRate = ConRate;
listdata.Add(RwConRate);
}
return(listdata);
}
public void SaveDateCorrosinRate()
{
RW_CORROSION_RATE_TANK CorTank = new RW_CORROSION_RATE_TANK();
RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS();
int[] selectedRowHandles = gridView1.GetSelectedRows();
for (int i = 0; i < selectedRowHandles.Length; i++)
{
CorTank = getData(i);
MessageBox.Show(CorTank.SoilSideCorrosionRate.ToString());
CorTank.ID = (float)Proposal_ID;
MessageBox.Show(CorTank.ID.ToString());
busConRate.edit(CorTank);
}
}
private void btnCalculateCorrosionRate_Click(object sender, EventArgs e)
{
RW_CORROSION_RATE_TANK CorTank = new RW_CORROSION_RATE_TANK();
Corrosion_Rate CorRate = new Corrosion_Rate();
List <RW_CORROSION_RATE_TANK> list = new List <RW_CORROSION_RATE_TANK>();
int[] selectedRowHandles = gridView1.GetSelectedRows();
for (int i = 0; i < selectedRowHandles.Length; i++)
{
CorTank = getData(i);
CorRate.SoilSideCorrosionRate = CorTank.SoilSideCorrosionRate;
CorRate.ProductSideCorrosionRate = CorTank.ProductSideCorrosionRate;
CorRate.PotentialCorrosion = CorTank.PotentialCorrosion;
CorRate.TankPadMaterial = CorTank.TankPadMaterial;
CorRate.TankDrainageType = CorTank.TankDrainageType;
CorRate.CathodicProtectionType = CorTank.CathodicProtectionType;
CorRate.TankBottomType = CorTank.TankBottomType;
CorRate.SoilSideTemperature = CorTank.SoilSideTemperature;
CorRate.ProductCondition = CorTank.ProductCondition;
CorRate.ProductSideTemp = CorTank.ProductSideTemp;
CorRate.SteamCoil = CorTank.SteamCoil;
CorRate.WaterDrawOff = CorTank.WaterDrawOff;
CorRate.ProductSideBottom = CorTank.ProductSideBottom;
CorRate.ModifiedSoilSideCorrosionRate = CorRate.CRS_Bottom();
CorRate.ModifiedProductSideCorrosionRate = CorRate.CRP_Bottom();
CorRate.FinalEstimatedCorrosionRate = CorRate.Final_CR();
CorTank.ModifiedSoilSideCorrosionRate = CorRate.CRS_Bottom();
CorTank.ModifiedProductSideCorrosionRate = CorRate.CRP_Bottom();
CorTank.FinalEstimatedCorrosionRate = CorRate.Final_CR();
//MessageBox.Show(CorTank.PotentialCorrosion.ToString());
//MessageBox.Show("SR="+CorRate.F_SR().ToString()+" PA= "+CorRate.F_PA().ToString()+" ID="+CorRate.F_ID().ToString()+" CP="+CorRate.F_CP().ToString()+" TB="+CorRate.F_TB().ToString()+" ST="+CorRate.F_ST().ToString());
Console.WriteLine(CorTank.SoilSideCorrosionRate);
MessageBox.Show(CorTank.ModifiedSoilSideCorrosionRate.ToString() + "::" + CorTank.ModifiedProductSideCorrosionRate.ToString() + "::" + CorTank.FinalEstimatedCorrosionRate.ToString());
list.Add(CorTank);
Console.WriteLine("update ok");
}
unitdata(list);
}
public void delete(RW_CORROSION_RATE_TANK obj)
{
DAL.delete(int.Parse(obj.CorrosionID));
}
/// get datasource
///
public List <RW_CORROSION_RATE_TANK> getDataSource(int proposal_ID)
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
List <RW_CORROSION_RATE_TANK> list = new List <RW_CORROSION_RATE_TANK>();
RW_CORROSION_RATE_TANK obj = null;
String sql = "USE[rbi] SELECT [ID]" +
",[CorrosionID]" +
",[SoilSideCorrosionRate]" +
",[ProductSideCorrosionRate]" +
",[PotentialCorrosion]" +
",[TankPadMaterial]" +
",[TankDrainageType]" +
",[CathodicProtectionType]" +
",[TankBottomType]" +
",[SoilSideTemperature]" +
",[ProductCondition]" +
",[ProductSideTemp]" +
",[SteamCoil]" +
",[WaterDrawOff]" +
",[ProductSideBottom]" +
",[ModifiedSoilSideCorrosionRate]" +
",[ModifiedProductSideCorrosionRate]" +
",[FinalEstimatedCorrosionRate]" +
" FROM [rbi].[dbo].[RW_CORROSION_RATE_TANK] WHERE [ID] = '" + proposal_ID + "'";
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_CORROSION_RATE_TANK();
obj.ID = reader.GetInt32(0);
obj.CorrosionID = reader.GetInt32(1);
if (!reader.IsDBNull(2))
{
obj.SoilSideCorrosionRate = (float)reader.GetDouble(2);
}
if (!reader.IsDBNull(3))
{
obj.ProductSideCorrosionRate = (float)reader.GetDouble(3);
}
if (!reader.IsDBNull(4))
{
obj.PotentialCorrosion = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
obj.TankPadMaterial = reader.GetString(5);
}
if (!reader.IsDBNull(6))
{
obj.TankDrainageType = reader.GetString(6);
}
if (!reader.IsDBNull(7))
{
obj.CathodicProtectionType = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
obj.TankBottomType = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
obj.SoilSideTemperature = reader.GetString(9);
}
if (!reader.IsDBNull(10))
{
obj.ProductCondition = reader.GetString(10);
}
if (!reader.IsDBNull(11))
{
obj.ProductSideTemp = reader.GetString(11);
}
if (!reader.IsDBNull(12))
{
obj.SteamCoil = reader.GetString(12);
}
if (!reader.IsDBNull(13))
{
obj.WaterDrawOff = reader.GetString(13);
}
if (!reader.IsDBNull(14))
{
obj.ProductSideBottom = reader.GetString(14);
}
if (!reader.IsDBNull(15))
{
obj.ModifiedSoilSideCorrosionRate = (float)reader.GetDouble(15);
}
if (!reader.IsDBNull(16))
{
obj.ModifiedProductSideCorrosionRate = (float)reader.GetDouble(16);
}
if (!reader.IsDBNull(17))
{
obj.FinalEstimatedCorrosionRate = (float)reader.GetDouble(17);
}
list.Add(obj);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL");
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
private RW_CORROSION_RATE_TANK getData(int row)
{
RW_CORROSION_RATE_TANK CorRate = new RW_CORROSION_RATE_TANK();
RW_CORROSION_RATE_TANK_BUS busCorRate = new RW_CORROSION_RATE_TANK_BUS();
GridColumn CorrosionID = gridView1.Columns[0]; //CorrosionID
GridColumn SoilSideCorrosionRate = gridView1.Columns[1]; //"Soil Side Base Corrosion Rate"
GridColumn ProductSideCorrosionRate = gridView1.Columns[2]; //"Product Side Base Corrosion Rate"
GridColumn PotentialCorrosion = gridView1.Columns[3]; //"Potential Corrosion Activity(Resistivity)"
GridColumn TankPadMaterial = gridView1.Columns[4]; //"Tank Pad Meterial"
GridColumn TankDrainageType = gridView1.Columns[5]; //"Tank Drainage Type"
GridColumn CathodicProtectionType = gridView1.Columns[6]; //"Cathodic Protection Type"
GridColumn TankBottomType = gridView1.Columns[7]; //"Tank bottom Type"
GridColumn SoilSideTemperature = gridView1.Columns[8]; //"Tank bottom Type"
GridColumn ProductCondition = gridView1.Columns[9]; //"Product Side Condition"
GridColumn ProductSideTemp = gridView1.Columns[10]; //"Product Side Temperature"
GridColumn SteamCoil = gridView1.Columns[11]; //"Stram Coil";
GridColumn WaterDrawOff = gridView1.Columns[12]; //"Water Draw-off"
GridColumn ProductSideBottom = gridView1.Columns[13]; //"Product Side Bottom Corrosion"
GridColumn ModifiedSoilSideCorrosionRate = gridView1.Columns[14];
GridColumn ModifiedProductSideCorrosionRate = gridView1.Columns[15];
GridColumn FinalEstimatedCorrosionRate = gridView1.Columns[16];
int[] selectedRowHandles = gridView1.GetSelectedRows();
try
{
CorRate.CorrosionID = (int)gridView1.GetRowCellValue(row, CorrosionID);
}
catch
{
CorRate.CorrosionID = 0;
}
try
{
CorRate.SoilSideCorrosionRate = (float)gridView1.GetRowCellValue(row, SoilSideCorrosionRate);
}
catch
{
CorRate.SoilSideCorrosionRate = 0;
}
try
{
CorRate.ProductSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ProductSideCorrosionRate);
}
catch
{
CorRate.ProductSideCorrosionRate = 0;
}
CorRate.PotentialCorrosion = gridView1.GetRowCellDisplayText(row, PotentialCorrosion).ToString();
CorRate.TankPadMaterial = gridView1.GetRowCellDisplayText(row, TankPadMaterial).ToString();
CorRate.TankDrainageType = gridView1.GetRowCellDisplayText(row, TankDrainageType).ToString();
CorRate.CathodicProtectionType = gridView1.GetRowCellDisplayText(row, CathodicProtectionType).ToString();
CorRate.TankBottomType = gridView1.GetRowCellDisplayText(row, TankBottomType).ToString();
CorRate.SoilSideTemperature = gridView1.GetRowCellDisplayText(row, SoilSideTemperature).ToString();
CorRate.ProductCondition = gridView1.GetRowCellDisplayText(row, ProductCondition).ToString();
CorRate.ProductSideTemp = gridView1.GetRowCellDisplayText(row, ProductSideTemp).ToString();
CorRate.SteamCoil = gridView1.GetRowCellDisplayText(row, SteamCoil).ToString();
CorRate.WaterDrawOff = gridView1.GetRowCellDisplayText(row, WaterDrawOff).ToString();
CorRate.ProductSideBottom = gridView1.GetRowCellDisplayText(row, ProductSideBottom).ToString();
try
{
CorRate.ModifiedSoilSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ModifiedSoilSideCorrosionRate);
}
catch
{
CorRate.ModifiedProductSideCorrosionRate = 0;
}
try
{
CorRate.ModifiedProductSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ModifiedProductSideCorrosionRate);
}
catch
{
CorRate.ModifiedProductSideCorrosionRate = 0;
}
try
{
CorRate.FinalEstimatedCorrosionRate = (float)gridView1.GetRowCellValue(row, FinalEstimatedCorrosionRate);
}
catch
{
CorRate.FinalEstimatedCorrosionRate = 0;
}
return(CorRate);
}
