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