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 DataModels.Ventas CrearVistaVenta(int idDueno, int idVehiculo)
{
DataModels.Ventas venta = new DataModels.Ventas();
venta.Patente = ObtenerPatente(idVehiculo);
venta.FechaVenta = DateTime.Now;
venta.TotalBruto = ValorBruto(idVehiculo);
venta.IVA = ValorIva(venta);
venta.TotalVenta = venta.IVA + venta.TotalBruto;
venta.RUTDueno = ObtenerRutDueno(idDueno);
return(venta);
}
public ActionResult DetalleVenta(Models.VehiculosDuenos model)
{
DataModels.ManagerVenta man = new DataModels.ManagerVenta();
DataModels.Ventas venta = man.CrearVistaVenta(model.IdDueno, model.IdVehiculo);
if (venta.TotalVenta != 0)
{
return(View(venta));
}
else
{
TempData["MensajeVentaError"] = "Hay Problemas con el servicio inténtelo más tarde";
return(RedirectToAction("Index"));
}
}
private decimal ValorIva(DataModels.Ventas venta)
{
try
{
using (var db = new BDEvaluacionVehiculosEntities())
{
decimal IVA = 0.19m;
decimal ValorBruto = (decimal)venta.TotalBruto;
return(ValorBruto * IVA);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult ConfirmarVenta(DataModels.Ventas model)
{
DataModels.ManagerVenta man = new DataModels.ManagerVenta();
string result = string.Empty;
if (Session["usercode"] != null)
{
string userCode = Session["usercode"].ToString();
result = man.InsertarVenta(model, userCode);
if (!string.IsNullOrEmpty(result))
{
return(View(model));
}
else
{
ModelState.AddModelError(string.Empty, "Hay Problemas");
return(View(model));
}
}
return(View(model));
}
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);
}
}
