private void btnSave_Click(object sender, EventArgs e) { try { if (cmbXValue.SelectedIndex > -1 && cmbYValue.SelectedIndex > -1 && cmbZValue.SelectedIndex > -1) { if (DgvMasterSettings.Rows.Count > 0) { // Truncate Old Data SPMasterSettings objSpTrun = new SPMasterSettings(); objSpTrun.ExicuteRuntimeQuery("TRUNCATE TABLE Tbl_Wells_Details"); // Insert New Data string strXVal = cmbXValue.Text; string strYVal = cmbYValue.Text; string strZVal = cmbZValue.Text; for (int i = 0; i < DgvMasterSettings.Rows.Count; i++) { WellModel objModel = new WellModel(); WellSP objSp = new WellSP(); try { if (DgvMasterSettings.Rows[i].Cells[0].Value != null) { objModel.WellName = DgvMasterSettings.Rows[i].Cells[0].Value.ToString(); objModel.XValue = Convert.ToDecimal(DgvMasterSettings.Rows[i].Cells[strXVal].Value.ToString() != string.Empty ? DgvMasterSettings.Rows[i].Cells[strXVal].Value : 0); objModel.YValue = Convert.ToDecimal(DgvMasterSettings.Rows[i].Cells[strYVal].Value.ToString() != string.Empty ? DgvMasterSettings.Rows[i].Cells[strYVal].Value : 0); objModel.ZValue = Convert.ToDecimal(DgvMasterSettings.Rows[i].Cells[strZVal].Value.ToString() != string.Empty ? DgvMasterSettings.Rows[i].Cells[strZVal].Value : 0); objSp.WellsInsertUpdate(objModel); } } catch (Exception exe) { MessageBox.Show("Well Details Insert Error at: " + objModel.WellName, "EPMS", MessageBoxButtons.OK, MessageBoxIcon.Error); } } MessageBox.Show("All Data Saved to database Successfully..!", "EPMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Load the data first", "EPMS", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("X Y Z Values mandatory. Please select it first", "EPMS", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "EPMS", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void FillCombo() { try { WellSP spWell = new WellSP(); DataTable dtbl = spWell.GetWells(); cmbFromWell.DataSource = dtbl; cmbFromWell.ValueMember = "Well_Id"; cmbFromWell.DisplayMember = "Well_Name"; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "EPMS-Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Common.WriteToFile(ex.Message, false); } }
private void DoCalculation() { try { dtblOutPut = new DataTable(); DataSet DsData = new DataSet(); WellSP spWell = new WellSP(); DsData = spWell.GetWellDetails(Convert.ToInt32(cmbFromWell.SelectedValue.ToString())); DataTable dtblFromWell = new DataTable(); DataTable dtblToWell = new DataTable(); if (!dtblOutPut.Columns.Contains("WellName")) { dtblOutPut.Columns.Add("WellName"); dtblOutPut.Columns.Add("XVal"); dtblOutPut.Columns.Add("YVal"); dtblOutPut.Columns.Add("ZVal"); dtblOutPut.Columns.Add("Result"); } if (DsData.Tables.Count == 2) { dtblFromWell = DsData.Tables[0]; dtblToWell = DsData.Tables[1]; } double decFirstXVal = 0; double decFirstYVal = 0; double decFirstZVal = 0; if (dtblFromWell.Rows.Count > 0) { decFirstXVal = Convert.ToDouble(dtblFromWell.Rows[0]["X_Val"].ToString()); decFirstYVal = Convert.ToDouble(dtblFromWell.Rows[0]["Y_Val"].ToString()); decFirstZVal = Convert.ToDouble(dtblFromWell.Rows[0]["Z_Val"].ToString()); } for (int i = 0; i < dtblToWell.Rows.Count; i++) { string strWellName = dtblToWell.Rows[i]["Well_Name"].ToString(); double decSecXVal = Convert.ToDouble(dtblToWell.Rows[i]["X_Val"].ToString()); double decSecYVal = Convert.ToDouble(dtblToWell.Rows[i]["Y_Val"].ToString()); double decSecZVal = Convert.ToDouble(dtblToWell.Rows[i]["Z_Val"].ToString()); double decXVal = decFirstXVal - decSecXVal; double decYVal = decFirstYVal - decSecYVal; double decZVal = decFirstZVal - decSecZVal; double dexXValSum = decXVal * decXVal; double dexYValSum = decYVal * decYVal; double dexZValSum = decZVal * decZVal; double decSum = (dexXValSum + dexYValSum + dexZValSum); double dbResult = Math.Sqrt(decSum); DataRow dr = dtblOutPut.NewRow(); dr["WellName"] = dtblToWell.Rows[i]["Well_Name"].ToString(); dr["XVal"] = decSecXVal; dr["YVal"] = decSecYVal; dr["ZVal"] = decSecZVal; dr["Result"] = Math.Round(dbResult, 3); dtblOutPut.Rows.Add(dr); } DgvReport.DataSource = dtblOutPut; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "EPMS-Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Common.WriteToFile(ex.Message, false); } }