public JsonResult GetVehiculo(int idMarca, int idModelo, int Anio)
{
try
{
ENVehiculoCompleto ovehiculo = null;
LNVehiculo olnVehiculo = new LNVehiculo();
ovehiculo = olnVehiculo.GetVehiculo(idMarca, idModelo, Anio);
return(Json(ovehiculo, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
//Agregar vehiculo
public int SaveNewVehiculo_TRANS(ENVehiculoCompleto oVehiculo)
{
DAVehiculo data = new DAVehiculo();
int Resultado = 0;
using (SqlConnection con = new SqlConnection(CadenaConexion))
{
try
{
Resultado = data.SaveNewVehiculo_TRANS(con, oVehiculo);
}
catch (Exception ex)
{
GrabarLog(ex);
}
}
return(Resultado);
}
public ENVehiculoCompleto GetVehiculo(int idMarca, int idModelo, int Anio)
{
ENVehiculoCompleto beVehiculo = null;
using (SqlConnection con = new SqlConnection(CadenaConexion))
{
try
{
con.Open();
DAVehiculo odaVehiculo = new DAVehiculo();
beVehiculo = odaVehiculo.GetVehiculo(con, idMarca, idModelo, Anio);
}
catch (Exception ex)
{
GrabarLog(ex);
}
return(beVehiculo);
}
}
//Actualizacion de Vehiculos
public JsonResult SaveVehiculo(ENVehiculoCompleto oVehiculo)
{
try
{
int intRes = 0;
//GUARDAR VEHICULO
LNVehiculo olnVehiculo = new LNVehiculo();
intRes = olnVehiculo.SaveVehiculo_TRANS(oVehiculo);
if (intRes > 0)
{
return(Json(new { intVehiculo = intRes }));
}
else
{
return(Json(new { success = false }));
}
}
catch (Exception)
{
throw;
}
}
public int SaveNewVehiculo_TRANS(SqlConnection con, ENVehiculoCompleto oVehiculo)
{
using (con)
{
SqlCommand sqlCommand = new SqlCommand("[DBPESPS_Admin_INS_Vehiculos]", con);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter sqlParameter1 = new SqlParameter("@Retorno", SqlDbType.Int);
sqlParameter1.Size = 50;
sqlParameter1.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(sqlParameter1);
SqlParameter sqlParameter2 = new SqlParameter("@idMarca", SqlDbType.Int);
sqlParameter2.Value = oVehiculo.idMarca;
sqlParameter2.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter2);
SqlParameter sqlParameter3 = new SqlParameter("@Marca", SqlDbType.NVarChar);
sqlParameter3.Value = oVehiculo.Marca;
sqlParameter3.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter3);
SqlParameter sqlParameter4 = new SqlParameter("@idModelo", SqlDbType.Int);
sqlParameter4.Value = oVehiculo.idModelo;
sqlParameter4.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter4);
SqlParameter sqlParameter5 = new SqlParameter("@Descripcion_modelo", SqlDbType.NVarChar);
sqlParameter5.Value = oVehiculo.Descripcion_Modelo;
sqlParameter5.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter5);
SqlParameter sqlParameter6 = new SqlParameter("@Carroceria", SqlDbType.Char);
sqlParameter6.Value = oVehiculo.Carroceria;
sqlParameter6.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter6);
SqlParameter sqlParameter7 = new SqlParameter("@Puertas", SqlDbType.Char);
sqlParameter7.Value = oVehiculo.Puertas;
sqlParameter7.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter7);
SqlParameter sqlParameter8 = new SqlParameter("@Asientos", SqlDbType.Char);
sqlParameter8.Value = oVehiculo.Asientos;
sqlParameter8.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter8);
SqlParameter sqlParameter9 = new SqlParameter("@Traccion", SqlDbType.Char);
sqlParameter9.Value = oVehiculo.Traccion;
sqlParameter9.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter9);
SqlParameter sqlParameter10 = new SqlParameter("@Desplazamiento", SqlDbType.NVarChar);
sqlParameter10.Value = oVehiculo.Desplazamiento;
sqlParameter10.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter10);
SqlParameter sqlParameter11 = new SqlParameter("@Potencia", SqlDbType.Char);
sqlParameter11.Value = oVehiculo.Potencia;
sqlParameter11.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter11);
SqlParameter sqlParameter12 = new SqlParameter("@Carburante", SqlDbType.Char);
sqlParameter12.Value = oVehiculo.Carburante;
sqlParameter12.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter12);
SqlParameter sqlParameter13 = new SqlParameter("@VRN", SqlDbType.Decimal);
sqlParameter13.Value = oVehiculo.VRN;
sqlParameter13.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter13);
SqlParameter sqlParameter14 = new SqlParameter("@POSITIVA", SqlDbType.NVarChar);
sqlParameter14.Value = oVehiculo.Clasificacion_LaPositiva;
sqlParameter14.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter14);
SqlParameter sqlParameter15 = new SqlParameter("@MAPFRE", SqlDbType.NVarChar);
sqlParameter15.Value = oVehiculo.Clasificacion_Mapfre;
sqlParameter15.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter15);
SqlParameter sqlParameter16 = new SqlParameter("@PACIFICO", SqlDbType.NVarChar);
sqlParameter16.Value = oVehiculo.Clasificacion_Pacifico;
sqlParameter16.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter16);
SqlParameter sqlParameter17 = new SqlParameter("@RIMAC", SqlDbType.NVarChar);
sqlParameter17.Value = oVehiculo.Clasificacion_Rimac;
sqlParameter17.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter17);
SqlParameter sqlParameter18 = new SqlParameter("@HDI", SqlDbType.NVarChar);
sqlParameter18.Value = oVehiculo.Clasificacion_HDI;
sqlParameter18.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter18);
SqlParameter sqlParameter19 = new SqlParameter("@GPS_HDI", SqlDbType.Char);
sqlParameter19.Value = oVehiculo.GPS_HDI;
sqlParameter19.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter19);
SqlParameter sqlParameter20 = new SqlParameter("@GPS_POSITIVA", SqlDbType.Char);
sqlParameter20.Value = oVehiculo.GPS_LaPositiva;
sqlParameter20.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter20);
SqlParameter sqlParameter21 = new SqlParameter("@GPS_MAPFRE", SqlDbType.Char);
sqlParameter21.Value = oVehiculo.GPS_Mapfre;
sqlParameter21.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter21);
SqlParameter sqlParameter22 = new SqlParameter("@GPS_PACIFICO", SqlDbType.Char);
sqlParameter22.Value = oVehiculo.GPS_Pacifico;
sqlParameter22.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter22);
SqlParameter sqlParameter23 = new SqlParameter("@GPS_RIMAC", SqlDbType.Char);
sqlParameter23.Value = oVehiculo.GPS_Rimac;
sqlParameter23.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter23);
SqlParameter sqlParameter24 = new SqlParameter("@P2017", SqlDbType.Decimal);
sqlParameter24.Value = oVehiculo.P2017;
sqlParameter24.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter24);
SqlParameter sqlParameter25 = new SqlParameter("@P2016", SqlDbType.Decimal);
sqlParameter25.Value = oVehiculo.P2016;
sqlParameter25.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter25);
SqlParameter sqlParameter26 = new SqlParameter("@P2015", SqlDbType.Decimal);
sqlParameter26.Value = oVehiculo.P2015;
sqlParameter26.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter26);
SqlParameter sqlParameter27 = new SqlParameter("@P2014", SqlDbType.Decimal);
sqlParameter27.Value = oVehiculo.P2014;
sqlParameter27.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter27);
SqlParameter sqlParameter28 = new SqlParameter("@P2013", SqlDbType.Decimal);
sqlParameter28.Value = oVehiculo.P2013;
sqlParameter28.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter28);
SqlParameter sqlParameter29 = new SqlParameter("@P2012", SqlDbType.Decimal);
sqlParameter29.Value = oVehiculo.P2012;
sqlParameter29.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter29);
SqlParameter sqlParameter30 = new SqlParameter("@P2011", SqlDbType.Decimal);
sqlParameter30.Value = oVehiculo.P2011;
sqlParameter30.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter30);
SqlParameter sqlParameter31 = new SqlParameter("@P2010", SqlDbType.Decimal);
sqlParameter31.Value = oVehiculo.P2010;
sqlParameter31.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(sqlParameter31);
con.Open();
sqlCommand.ExecuteNonQuery();
con.Close();
return((int)sqlCommand.Parameters["@Retorno"].Value);
}
}
//Actualiza Vehiculo
public int SaveVehiculo_TRANS(SqlConnection con, ENVehiculoCompleto oVehiculo)
{
using (con)
{
SqlCommand cmd = new SqlCommand("[DBPESPS_Admin_UPD_Vehiculos]", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@Retorno", SqlDbType.Int);
parm.Size = 50;
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
SqlParameter parmT = new SqlParameter("@idMarca", SqlDbType.Int);
parmT.Value = oVehiculo.idMarca;
parmT.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parmT);
SqlParameter parm2 = new SqlParameter("@idModelo", SqlDbType.Int);
parm2.Value = oVehiculo.idModelo;
parm2.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter("@Descripcion_modelo", SqlDbType.NVarChar);
parm3.Value = oVehiculo.Descripcion_Modelo;
parm3.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm3);
SqlParameter parm4 = new SqlParameter("@Carroceria", SqlDbType.Char);
parm4.Value = oVehiculo.Carroceria;
parm4.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm4);
SqlParameter parm5 = new SqlParameter("@Puertas", SqlDbType.Char);
parm5.Value = oVehiculo.Puertas;
parm5.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm5);
SqlParameter parm6 = new SqlParameter("@Asientos", SqlDbType.Char);
parm6.Value = oVehiculo.Asientos;
parm6.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm6);
SqlParameter parm7 = new SqlParameter("@Traccion", SqlDbType.Char);
parm7.Value = oVehiculo.Traccion;
parm7.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm7);
SqlParameter parm8 = new SqlParameter("@Desplazamiento", SqlDbType.NVarChar);
parm8.Value = oVehiculo.Desplazamiento;
parm8.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm8);
SqlParameter parm9 = new SqlParameter("@Potencia", SqlDbType.Char);
parm9.Value = oVehiculo.Potencia;
parm9.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm9);
SqlParameter parmC = new SqlParameter("@Carburante", SqlDbType.Char);
parmC.Value = oVehiculo.Carburante;
parmC.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parmC);
SqlParameter parm10 = new SqlParameter("@VRN", SqlDbType.Decimal);
parm10.Value = oVehiculo.VRN;
parm10.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm10);
SqlParameter parm11 = new SqlParameter("@Precio", SqlDbType.Decimal);
parm11.Value = oVehiculo.PrecioAnio;
parm11.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm11);
//CLASIFICACINES GENERALES
SqlParameter parm12 = new SqlParameter("@POSITIVA", SqlDbType.NVarChar);
parm12.Value = oVehiculo.Clasificacion_LaPositiva;
parm12.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm12);
SqlParameter parm13 = new SqlParameter("@MAPFRE", SqlDbType.NVarChar);
parm13.Value = oVehiculo.Clasificacion_Mapfre;
parm13.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm13);
SqlParameter parm14 = new SqlParameter("@PACIFICO", SqlDbType.NVarChar);
parm14.Value = oVehiculo.Clasificacion_Pacifico;
parm14.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm14);
SqlParameter parm15 = new SqlParameter("@RIMAC", SqlDbType.NVarChar);
parm15.Value = oVehiculo.Clasificacion_Rimac;
parm15.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm15);
SqlParameter parm16 = new SqlParameter("@HDI", SqlDbType.NVarChar);
parm16.Value = oVehiculo.Clasificacion_HDI;
parm16.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm16);
//GPS VEHICULAR
SqlParameter parm17 = new SqlParameter("@GPS_HDI", SqlDbType.Char);
parm17.Value = oVehiculo.GPS_HDI;
parm17.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm17);
SqlParameter parm18 = new SqlParameter("@GPS_POSITIVA", SqlDbType.Char);
parm18.Value = oVehiculo.GPS_LaPositiva;
parm18.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm18);
SqlParameter parm19 = new SqlParameter("@GPS_MAPFRE", SqlDbType.Char);
parm19.Value = oVehiculo.GPS_Mapfre;
parm19.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm19);
SqlParameter parm20 = new SqlParameter("@GPS_PACIFICO", SqlDbType.Char);
parm20.Value = oVehiculo.GPS_Pacifico;
parm20.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm20);
SqlParameter parm21 = new SqlParameter("@GPS_RIMAC", SqlDbType.Char);
parm21.Value = oVehiculo.GPS_Rimac;
parm21.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm21);
SqlParameter parm22 = new SqlParameter("@Anio", SqlDbType.NVarChar);
parm22.Value = oVehiculo.Anio;
parm22.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parm22);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
object idVehiculo = cmd.Parameters["@Retorno"].Value;
return((int)(idVehiculo));
}
}
public ENVehiculoCompleto GetVehiculo(SqlConnection con, int idMarca, int idModelo, int Anio)
{
ENVehiculoCompleto obeVehiculo = new ENVehiculoCompleto();
SqlCommand cmd = new SqlCommand("DBPESPS_Admin_GetVehiculo_Editar", con);
cmd.CommandType = CommandType.StoredProcedure;
//ARGUMENTOS DE PROCEDURE
DbParameter param = cmd.CreateParameter();
param.DbType = DbType.Int32;
param.ParameterName = "@idMarca";
param.Value = idMarca;
cmd.Parameters.Add(param);
DbParameter param2 = cmd.CreateParameter();
param2.DbType = DbType.Int32;
param2.ParameterName = "@idModelo";
param2.Value = idModelo;
cmd.Parameters.Add(param2);
DbParameter param3 = cmd.CreateParameter();
param3.DbType = DbType.String;
param3.ParameterName = "@idAno";
param3.Value = Anio.ToString();
cmd.Parameters.Add(param3);
SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult);
if (drd != null)
{
while (drd.Read())
{
if (!drd.IsDBNull(0))
{
obeVehiculo.idMarca = drd.GetInt32(0);
}
;
if (!drd.IsDBNull(1))
{
obeVehiculo.Marca = drd.GetString(1);
}
;
if (!drd.IsDBNull(2))
{
obeVehiculo.idModelo = drd.GetInt32(2);
}
;
if (!drd.IsDBNull(3))
{
obeVehiculo.Descripcion_Modelo = drd.GetString(3);
}
;
if (!drd.IsDBNull(4))
{
obeVehiculo.Carroceria = drd.GetString(4);
}
;
if (!drd.IsDBNull(5))
{
obeVehiculo.Puertas = drd.GetString(5);
}
;
if (!drd.IsDBNull(6))
{
obeVehiculo.Asientos = drd.GetString(6);
}
;
if (!drd.IsDBNull(7))
{
obeVehiculo.Traccion = drd.GetString(7);
}
;
if (!drd.IsDBNull(8))
{
obeVehiculo.Desplazamiento = drd.GetString(8);
}
;
if (!drd.IsDBNull(9))
{
obeVehiculo.Potencia = drd.GetString(9);
}
;
if (!drd.IsDBNull(10))
{
obeVehiculo.Carburante = drd.GetString(10);
}
;
if (!drd.IsDBNull(11))
{
obeVehiculo.VRN = drd.GetDecimal(11);
}
;
if (!drd.IsDBNull(12))
{
obeVehiculo.PrecioAnio = drd.GetDecimal(12);
}
;
if (!drd.IsDBNull(13))
{
obeVehiculo.Clasificacion_LaPositiva = drd.GetString(13);
}
;
if (!drd.IsDBNull(14))
{
obeVehiculo.Clasificacion_Mapfre = drd.GetString(14);
}
;
if (!drd.IsDBNull(15))
{
obeVehiculo.Clasificacion_Pacifico = drd.GetString(15);
}
;
if (!drd.IsDBNull(16))
{
obeVehiculo.Clasificacion_Rimac = drd.GetString(16);
}
;
if (!drd.IsDBNull(17))
{
obeVehiculo.Clasificacion_HDI = drd.GetString(17);
}
;
if (!drd.IsDBNull(18))
{
obeVehiculo.GPS_LaPositiva = drd.GetString(18);
}
;
if (!drd.IsDBNull(19))
{
obeVehiculo.GPS_Mapfre = drd.GetString(19);
}
;
if (!drd.IsDBNull(20))
{
obeVehiculo.GPS_Pacifico = drd.GetString(20);
}
;
if (!drd.IsDBNull(21))
{
obeVehiculo.GPS_Rimac = drd.GetString(21);
}
;
if (!drd.IsDBNull(22))
{
obeVehiculo.GPS_HDI = drd.GetString(22);
}
;
}
drd.Close();
}
return(obeVehiculo);
}
