public async Task <IActionResult> Put(Guid VehiculoId, [FromBody] TVehiculo vehiculo)
{
vehiculo.VehiculoId = VehiculoId;
await repositorio.SaveVehiculo(vehiculo);
return(Ok(true));
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
TVehiculo tVehiculo = await db.TVehiculo.FindAsync(id);
db.TVehiculo.Remove(tVehiculo);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void DeleteVehiculo(Guid VehiculoId)
{
TVehiculo dbEntry = context.TVehiculo
.FirstOrDefault(p => p.VehiculoId == VehiculoId);
if (dbEntry != null)
{
context.TVehiculo.Remove(dbEntry);
context.SaveChanges();
}
}
// GET: Vehiculos/Details/5
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TVehiculo tVehiculo = await db.TVehiculo.FindAsync(id);
if (tVehiculo == null)
{
return(HttpNotFound());
}
return(View(tVehiculo));
}
public static void Invoke_UpdateVehiculo(RemObjects.SDK.IROService @__Instance, RemObjects.SDK.IMessage @__Message, RemObjects.SDK.Server.IServerChannelInfo @__ServerChannelInfo, out RemObjects.SDK.Server.ResponseOptions @__oResponseOptions)
{
RemObjects.SDK.ObjectDisposer @__ObjectDisposer = new RemObjects.SDK.ObjectDisposer(1);
try {
TVehiculo Datos = ((TVehiculo)(@__Message.Read("Datos", typeof(TVehiculo), RemObjects.SDK.StreamingFormat.Default)));
@__ObjectDisposer.Add(Datos);
bool Result;
Result = ((IRPDataService)(@__Instance)).UpdateVehiculo(Datos);
@__Message.InitializeResponseMessage(@__ServerChannelInfo, "RPSuiteServer", "RPDataService", "UpdateVehiculoResponse");
@__Message.WriteBoolean("Result", Result);
@__Message.FinalizeMessage();
@__oResponseOptions = RemObjects.SDK.Server.ResponseOptions.roDefault;
}
finally {
@__ObjectDisposer.Dispose();
}
}
public static string leer(string ID) // Metodo que lee tabla horarioHorario
{
RPSuiteServer.TVehiculo vehiculo = new TVehiculo();
var definicion = new
{ Dia = "", Valor = "" };
var listaDefinicion = new[] { definicion };
var horarios = ID;
var listHorarios = JsonConvert.DeserializeAnonymousType(horarios, listaDefinicion);
foreach (var hor in listHorarios)
{
switch (hor.Dia)
{
case "Lunes":
vehiculo.Lunes = hor.Valor;
break;
case "Martes":
vehiculo.Martes = hor.Valor;
break;
case "Miércoles":
vehiculo.Miercoles = hor.Valor;
break;
case "Jueves":
vehiculo.Jueves = hor.Valor;
break;
case "Viernes":
vehiculo.Viernes = hor.Valor;
break;
case "Sábado":
vehiculo.Sabado = hor.Valor;
break;
case "Domingo":
vehiculo.Domingo = hor.Valor;
break;
}
}
return("");
}
public async Task <ActionResult> Edit([Bind(Include = "Placa,IdMarca,Anio,Estilo,IdTransmision,Modelo,NumPuertas,IdTipoVehiculo,Valor,IdTipoArticulo,IdEstado,Monto,FechaIngreso,IdCliente")] TVehiculo tVehiculo)
{
if (ModelState.IsValid)
{
db.Entry(tVehiculo).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.IdEstado = new SelectList(db.CEstadoArticulo, "IdEstado", "Descripcion", tVehiculo.IdEstado);
ViewBag.IdMarca = new SelectList(db.CMarcaVehiculo, "IdMarca", "Descripcion", tVehiculo.IdMarca);
ViewBag.IdTipoArticulo = new SelectList(db.CTipoArticulo, "IdTipoArticulo", "Descripcion", tVehiculo.IdTipoArticulo);
ViewBag.IdTipoVehiculo = new SelectList(db.CTipoVehiculo, "IdTipo", "Descripcion", tVehiculo.IdTipoVehiculo);
ViewBag.IdTransmision = new SelectList(db.CTransmision, "IdTransmision", "Descripcion", tVehiculo.IdTransmision);
//ViewBag.IdCliente = new SelectList(db.TCliente, "IdCliente", "Identificacion", tVehiculo.IdCliente);
CargarComboClientes(tVehiculo.IdCliente);
return(View(tVehiculo));
}
// GET: Vehiculos/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TVehiculo tVehiculo = await db.TVehiculo.FindAsync(id);
if (tVehiculo == null)
{
return(HttpNotFound());
}
ViewBag.IdEstado = new SelectList(db.CEstadoArticulo, "IdEstado", "Descripcion", tVehiculo.IdEstado);
ViewBag.IdMarca = new SelectList(db.CMarcaVehiculo, "IdMarca", "Descripcion", tVehiculo.IdMarca);
ViewBag.IdTipoArticulo = new SelectList(db.CTipoArticulo, "IdTipoArticulo", "Descripcion", tVehiculo.IdTipoArticulo);
ViewBag.IdTipoVehiculo = new SelectList(db.CTipoVehiculo, "IdTipo", "Descripcion", tVehiculo.IdTipoVehiculo);
ViewBag.IdTransmision = new SelectList(db.CTransmision, "IdTransmision", "Descripcion", tVehiculo.IdTransmision);
//ViewBag.IdCliente = new SelectList(db.TCliente, "IdCliente", "Identificacion", tVehiculo.IdCliente);
CargarComboClientes(tVehiculo.IdCliente);
return(View(tVehiculo));
}
public TVehiculo[] GetVehiculoTransportista(string Datos)
{
try
{
List <TVehiculo> est = new List <TVehiculo>();
TVehiculo[] vehiculo = new TVehiculo[100];
IDbCommand command;
using (IDbCommand lcommand = this.ServiceSchema.NewCommand(this.Connection, "cmdBuscarVehiculoTransportista", new string[] { "Datos" }, new object[] { Datos }))
{
IDataReader reader = lcommand.ExecuteReader();
while (reader.Read())
{
est.Add
(new TVehiculo()
{
VehiculoID = (int)(reader["VehiculoID"] != DBNull.Value ? reader["VehiculoID"] : null),
NoEconomico = (string)(reader["NoEconomico"] != DBNull.Value ? reader["NoEconomico"] : ""),
NoSerie = (string)(reader["NoSerie"] != DBNull.Value ? reader["NoSerie"] : ""),
Marca = (string)(reader["Marca"] != DBNull.Value ? reader["Marca"] : ""),
Modelo = (string)(reader["Modelo"] != DBNull.Value ? reader["Modelo"] : ""),
NoToneles = (int)(reader["NoToneles"] != DBNull.Value ? reader["NoToneles"] : null),
Capacidad = (int)(reader["Capacidad"] != DBNull.Value ? reader["Capacidad"] : null),
Placas = (string)(reader["Placas"] != DBNull.Value ? reader["Placas"] : ""),
Certificado = (string)(reader["Certificado"] != DBNull.Value ? reader["Certificado"] : ""),
FechaCertificado = (DateTime)(reader["FechaCertificado"] != DBNull.Value ? reader["FechaCertificado"] : DateTime.MinValue),
TransportistaID = (int)(reader["TransportistaID"] != DBNull.Value ? reader["TransportistaID"] : null)
}
);
}
}
vehiculo = est.ToArray();
return(vehiculo);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task SaveVehiculo(TVehiculo vehiculo)
{
if (vehiculo.VehiculoId == Guid.Empty)
{
vehiculo.VehiculoId = Guid.NewGuid();
context.TVehiculo.Add(vehiculo);
}
else
{
TVehiculo dbEntry = context.TVehiculo
.FirstOrDefault(p => p.VehiculoId == vehiculo.VehiculoId);
if (dbEntry != null)
{
dbEntry.VehiculoColor = vehiculo.VehiculoColor;
dbEntry.VehiculoAnioFabri = vehiculo.VehiculoAnioFabri;
dbEntry.VehiculoPlaca = vehiculo.VehiculoPlaca;
dbEntry.VehiculoNroAsientos = vehiculo.VehiculoNroAsientos;
dbEntry.VehiculoMecanico = vehiculo.VehiculoMecanico;
dbEntry.VehiculoFull = vehiculo.VehiculoMecanico;
dbEntry.MarcaId = vehiculo.MarcaId;
}
}
await context.SaveChangesAsync();
}
public Boolean UpdateVehiculo(TVehiculo Datos)
{
return(true);
}
public async Task <IActionResult> Post([FromBody] TVehiculo vehiculo)
{
await repositorio.SaveVehiculo(vehiculo);
return(Ok(true));
}
