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