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);
}
}
