private void btnUpdGpsData_Click(object sender, EventArgs e)
{
try
{
coordonneespr gpre = new coordonneespr();
gpre.Idpr = txtg_Id_Pr.Text.Trim();
gpre.Wptpr = int.Parse(txtwpt.Text.Trim());
gpre.Latitude = txtlat.Text.Trim();
gpre.Longitude = txtlong.Text.Trim();
gpre.Altitude = int.Parse(txtalt.Text.Trim());
gpre.Epepr = int.Parse(txtepe.Text.Trim());
string strx = dtggpsdata["wptpr", dtggpsdata.CurrentRow.Index].Value.ToString();
if (xConn.State.ToString().Equals("Closed"))
{
xConn.Open();
}
gCmd = xConn.CreateCommand();
gCmd.CommandText = "update COORDONNEESPR set id_pr=@id_pr,wptpr=@wptpr,latitude=@latitude,longitude=@longitude,altitude=@altitude,epepr=@epepr where wptpr='" + strx + "'";
gCmd.Parameters.Add("id_pr", SqlDbType.VarChar, 25, "@id_pr").Value = gpre.Idpr;
gCmd.Parameters.Add("wptpr", SqlDbType.Int, 10, "@wptpr").Value = gpre.Wptpr;
gCmd.Parameters.Add("latitude", SqlDbType.VarChar, 20, "@latitude").Value = gpre.Latitude;
gCmd.Parameters.Add("longitude", SqlDbType.VarChar, 20, "@longitude").Value = gpre.Longitude;
gCmd.Parameters.Add("altitude", SqlDbType.Int, 10, "@altitude").Value = gpre.Altitude;
gCmd.Parameters.Add("epepr", SqlDbType.Int, 10, "@epepr").Value = gpre.Epepr;
int y = gCmd.ExecuteNonQuery();
}
catch (SqlException x)
{
MessageBox.Show(this, x.Message, "Error");
}
xConn.Close();
_EmptyGpsTextBox();
_FillBindingNavigator();
}
private void btnAddGpsData_Click(object sender, EventArgs e)
{
try
{
coordonneespr gpr = new coordonneespr();
gpr.Idpr = txtg_Id_Pr.Text.Trim();
gpr.Wptpr = int.Parse(txtwpt.Text.Trim());
gpr.Latitude = txtlat.Text.Trim();
gpr.Longitude = txtlong.Text.Trim();
gpr.Altitude = int.Parse(txtalt.Text.Trim());
gpr.Epepr = int.Parse(txtepe.Text.Trim());
if (xConn.State.ToString().Equals("Closed"))
{
xConn.Open();
}
gCmd = xConn.CreateCommand();
gCmd.CommandText = "insert into COORDONNEESPR(id_pr,wptpr,latitude,longitude,altitude,epepr) values(@id_pr,@wptpr,@latitude,@longitude,@altitude,@epepr)";
gCmd.Parameters.Add("id_pr", SqlDbType.VarChar, 25, "@id_pr").Value = gpr.Idpr;
gCmd.Parameters.Add("wptpr", SqlDbType.Int, 10, "@wptpr").Value = gpr.Wptpr;
gCmd.Parameters.Add("latitude", SqlDbType.VarChar, 20, "@latitude").Value = gpr.Latitude;
gCmd.Parameters.Add("longitude", SqlDbType.VarChar, 20, "@longitude").Value = gpr.Longitude;
gCmd.Parameters.Add("altitude", SqlDbType.Int, 10, "@altitude").Value = gpr.Altitude;
gCmd.Parameters.Add("epepr", SqlDbType.Int, 10, "@epepr").Value = gpr.Epepr;
int y = gCmd.ExecuteNonQuery();
}
catch (SqlException x)
{
MessageBox.Show(this, x.Message, "Error");
}
xConn.Close();
_EmptyGpsTextBox();
_FillBindingNavigator();
}