public static bool Insertar(Paquete p)
{
try
{
string query;
//conexion.ConnectionString = conexionParaSqlServer;
conexion.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog =correo-sp-2017; Integrated Security = True";
comando.CommandType = System.Data.CommandType.Text;
comando.Connection = conexion;
query = String.Format("INSERT INTO Paquetes (direccionEntrega,trakingID,alumno) VALUES ('{0}',{1},'{2}'", p.DireccionEntrega, p.TrackingID, "Rodriguez_Abbul_2D");
comando.CommandText = query;
conexion.Open();
return((comando.ExecuteNonQuery() > 0) ? true : false);
}
catch (Exception)
{
PaqueteDAO.eventoDeSQL("ERROR al insertar en base de datos");
return(false);
}
finally
{
conexion.Close();
}
}
