public Boolean Update(clsVehiculoTransporte veh)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("ActualizaVehiculoTransporte", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("codveh", veh.CodVehiculoTransporte);
cmd.Parameters.AddWithValue("placa", veh.Placa);
cmd.Parameters.AddWithValue("codmar", veh.CodMarca);
cmd.Parameters.AddWithValue("codmod", veh.CodModelo);
cmd.Parameters.AddWithValue("año", veh.Año);
cmd.Parameters.AddWithValue("constancia", veh.ConstanciaInscripcion);
cmd.Parameters.AddWithValue("confvehicular", veh.ConfVehicular);
cmd.Parameters.AddWithValue("mtc", veh.MTC);
cmd.Parameters.AddWithValue("soat", veh.Soat);
int x = cmd.ExecuteNonQuery();
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean update(clsVehiculoTransporte veh)
{
try
{
return(Mveh.Update(veh));
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
private void cargaVehiculoTransporte()
{
veh = AdmVT.MuestraVehiculoTransporte(veh.CodVehiculoTransporte);
if (veh != null)
{
txtCodigo.Text = veh.CodVehiculoTransporte.ToString();
txtAño.Text = veh.Año.ToString();
txtPlaca.Text = veh.Placa;
txtConstancia.Text = veh.ConstanciaInscripcion;
cmbMarca.SelectedValue = veh.CodMarca;
CargaModelos(veh.CodMarca);
cmbModelo.Enabled = true;
cmbModelo.SelectedValue = veh.CodModelo;
txtSoat.Text = veh.Soat;
txtConfVehicular.Text = veh.ConfVehicular;
txtmtc.Text = veh.MTC;
}
}
public Boolean insert(clsVehiculoTransporte veh)
{
try
{
return(Mveh.Insert(veh));
}
catch (Exception ex)
{
if (ex.Message.Contains("Duplicate entry"))
{
DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: N°- de Documento Repetido", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(false);
}
}
public clsVehiculoTransporte CargaVehiculoTransporte(Int32 Codigo)
{
clsVehiculoTransporte veh = null;
try
{
con.conectarBD();
cmd = new MySqlCommand("MuestraVehiculoTransporte", con.conector);
cmd.Parameters.AddWithValue("codveh", Codigo);
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
veh = new clsVehiculoTransporte();
veh.CodVehiculoTransporte = Convert.ToInt32(dr.GetDecimal(0));
veh.Placa = dr.GetString(1);
veh.CodMarca = Convert.ToInt32(dr.GetDecimal(2));
veh.Marca = dr.GetString(3);
veh.CodModelo = Convert.ToInt32(dr.GetDecimal(4));
veh.Modelo = dr.GetString(5);
veh.Año = Convert.ToInt32(dr.GetDecimal(6));
veh.ConstanciaInscripcion = dr.GetString(7);
veh.Estado = dr.GetBoolean(8);
veh.CodUser = Convert.ToInt32(dr.GetDecimal(9));
veh.FechaRegistro = dr.GetDateTime(10);// capturo la fecha
veh.Soat = dr.GetString(11);
veh.ConfVehicular = dr.GetString(12);
veh.MTC = dr.GetString(13);
}
}
return(veh);
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean Insert(clsVehiculoTransporte veh)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("GuardaVehiculoTransporte", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter oParam;
oParam = cmd.Parameters.AddWithValue("placa", veh.Placa);
oParam = cmd.Parameters.AddWithValue("codmar", veh.CodMarca);
oParam = cmd.Parameters.AddWithValue("codmod", veh.CodModelo);
oParam = cmd.Parameters.AddWithValue("año", veh.Año);
oParam = cmd.Parameters.AddWithValue("constancia", veh.ConstanciaInscripcion);
oParam = cmd.Parameters.AddWithValue("codusu", veh.CodUser);
oParam = cmd.Parameters.AddWithValue("confvehicular", veh.ConfVehicular);
oParam = cmd.Parameters.AddWithValue("soat", veh.Soat);
oParam = cmd.Parameters.AddWithValue("mtc", veh.MTC);
oParam = cmd.Parameters.AddWithValue("newid", 0);
oParam.Direction = ParameterDirection.Output;
int x = cmd.ExecuteNonQuery();
veh.CodVehiculoTransporteNuevo = Convert.ToInt32(cmd.Parameters["newid"].Value);
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
