public void actualizaVehiculo(vehiculo_Entity vehc)
{
cnn.updateSQL("UPDATE VEHICULO SET placa = '" + vehc._placa + "', modelo='" + vehc._modelo + "', " +
" chasis = '" + vehc._chasis + "', linea = '" + vehc._linea + "' , motor = '" + vehc._motor + "', color = '" + vehc._color + "', " +
" marca = '" + vehc._marca + "' , idtipotrans = " + vehc._tipovehiculo + ", kilometraje = " + vehc._kms +
" WHERE idtransporte = " + vehc._cod_vehiculo);
}
public vehiculo_Entity verUno(int codigo)
{
vehiculo_Entity vehiculo = new vehiculo_Entity();
Vehiculo_DAL vhc = new Vehiculo_DAL();
vehiculo._cod_vehiculo = codigo;
return(vhc.verVehiculo(codigo));
}
public void insertaVehiculo(vehiculo_Entity vehc)
{
idempresa = Convert.ToInt32(empresa[0]);
cnn.insertSQL("INSERT INTO VEHICULO " +
"(idempresa, idtipotrans, placa, modelo, chasis, linea, motor, color, marca, kilometraje)" +
"VALUES(" + idempresa + ", " + vehc._tipovehiculo + ", '" + vehc._placa + "', '" + vehc._modelo + "', '" + vehc._chasis + "' " +
", '" + vehc._linea + "', '" + vehc._motor + "', '" + vehc._color + "', '" + vehc._marca + "', " + vehc._kms + ")");
}
public DataTable verVehiculosDisponibles(vehiculo_Entity vh)
{
DataTable dt = new DataTable();
Vehiculo_DAL vhc = new Vehiculo_DAL();
dt = vhc.VehiculosDisponiblesST(vh);
return(dt);
}
public DataTable verTodosVehiculos(vehiculo_Entity vh)
{
DataTable dt = new DataTable();
Vehiculo_DAL vhc = new Vehiculo_DAL();
dt = vhc.verVehiculos(vh);
return(dt);
}
public vehiculo_Entity verVehiculo(int codigo)
{
vehiculo_Entity vehiculo = new vehiculo_Entity();
DataTable dtRegistro = new DataTable();
dtRegistro = cnn.getSQL("SELECT V.*, TP.nombretipotrans, S.kmsproximoservicio " +
" FROM VEHICULO V " +
" JOIN TIPOVEHICULO TP ON V.idtipotrans = TP.idtipotrans " +
" LEFT JOIN (SELECT TOP 1 kmsproximoservicio, idtransporte " +
" FROM MORDENSERVICIOV " +
" WHERE idtransporte = " + codigo +
" ORDER BY fechaservicio) S ON V.idtransporte = S.idtransporte " +
" WHERE V.idtransporte = " + codigo);
foreach (DataRow row in dtRegistro.Rows)
{
foreach (DataColumn column in dtRegistro.Columns)
{
vehiculo._cod_vehiculo = Convert.ToInt32(row["idtransporte"]);
//vehiculo._placa = row["idempresa"].ToString();
vehiculo._tipovehiculo = Convert.ToInt32(row["idtipotrans"]);
vehiculo._placa = row["placa"].ToString();
vehiculo._modelo = row["modelo"].ToString();
vehiculo._chasis = row["chasis"].ToString();
vehiculo._linea = row["linea"].ToString();
vehiculo._motor = row["motor"].ToString();
vehiculo._color = row["color"].ToString();
vehiculo._marca = row["marca"].ToString();
if (row["kilometraje"] == DBNull.Value)
{
vehiculo._kms = 0.0;
}
else
{
vehiculo._kms = Convert.ToDouble(row["kilometraje"]);
}
vehiculo._nombretipov = row["nombretipotrans"].ToString();
if (row["kmsproximoservicio"] == DBNull.Value)
{
vehiculo._kmsprox = 0;
}
else
{
vehiculo._kmsprox = Convert.ToDecimal(row["kmsproximoservicio"]);
}
}
}
return(vehiculo);
}
private void btnGuardar_Click(object sender, EventArgs e)
{
if (txtMotor.Text == "" || txtModelo.Text == "" || txtMarca.Text == "" || txtLinea.Text == "" || txtKMinicio.Text == "")
{
MessageBox.Show("Faltan Datos Obligatorios");
}
else
{
vehiculo_Entity vhc = new vehiculo_Entity();
vhc._motor = txtMotor.Text.Trim();
vhc._modelo = txtModelo.Text.Trim();
vhc._marca = txtMarca.Text.Trim();
vhc._linea = txtLinea.Text.Trim();
vhc._color = txtColor.Text.Trim();
vhc._chasis = txtChasis.Text.Trim();
vhc._placa = txtPlaca.Text.Trim();
vhc._kms = Convert.ToDouble(String.Format("{0:0.00}", txtKMinicio.Text.Trim()));
vhc._tipovehiculo = Convert.ToInt32(cmbTipo.SelectedValue);
vhc._empresa = 1;
if (txtCodVehiculo.Text != "0")
{
try
{
vhc._cod_vehiculo = Convert.ToInt32(txtCodVehiculo.Text);
new BO.Vehiculo_BO().actualizaVehiculoBO(vhc);
MessageBox.Show("Vehiculo Actualizado Exitosamente");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
try
{
new BO.Vehiculo_BO().insertarVhcBO(vhc);
MessageBox.Show("Vehiculo Ingresado Exitosamente");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
txtDisabled();
}
}
//Muestra todos los vehiculos disponibles para un viaje
public DataTable VehiculosDisponiblesST(vehiculo_Entity vh)
{
DataTable dtRegistros = new DataTable();
dtRegistros = cnn.getSQL("SELECT V.idtransporte AS CODIGO, TV.nombretipotrans as TIPO_VEHICULO , marca AS MARCA, modelo AS MODELO , placa AS PLACA, kilometraje as KMS " +
" FROM VEHICULO V " +
" JOIN TIPOVEHICULO TV ON V.idtipotrans = TV.idtipotrans " +
" WHERE V.idtransporte not in (SELECT DISTINCT idtransporte " +
" FROM SOLICITUDTRANSPORTE " +
" WHERE idtransporte is not null " +
" AND idestadost not in (2, 3)) " +
" AND V.idtipotrans = CASE " + vh._tipovehiculo + " WHEN 0 THEN V.idtipotrans ELSE " + vh._tipovehiculo + " END" +
" AND V.idtransporte = CASE " + vh._cod_vehiculo + " WHEN 0 THEN V.idtransporte ELSE " + vh._cod_vehiculo + " END");
//" AND V.idtipotrans = ISNULL(" +vh._tipovehiculo+", V.idtipotrans)");
return(dtRegistros);
}
public DataTable verVehiculos(vehiculo_Entity vh)
{
idempresa = Convert.ToInt32(empresa[0]);
DataTable dtRegistros = new DataTable();
dtRegistros = cnn.getSQL("SELECT idtransporte AS CODIGO_VEHICULO, placa AS PLACA, modelo AS MODELO, linea AS LINEA," +
"motor AS MOTOR, color as COLOR, marca AS MARCA, TV.nombretipotrans as TIPO_VEHICULO " +
" FROM VEHICULO V" +
" JOIN TIPOVEHICULO TV ON V.idtipotrans = TV.idtipotrans" +
" WHERE V.idtransporte = ISNULL(null, V.idtransporte) " +
" AND V.placa LIKE ISNULL('%" + vh._placa + "%', V.placa) " +
" AND V.modelo LIKE ISNULL('%" + vh._modelo + "%', V.modelo) " +
" AND V.linea LIKE ISNULL('%" + vh._linea + "%', V.linea) " +
" AND V.motor LIKE ISNULL('%" + vh._motor + "%', V.motor) " +
" AND V.color LIKE ISNULL('%" + vh._motor + "%', V.color) " +
" AND V.marca LIKE ISNULL('%" + vh._marca + "%', V.marca) " +
" AND V.idtipotrans = CASE " + vh._tipovehiculo + " WHEN 0 THEN V.idtipotrans ELSE " + vh._tipovehiculo + " END" +
" AND V.idempresa = " + idempresa);
return(dtRegistros);
}
private void ActualizarForm(int tipo)
{
vehiculo_Entity vc = new vehiculo_Entity();
vc._chasis = txtChasis.Text.Trim();
vc._marca = txtMarca.Text.Trim();
vc._modelo = txtModelo.Text.Trim();
vc._motor = txtMotor.Text.Trim();
vc._placa = txtPlaca.Text.Trim();
if (tipo == 2)
{
vc._tipovehiculo = Convert.ToInt32(cmbTipo.SelectedValue);
}
try
{
grdVehiculos.DataSource = new Vehiculo_BO().verTodosVehiculos(vc);
grdVehiculos.Refresh();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
private void gdvVehiculos(int tipo)
{
vehiculo_Entity vc = new vehiculo_Entity();
//vc._placa = txtPlaca.Text.Trim();
if (tipo == 2)
{
vc._tipovehiculo = Convert.ToInt32(cmbTipoVehiculoB.SelectedValue);
if (txtCodVehiculoB.Text != "")
{
vc._cod_vehiculo = Convert.ToInt32(txtCodVehiculoB.Text.Trim());
}
}
try
{
dgvVehiculos.DataSource = new Vehiculo_BO().verVehiculosDisponibles(vc);
dgvVehiculos.Refresh();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
public void actualizaVehiculoBO(vehiculo_Entity vhc)
{
Vehiculo_DAL actualiza = new Vehiculo_DAL();
actualiza.actualizaVehiculo(vhc);
}
public void insertarVhcBO(vehiculo_Entity vhc)
{
Vehiculo_DAL vhcInsert = new Vehiculo_DAL();
vhcInsert.insertaVehiculo(vhc);
}
