public string InsertarVenta(DataModels.Ventas venta, string userCode)
{
string logStatus = string.Empty;
string logMessage = string.Empty;
try
{
using (var db = new BDEvaluacionVehiculosEntities())
{
if (venta != null && !string.IsNullOrEmpty(userCode))
{
db.Ventas.Add(venta);
db.SaveChanges();
string service = "Venta Patente: " + venta.Patente.ToString() + " Rut Dueño: " + venta.RUTDueno.ToString() + " Total Venta: " + string.Format("{0:C}", venta.TotalVenta);
bool seEliminoVehiculo = EliminarVehiculoDueno(venta);
if (seEliminoVehiculo)
{
var logged = ws.LoggedPurchase(userCode, service);
logStatus = logged.LogStatus;
logMessage = logged.LogMessage;
}
else
{
return(string.Empty);
}
}
}
return(logStatus + " " + logMessage);
}
catch (Exception)
{
return(string.Empty);
}
}
public bool CrearVehiculo(DataModels.Vehiculo vehiculo)
{
try
{
using (var db = new BDEvaluacionVehiculosEntities())
{
vehiculo.Patente = FormatoPatente(vehiculo.Patente);
if (vehiculo.IdDueno != 0)
{
db.Vehiculo.Add(vehiculo);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public bool EliminarVehiculoDueno(DataModels.Ventas venta)
{
DataModels.Vehiculo vehiculo = new Vehiculo();
try
{
using (var db = new BDEvaluacionVehiculosEntities())
{
var query = (from oVehiculo in db.Vehiculo
join oVenta in db.Ventas
on oVehiculo.Patente equals oVenta.Patente
where oVehiculo.Patente == venta.Patente
select oVehiculo).FirstOrDefault();
vehiculo = query;
db.Vehiculo.Attach(vehiculo);
db.Entry(vehiculo).State = System.Data.EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}