public void Delete(int VentaId)
{
var _db = new FastServiceEntities();
var item = _db.Venta.Where(x => x.VentaId == VentaId).FirstOrDefault();
_db.Venta.Remove(item);
_db.SaveChanges();
}
public NotificacionHelper()
{
_db = new FastServiceEntities();
_configHelper = new GlobalConfigHelper();
year = Convert.ToInt32(_configHelper.GetVal("NotificacionesFechaInicioAno"));
month = Convert.ToInt32(_configHelper.GetVal("NotificacionesFechaInicioMes"));
days = Convert.ToInt32(_configHelper.GetVal("NotificacionesMinimoDiasInactividad"));
}
public ActionResult Delete(int ticketid, int id)
{
var _db = new FastServiceEntities();
var novedad = _db.Novedad.Find(id);
_db.Novedad.Remove(novedad);
_db.SaveChanges();
InitializeViewBag();
return(RedirectToAction("Details", "Ticket", new { id = ticketid }));
}
public void InitializeViewBag()
{
using (var _db = new FastServiceEntities())
{
ViewBag.ListaMarcas = (from y in _db.Marca
where y.nombre.Trim() != string.Empty &&
y.activo
select new SelectListItem()
{
Text = y.nombre,
Value = y.MarcaId.ToString()
}).OrderBy(y => y.Text).ToList();
ViewBag.ListaComercio = (from y in _db.Comercio
where y.Code.Trim() != string.Empty &&
y.activo
select new SelectListItem()
{
Text = y.Code,
Value = y.ComercioId.ToString()
}).OrderBy(y => y.Text).ToList();
ViewBag.ListaTipoDispositivo = (from y in _db.TipoDispositivo
where y.nombre.Trim() != string.Empty &&
y.activo
select new SelectListItem()
{
Text = y.nombre,
Value = y.TipoDispositivoId.ToString()
}).OrderBy(y => y.Text).ToList();
ViewBag.ListaTecnicos = (from u in _db.Usuario
join ur in _db.UsuarioRol on u.UserId equals ur.UserId
where u.Activo && ur.Role.Nombre == "TECNICO"
select new SelectListItem()
{
Text = u.Nombre,
Value = u.UserId.ToString()
}).OrderBy(y => y.Text).ToList();
ViewBag.ListaResponsables = (from y in _db.Usuario
where y.Activo
select new SelectListItem()
{
Text = y.Nombre,
Value = y.UserId.ToString()
}).OrderBy(y => y.Text).ToList();
}
}
public VentaController()
{
_dbContext = new FastServiceEntities();
}
public GlobalConfigHelper()
{
_db = new FastServiceEntities();
}
public StockController()
{
InitializeViewBag();
_db = new FastServiceEntities();
}
public PagoProveedoresController()
{
_dbContext = new FastServiceEntities();
}
public HomeController()
{
_dbContext = new FastServiceEntities();
}
internal void LoadVentas(char mode)
{
var db = new FastServiceEntities();
var ventas = (from x in db.Venta
where x.Fecha.Year == DateTime.Now.Year
select x).ToList();
var VentasSinFacturaChartDataSet = new ChartDataSet("Ventas Sin Factura", Chart.Color1, Chart.Color1, "1");
var VentasConFacturaChartDataSet = new ChartDataSet("Ventas Con Factura", Chart.Color2, Chart.Color3, "2");
if (mode == 'd')
{
TotalVentasConFactura = ventas.Where(x => x.Factura != null && x.Fecha.Date == DateTime.Now.Date).Sum(x => x.Monto);
TotalVentasSinFactura = ventas.Where(x => x.Factura == null && x.Fecha.Date == DateTime.Now.Date).Sum(x => x.Monto);
for (int i = 6; i < 22 + 1; i++)
{
VentasSinFacturaChartDataSet.DataPoints.Add(i.ToString());
VentasConFacturaChartDataSet.DataPoints.Add(i.ToString());
VentasSinFacturaChartDataSet.DataValues.Add(ventas.Where(x =>
x.Factura == null &&
x.Fecha.Date == DateTime.Now.Date &&
x.Fecha.Hour == i).Sum(x => x.Monto));
VentasConFacturaChartDataSet.DataValues.Add(ventas.Where(x =>
x.Factura != null &&
x.Fecha.Date == DateTime.Now.Date &&
x.Fecha.Hour == i).Sum(x => x.Monto));
}
}
if (mode == 'w')
{
TotalVentasConFactura = ventas.Where(x => x.Factura != null && x.Fecha.Date == DateTime.Now.Date).Sum(x => x.Monto);
TotalVentasSinFactura = ventas.Where(x => x.Factura == null && x.Fecha.Date == DateTime.Now.Date).Sum(x => x.Monto);
for (int i = 0; i < 7; i++)
{
VentasSinFacturaChartDataSet.DataPoints.Add(new DateHelper().GetDayName(i));
VentasConFacturaChartDataSet.DataPoints.Add(new DateHelper().GetDayName(i));
VentasSinFacturaChartDataSet.DataValues.Add(ventas.Where(x =>
x.Factura == null &&
x.Fecha > x.Fecha.AddDays(-(int)x.Fecha.DayOfWeek) &&
(int)x.Fecha.DayOfWeek == i).Sum(x => x.Monto));
VentasConFacturaChartDataSet.DataValues.Add(ventas.Where(x =>
x.Factura != null &&
x.Fecha > x.Fecha.AddDays(-(int)x.Fecha.DayOfWeek) &&
(int)x.Fecha.DayOfWeek == i).Sum(x => x.Monto));
}
}
if (mode == 'm')
{
TotalVentasConFactura = ventas.Where(x => x.Factura != null && x.Fecha.Month == DateTime.Now.Month).Sum(x => x.Monto);
TotalVentasSinFactura = ventas.Where(x => x.Factura == null && x.Fecha.Month == DateTime.Now.Month).Sum(x => x.Monto);
for (int i = 1; i < (int)DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + 1; i++)
{
VentasSinFacturaChartDataSet.DataPoints.Add(i.ToString());
VentasConFacturaChartDataSet.DataPoints.Add(i.ToString());
VentasSinFacturaChartDataSet.DataValues.Add(ventas.Where(x => x.Factura == null &&
x.Fecha.Date == new DateTime(DateTime.Now.Year, DateTime.Now.Month, i).Date).Sum(x => x.Monto));
VentasConFacturaChartDataSet.DataValues.Add(ventas.Where(x => x.Factura != null &&
x.Fecha.Date == new DateTime(DateTime.Now.Year, DateTime.Now.Month, i).Date).Sum(x => x.Monto));
}
}
if (mode == 'y')
{
TotalVentasConFactura = ventas.Where(x => x.Factura != null && x.Fecha.Year == DateTime.Now.Year).Sum(x => x.Monto);
TotalVentasSinFactura = ventas.Where(x => x.Factura == null && x.Fecha.Year == DateTime.Now.Year).Sum(x => x.Monto);
for (int i = 1; i < 12 + 1; i++)
{
VentasSinFacturaChartDataSet.DataPoints.Add(new DateHelper().GetMonthName(i));
VentasConFacturaChartDataSet.DataPoints.Add(new DateHelper().GetMonthName(i));
VentasSinFacturaChartDataSet.DataValues.Add(ventas.Where(x => x.Factura == null &&
x.Fecha.Month == new DateTime(DateTime.Now.Year, i, 1).Month).Sum(x => x.Monto));
VentasConFacturaChartDataSet.DataValues.Add(ventas.Where(x => x.Factura != null &&
x.Fecha.Month == new DateTime(DateTime.Now.Year, i, 1).Month).Sum(x => x.Monto));
}
}
Chart.Datasets.Add(VentasConFacturaChartDataSet);
Chart.Datasets.Add(VentasSinFacturaChartDataSet);
}
internal void LoadCompras(char mode)
{
var db = new FastServiceEntities();
var compras = (from x in db.Compra
where x.FechaCreacion.Year == DateTime.Now.Year
select x).ToList();
var ComprasSinFacturaChartDataSet = new ChartDataSet("Compras Sin Factura", Chart.Color3, Chart.Color3, "1");
var ComprasConFacturaChartDataSet = new ChartDataSet("Comrpas Con Factura", Chart.Color4, Chart.Color4, "2");
if (mode == 'd')
{
TotalComprasConFactura = compras.Where(x => x.FechaCreacion.Date == DateTime.Now.Date).Sum(x => x.Monto);
TotalComprasSinFactura = compras.Where(x => x.FechaCreacion.Date == DateTime.Now.Date).Sum(x => x.Monto);
for (int i = 6; i < 22 + 1; i++)
{
ComprasSinFacturaChartDataSet.DataPoints.Add(i.ToString());
ComprasConFacturaChartDataSet.DataPoints.Add(i.ToString());
ComprasSinFacturaChartDataSet.DataValues.Add(compras.Where(x =>
!x.Facturado &&
x.FechaCreacion.Date == DateTime.Now.Date &&
x.FechaCreacion.Hour == i).Sum(x => x.Monto));
ComprasConFacturaChartDataSet.DataValues.Add(compras.Where(x =>
x.Facturado &&
x.FechaCreacion.Date == DateTime.Now.Date &&
x.FechaCreacion.Hour == i).Sum(x => x.Monto));
}
}
if (mode == 'w')
{
TotalComprasConFactura = compras.Where(x => x.FechaCreacion.Date == DateTime.Now.Date).Sum(x => x.Monto);
TotalComprasSinFactura = compras.Where(x => x.FechaCreacion.Date == DateTime.Now.Date).Sum(x => x.Monto);
for (int i = 0; i < 6; i++)
{
ComprasSinFacturaChartDataSet.DataPoints.Add(new DateHelper().GetDayName(i));
ComprasConFacturaChartDataSet.DataPoints.Add(new DateHelper().GetDayName(i));
ComprasSinFacturaChartDataSet.DataValues.Add(compras.Where(x =>
!x.Facturado &&
x.FechaCreacion > x.FechaCreacion.AddDays(-(int)x.FechaCreacion.DayOfWeek) &&
(int)x.FechaCreacion.DayOfWeek == i).Sum(x => x.Monto));
ComprasConFacturaChartDataSet.DataValues.Add(compras.Where(x =>
x.Facturado &&
x.FechaCreacion > x.FechaCreacion.AddDays(-(int)x.FechaCreacion.DayOfWeek) &&
(int)x.FechaCreacion.DayOfWeek == i).Sum(x => x.Monto));
}
}
if (mode == 'm')
{
TotalComprasConFactura = compras.Where(x => x.FechaCreacion.Month == DateTime.Now.Month).Sum(x => x.Monto);
TotalComprasSinFactura = compras.Where(x => x.FechaCreacion.Month == DateTime.Now.Month).Sum(x => x.Monto);
for (int i = 1; i < (int)DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + 1; i++)
{
ComprasSinFacturaChartDataSet.DataPoints.Add(i.ToString());
ComprasConFacturaChartDataSet.DataPoints.Add(i.ToString());
ComprasSinFacturaChartDataSet.DataValues.Add(compras.Where(x => !x.Facturado &&
x.FechaCreacion.Date == new DateTime(DateTime.Now.Year, DateTime.Now.Month, i).Date).Sum(x => x.Monto));
ComprasConFacturaChartDataSet.DataValues.Add(compras.Where(x => x.Facturado &&
x.FechaCreacion.Date == new DateTime(DateTime.Now.Year, DateTime.Now.Month, i).Date).Sum(x => x.Monto));
}
}
if (mode == 'y')
{
TotalComprasConFactura = compras.Where(x => x.FechaCreacion.Year == DateTime.Now.Year).Sum(x => x.Monto);
TotalComprasSinFactura = compras.Where(x => x.FechaCreacion.Year == DateTime.Now.Year).Sum(x => x.Monto);
for (int i = 1; i < 12 + 1; i++)
{
ComprasSinFacturaChartDataSet.DataPoints.Add(new DateHelper().GetMonthName(i));
ComprasConFacturaChartDataSet.DataPoints.Add(new DateHelper().GetMonthName(i));
ComprasSinFacturaChartDataSet.DataValues.Add(compras.Where(x => !x.Facturado &&
x.FechaCreacion.Month == new DateTime(DateTime.Now.Year, i, 1).Month).Sum(x => x.Monto));
ComprasConFacturaChartDataSet.DataValues.Add(compras.Where(x => x.Facturado &&
x.FechaCreacion.Month == new DateTime(DateTime.Now.Year, i, 1).Month).Sum(x => x.Monto));
}
}
Chart.Datasets.Add(ComprasConFacturaChartDataSet);
Chart.Datasets.Add(ComprasSinFacturaChartDataSet);
}
public CompraController()
{
_dbContext = new FastServiceEntities();
}
// GET: Cliente
public ClienteController()
{
this._db = new FastServiceEntities();
}
public LoginController()
{
_dbContext = new FastServiceEntities();
}
public ReparacionController()
{
_db = new FastServiceEntities();
_OrdenHelper = new OrdenHelper();
}
// GET: Cliente
public ProveedorController()
{
this._db = new FastServiceEntities();
}
