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(); }