private void getChekedItems()
{
DBRelief dbr = new DBRelief(dbFile);
DataTable dt = dbr.getStructure("frmoptionduty");
IEnumerable <CheckBox> collection = gridDuty.FindChildren <CheckBox>();
foreach (CheckBox chk in collection)
{
if (chk.IsChecked == true)
{
string strIdx = chk.Name.Substring(3);
items.Add(int.Parse(strIdx));
DataRow dr = dt.NewRow();
dr["case_id"] = strIdx;
dr["visiofile"] = vsdFile;
dt.Rows.Add(dr);
if (strIdx == "3")
{
for (int i = 14; i <= 18; i++)
{
dr = dt.NewRow();
dr["case_id"] = i;
dr["visiofile"] = vsdFile;
dt.Rows.Add(dr);
items.Add(i);
}
}
}
}
dbr.saveDataByTable(dt, vsdFile);
}
private void saveData()
{
DBRelief dbWrite = new DBRelief(dbFile);
if (gridStreamIn.ItemsSource != null)
{
DataView dvFeed = (DataView)gridStreamIn.ItemsSource;
dtfrmcase_feed.Merge(dvFeed.Table);
DataView dvProduct = (DataView)gridStreamOut.ItemsSource;
dtfrmcase_product.Merge(dvProduct.Table);
DataView dvReboiler = (DataView)gridHeatIn.ItemsSource;
dtfrmcase_reboiler.Merge(dvReboiler.Table);
DataView dvCondenser = (DataView)gridHeatOut.ItemsSource;
dtfrmcase_condenser.Merge(dvCondenser.Table);
DataRow dr = dtfrmcase.NewRow();
dr["case_id"] = case_id;
dr["visiofile"] = vsdFile;
dr["relieftemp"] = txtReliefTemp.Text;
dr["reliefpress"] = txtReliefPress.Text;
dr["reliefrate"] = txtReliefRate.Text;
dr["reliefmw"] = txtReliefMW.Text;
dtfrmcase.Rows.Add(dr);
}
dbWrite.saveDataByTable(dtfrmcase, vsdFile);
dbWrite.saveDataByTable(dtfrmcase_feed, vsdFile);
dbWrite.saveDataByTable(dtfrmcase_product, vsdFile);
dbWrite.saveDataByTable(dtfrmcase_reboiler, vsdFile);
dbWrite.saveDataByTable(dtfrmcase_condenser, vsdFile);
}
private void bindDataGrid()
{
DBRelief dbR = new DBRelief(dbFile);
DataTable dt = dbR.getDataByVsdFile("frmfire", vsdFile);
if (dt != null)
{
if (dt.Rows.Count != 0)
{
fireDataGrid.ItemsSource = dt.DefaultView;
}
else
{
DataTable dtCondenser = dbR.getDataByVsdFile("frmcondenser", vsdFile);
foreach (DataRow drCondenser in dtCondenser.Rows)
{
DataRow dr = dt.NewRow();
dr["equipment_no"] = drCondenser["heatername"].ToString();
dr["visiofile"] = vsdFile;
dt.Rows.Add(dr);
}
DataTable dtReboiler = dbR.getDataByVsdFile("frmreboiler", vsdFile);
foreach (DataRow drReboiler in dtReboiler.Rows)
{
DataRow dr = dt.NewRow();
dr["equipment_no"] = drReboiler["heatername"].ToString();
dr["visiofile"] = vsdFile;
dt.Rows.Add(dr);
}
DataTable dtAccumulator = dbR.getDataByVsdFile("frmAccumulator", vsdFile);
foreach (DataRow drAccumulator in dtAccumulator.Rows)
{
DataRow dr = dt.NewRow();
dr["equipment_no"] = drAccumulator["accumulatorname"].ToString();
dr["visiofile"] = vsdFile;
dt.Rows.Add(dr);
}
dbR.saveDataByTable(dt, vsdFile);
dt = dbR.getDataByVsdFile("frmfire", vsdFile);
fireDataGrid.ItemsSource = dt.DefaultView;
}
}
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
DBRelief dbR = new DBRelief(dbFile);
DataRow dr = dtTower.NewRow();
if (op == 0)
{
Application.Current.Properties.Add("FeedData", dtFeed);
Application.Current.Properties.Add("Condenser", dtCondenser);
Application.Current.Properties.Add("HxCondenser", dtHxCondenser);
Application.Current.Properties.Add("Reboiler", dtReboiler);
Application.Current.Properties.Add("HxReboiler", dtHxReboiler);
Application.Current.Properties.Add("ProdData", dtProd);
dtTower.Rows.Add(dr);
dr["towername"] = txtName.Text;
dr["stagenumber"] = this.txtStageNumber.Text;
dr["description"] = this.txtDescription.Text;
dr["visiofile"] = vsdFile;
if (!string.IsNullOrEmpty(przFile))
{
dr["przfile"] = przFile;
}
DataTable dtCondenserTemp = dtCondenser.Clone();
dtCondenserTemp.Merge(dtCondenser);
dtCondenserTemp.Merge(dtHxCondenser);
DataTable dtReboilerTemp = dtReboiler.Clone();
dtReboilerTemp.Merge(dtReboiler);
dtReboilerTemp.Merge(dtHxReboiler);
dbR.saveDataByTable(dtFeed, vsdFile);
dbR.saveDataByTable(dtProd, vsdFile);
dbR.saveDataByTable(dtSource, vsdFile);
dbR.saveDataByTable(dtSink, vsdFile);
dbR.saveDataByTable(dtCondenserTemp, vsdFile);
dbR.saveDataByTable(dtReboilerTemp, vsdFile);
dbR.saveDataByTable(dtTower, vsdFile);
}
else
{
dr = dtTower.Rows[0];
dr["towername"] = txtName.Text;
dr["stagenumber"] = this.txtStageNumber.Text;
dr["description"] = this.txtDescription.Text;
dr["visiofile"] = vsdFile;
if (!string.IsNullOrEmpty(przFile))
{
dr["przfile"] = przFile;
}
if (txtName.BorderBrush == Brushes.Green)
{
dr["towername_color"] = "green";
}
else
{
dr["towername_color"] = "blue";
}
if (txtStageNumber.BorderBrush == Brushes.Green)
{
dr["stagenumber_color"] = "green";
}
else
{
dr["stagenumber_color"] = "blue";
}
dbR.saveDataByRow(dr, 1);
}
this.DialogResult = true;
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text.ToString().Trim() == string.Empty)
{
CustomMessageBox msg = new CustomMessageBox();
msg.WindowStartupLocation = WindowStartupLocation.CenterScreen;
msg.tipcontent.Text = "PSV Name could not be empty";
msg.Show();
return;
}
string pressure = txtPress.Text.ToString().Trim();
if (pressure == string.Empty)
{
CustomMessageBox msg = new CustomMessageBox();
msg.WindowStartupLocation = WindowStartupLocation.CenterScreen;
msg.tipcontent.Text = "Pressure Name could not be empty";
msg.Show();
return;
}
else if (isNumber(pressure) == false)
{
CustomMessageBox msg = new CustomMessageBox();
msg.WindowStartupLocation = WindowStartupLocation.CenterScreen;
msg.tipcontent.Text = "Pressure could not be empty";
msg.Show();
return;
}
string relief = txtPrelief.Text.ToString().Trim();
if (relief == string.Empty)
{
CustomMessageBox msg = new CustomMessageBox();
msg.WindowStartupLocation = WindowStartupLocation.CenterScreen;
msg.tipcontent.Text = "Prelief's Value could not be empty";
msg.Show();
return;
}
else if (isNumber(pressure) == false)
{
CustomMessageBox msg = new CustomMessageBox();
msg.WindowStartupLocation = WindowStartupLocation.CenterScreen;
msg.tipcontent.Text = "Prelief's Value must be a number";
msg.Show();
return;
}
DBRelief dbR = new DBRelief(dbFile);
dtpsv = dtpsv.Clone();
DataRow dr = dtpsv.NewRow();
if (dtpsv.Rows.Count == 0)
{
dtpsv.Rows.Add(dr);
}
else
{
dr = dtpsv.Rows[0];
}
dr["visiofile"] = vsdFile;
dr["psvname"] = txtName.Text;
dr["description"] = txtDescription.Text;
dr["valvetype"] = cbxValueType.SelectedItem.ToString();
dr["valvenumber"] = txtValveNumber.Text;
dr["pressure"] = txtPress.Text;
dr["reliefmultiple"] = txtPrelief.Text;
dr["location"] = cbxLocation.SelectedItem.ToString();
dr["locationdescription"] = txtLocationDescription.Text;
dbR.saveDataByTable(dtpsv, vsdFile);
this.DialogResult = true;
}
private void saveDataToDB()
{
DBRelief dbr = new DBRelief(dbFile);
dtfrmbasecase = dtfrmbasecase.Clone();
DataRow dr = dtfrmbasecase.NewRow();
dr["description"] = this.txtDescription.Text;
dr["latentheat"] = this.txtRunResult.Text;
dr["visiofile"] = vsdFile;
dr["Tray1Pressure"] = strTray1Pressure;
dr["vapor"] = vapor;
dr["liquid"] = liquid;
dr["dir"] = tempdir;
dr["Temperature"] = tempTemperature;
dtfrmbasecase.Rows.Add(dr);
DataView dvFeed = (DataView)gridStreamIn.ItemsSource;
DataView dvProduct = (DataView)gridStreamOut.ItemsSource;
DataView dvReboiler = (DataView)gridHeatIn.ItemsSource;
DataView dvCondenser = (DataView)gridHeatOut.ItemsSource;
DataTable dtFeed = dvFeed.Table.Copy();
DataTable dtProduct = dvProduct.Table;
dbr.saveDataByTable(dtfrmbasecase, vsdFile);
dbr.saveDataByTable(dtFeed, vsdFile);
dbr.saveDataByTable(dtProduct, vsdFile);
dbr.saveDataByTable(dvReboiler.Table, vsdFile);
dbr.saveDataByTable(dvCondenser.Table, vsdFile);
dbr.saveDataByTable(dtFlashResult, vsdFile);
dtfrmcase_feed = dtfrmcase_feed.Clone();
dtfrmcase_product = dtfrmcase_product.Clone();
dtfrmcase_reboiler = dtfrmcase_reboiler.Clone();
dtfrmcase_condenser = dtfrmcase_condenser.Clone();
dtfrmcase = dtfrmcase.Clone();
foreach (KeyValuePair <int, UC_CaseStudy> uc in dicCase)
{
if (uc.Value.gridStreamIn.ItemsSource != null)
{
dvFeed = (DataView)uc.Value.gridStreamIn.ItemsSource;
dtfrmcase_feed.Merge(dvFeed.ToTable());
dvProduct = (DataView)uc.Value.gridStreamOut.ItemsSource;
dtfrmcase_product.Merge(dvProduct.ToTable());
dvReboiler = (DataView)uc.Value.gridHeatIn.ItemsSource;
dtfrmcase_reboiler.Merge(dvReboiler.ToTable());
dvCondenser = (DataView)uc.Value.gridHeatOut.ItemsSource;
dtfrmcase_condenser.Merge(dvCondenser.ToTable());
dr = dtfrmcase.NewRow();
dr["case_id"] = uc.Key;
dr["visiofile"] = vsdFile;
dr["relieftemp"] = uc.Value.txtReliefTemp.Text;
dr["reliefpress"] = uc.Value.txtReliefPress.Text;
dr["reliefrate"] = uc.Value.txtReliefRate.Text;
dr["reliefmw"] = uc.Value.txtReliefMW.Text;
dtfrmcase.Rows.Add(dr);
}
}
dbr.saveDataByTable(dtfrmcase, vsdFile);
dbr.saveDataByTable(dtfrmcase_feed, vsdFile);
dbr.saveDataByTable(dtfrmcase_product, vsdFile);
dbr.saveDataByTable(dtfrmcase_reboiler, vsdFile);
dbr.saveDataByTable(dtfrmcase_condenser, vsdFile);
}
