private PTM TransformPRS92(Param param, PTM old)
{
PTM ptm;
ptm.northing = Math.Round((((param.b * -1) * old.easting) + (param.a * old.northing) + param.cn), 6);
ptm.easting = Math.Round(((param.a * old.easting) + (param.b * old.northing) + param.ce), 6);
return(ptm);
}
private void Tranform(string project)
{
using (SqlConnection cnn = new SqlConnection(connectionString))
{
cnn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM LOTDATA WHERE CADSURVEYNO='" + project + "'", cnn);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
PTM ptm;
Param param;
string a = textBoxa.Text.Replace(" ", string.Empty);
string b = textBoxb.Text.Replace(" ", string.Empty);
string ce = textBoxCE.Text.Replace(" ", string.Empty);
string cn = textBoxCN.Text.Replace(" ", string.Empty);
Double.TryParse(a, out param.a);
Double.TryParse(b, out param.b);
Double.TryParse(ce, out param.ce);
Double.TryParse(cn, out param.cn);
progressBar1.Visible = true;
progressBar1.Minimum = 1;
progressBar1.Maximum = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
Application.DoEvents();
if (cancelme == true)
{
this.buttonTranforn.Text = "Transform";
this.progressBar1.Visible = false;
return;
}
progressBar1.Value = i + 1;
if (dt.Rows[i]["ptmy"] != DBNull.Value || dt.Rows[i]["ptmx"] != DBNull.Value)
{
ptm.northing = Convert.ToDouble(dt.Rows[i]["ptmy"]);
ptm.easting = Convert.ToDouble(dt.Rows[i]["ptmx"]);
PTM prs = TransformPRS92(param, ptm);
SqlCommand updatecmd = new SqlCommand("Update LOTDATA set prsx=" + prs.easting + "," + "prsy=" + prs.northing + " Where CadSurveyNo='" + dt.Rows[i]["CADSURVEYNO"] + "' and MunicipalityPsgc='" + dt.Rows[i]["MunicipalityPsgc"] + "' and CadCaseNo='" + dt.Rows[i]["CADCASENO"] + "' and BarangayPsgc='" + dt.Rows[i]["BARANGAYPSGC"] + "' and Quadrangle='" + dt.Rows[i]["QUADRANGLE"] + "' and SectionId='" + dt.Rows[i]["SECTIONID"] + "' and LotNo='" + dt.Rows[i]["LOTNO"] + "' and [Sequence]=" + dt.Rows[i]["SEQUENCE"], cnn);
try
{
updatecmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
this.textBoxLogs.AppendText(ex.Message + Environment.NewLine);
this.textBoxLogs.AppendText(prs.northing.ToString() + Environment.NewLine);
this.textBoxLogs.AppendText(prs.easting.ToString() + Environment.NewLine);
}
}
else
{
this.textBoxLogs.AppendText(dt.Rows[i]["CADSurveyNo"].ToString() + " - LOT " + dt.Rows[i]["LOtNo"].ToString() + " Corner " + dt.Rows[i]["SEQUENCE"].ToString() + " no ptm coordinates" + Environment.NewLine);
}
}
MessageBox.Show("Finished");
this.buttonTranforn.Text = "Transform";
progressBar1.Visible = false;
}
}
private PTM TransformPRS92(Param param,PTM old)
{
PTM ptm;
ptm.northing = Math.Round((((param.b * -1) * old.easting) + (param.a * old.northing) + param.cn),6);
ptm.easting =Math.Round(( (param.a * old.easting) + (param.b * old.northing) + param.ce),6);
return ptm;
}
