Exemple #1
0
        public static void AddDB(ProductoModel modelo, TipoPrecioToProduct modeloTipoPrecio)
        {
            using (efooddatabaseEntities db = new efooddatabaseEntities())
            {
                try
                {
                    string codigoDeProducto = ConsecutivoModel.GetConsecutivo("Productos");
                    //Entidades de la base de datos
                    Product product = new Product
                    {
                        ProductCode        = codigoDeProducto,
                        ProductDescription = modelo.ProductDescription,
                        FoodOptionCode     = modelo.FoodOptionCode,
                        ProductContent     = modelo.ProductContent,
                        ProductImage       = modelo.ProductImage
                    };
                    db.Products.Add(product);
                    db.SaveChanges();

                    PriceTypeToProduct priceToProduct = new PriceTypeToProduct
                    {
                        PriceTypeCode = modeloTipoPrecio.PriceTypeCode,
                        ProductCode   = codigoDeProducto,
                        Price         = modeloTipoPrecio.Price
                    };

                    db.PriceTypeToProducts.Add(priceToProduct);
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
                }
                catch (Exception e) { ErrorLogModel.AddError(e); }
            }
        }
Exemple #2
0
        public static void DeletetDB(LineaComidaModel modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var datos = (from valor in db.FoodOptions
                                 where valor.FoodOptionCode == modelo.FoodOptionCode
                                 select valor).SingleOrDefault();

                    db.FoodOptions.Remove(datos);
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("n", "Borrar", Admin.ObtenerIdUsuario());
                }
            }
            catch (Exception x) { ErrorLogModel.AddError(x); }
        }
        public static void EditDB(TipoPrecioModelo modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var datos = (from valor in db.PriceTypes
                                 where valor.PriceTypeCode == modelo.PriceTypeCode
                                 select valor).SingleOrDefault();

                    datos.PriceTypeDescription = modelo.PriceTypeDescription;
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
                }
            }
            catch (Exception x) { ErrorLogModel.AddError(x); }
        }
Exemple #4
0
 public static void AddDB(LineaComidaModel modelo)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             FoodOption foodOption = new FoodOption
             {
                 FoodOptionCode        = ConsecutivoModel.GetConsecutivo("Líneas de comida"),
                 FoodOptionDescription = modelo.FoodOptionDescription
             };
             db.FoodOptions.Add(foodOption);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
 public static void AddDB(TipoPrecioModelo modelo)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             PriceType priceType = new PriceType
             {
                 PriceTypeCode        = ConsecutivoModel.GetConsecutivo("Precios"),
                 PriceTypeDescription = modelo.PriceTypeDescription
             };
             db.PriceTypes.Add(priceType);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
 public static void AddDB(TarjetaCreditoDebitoModel modelo)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             Card newCard = new Card
             {
                 CardCode        = ConsecutivoModel.GetConsecutivo("Tarjetas"),
                 CardDescription = modelo.CardDescription
             };
             db.Cards.Add(newCard);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
        public static void EditDB(TiqueteDescuentoModel modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var datos = (from valor in db.TicketDiscounts
                                 where valor.TicketCode == modelo.TicketCode
                                 select valor).SingleOrDefault();

                    datos.TicketDescription        = modelo.TicketDescription;
                    datos.TicketDiscountPercentage = modelo.TicketDiscountPercentage;
                    datos.RemainingTickets         = modelo.RemainingTickets;
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
                }
            }
            catch (Exception x) { ErrorLogModel.AddError(x); }
        }
 public static void AddDB(TipoPrecioToProduct model)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             PriceTypeToProduct priceType = new PriceTypeToProduct
             {
                 PriceTypeCode = model.PriceTypeCode,
                 ProductCode   = model.ProductCode,
                 Price         = model.Price
             };
             db.PriceTypeToProducts.Add(priceType);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
Exemple #9
0
        public static void EditDB(ProductoModel modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var datos = (from valor in db.Products
                                 where valor.ProductCode == modelo.ProductCode
                                 select valor).SingleOrDefault();

                    datos.ProductDescription = modelo.ProductDescription;
                    datos.FoodOptionCode     = modelo.FoodOptionCode;
                    datos.ProductContent     = modelo.ProductContent;
                    //datos.ProductImage = null;
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
                }
            }
            catch (Exception x) { ErrorLogModel.AddError(x); }
        }
 public static void AddDB(TiqueteDescuentoModel modelo)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             TicketDiscount newTicketDiscount = new TicketDiscount
             {
                 TicketCode               = ConsecutivoModel.GetConsecutivo("Tiquetes de descuento"),
                 TicketDescription        = modelo.TicketDescription,
                 TicketDiscountPercentage = modelo.TicketDiscountPercentage,
                 RemainingTickets         = modelo.RemainingTickets
             };
             db.TicketDiscounts.Add(newTicketDiscount);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
Exemple #11
0
        public static void EditDB(MediosPagoModel modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var datos = (from valor in db.PaymentProcessors
                                 where valor.PaymentProcessorCode == modelo.PaymentProcessorCode
                                 select valor).SingleOrDefault();

                    datos.PaymentProcessorName        = modelo.PaymentProcessorName;
                    datos.PaymentProcessorDescription = modelo.PaymentProcessorDescription;
                    datos.PaymentProcessorType        = modelo.PaymentProcessorType;
                    datos.PaymentProcessorMethod      = modelo.PaymentProcessorMethod;
                    datos.PaymentProcessorStatus      = false;
                    datos.PaymentProcessorVerify      = false;
                    db.SaveChanges();
                    BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
                }
            }
            catch (Exception x) { ErrorLogModel.AddError(x); }
        }
Exemple #12
0
 public static void AddDB(MediosPagoModel modelo)
 {
     using (efooddatabaseEntities db = new efooddatabaseEntities())
     {
         try
         {   //Entidades de la base de datos
             PaymentProcessor newProcessor = new PaymentProcessor
             {
                 PaymentProcessorCode        = ConsecutivoModel.GetConsecutivo("Medios de pago"),
                 PaymentProcessorName        = modelo.PaymentProcessorName,
                 PaymentProcessorDescription = modelo.PaymentProcessorDescription,
                 PaymentProcessorType        = modelo.PaymentProcessorType,
                 PaymentProcessorMethod      = modelo.PaymentProcessorMethod,
                 PaymentProcessorStatus      = false,
                 PaymentProcessorVerify      = false
             };
             db.PaymentProcessors.Add(newProcessor);
             db.SaveChanges();
             BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
         }
         catch (Exception e) { ErrorLogModel.AddError(e); }
     }
 }
        public static List <BitacoraModel> FiltrarBitacora(BitacoraModel modelo)
        {
            try
            {
                using (efooddatabaseEntities db = new efooddatabaseEntities())
                {
                    var logs = from valor in db.LogBooks

                               select new BitacoraModel
                    {
                        LogID       = valor.LogID,
                        UserID      = valor.UserID,
                        LogDate     = valor.LogDate,
                        RegCode     = valor.RegCode,
                        LogType     = valor.LogType,
                        Description = valor.Description,
                        RegDetails  = valor.RegDetails
                    };

                    if (modelo.EndDate != DateTime.Parse("01/01/0001 12:00:00 a. m."))
                    {
                        logs = logs.Where(valor => valor.LogDate <= modelo.EndDate);
                    }

                    if (modelo.StartDate != DateTime.Parse("01/01/0001 12:00:00 a. m."))
                    {
                        logs = logs.Where(valor => valor.LogDate >= modelo.StartDate);
                    }

                    if (modelo.UserID != 0)
                    {
                        logs = logs.Where(valor => valor.UserID == modelo.UserID);
                    }

                    if (modelo.LogType != null)
                    {
                        logs = logs.Where(valor => valor.LogType == modelo.LogType);
                    }

                    return(logs.ToList());

                    /*return (from valor in db.LogBooks
                     *      where valor.LogDate >= modelo.StartDate &&
                     *      valor.LogDate <= modelo.EndDate &&
                     *      valor.LogType == modelo.LogType &&
                     *      valor.UserID == modelo.UserID
                     *
                     *      select new BitacoraModel
                     *      {
                     *          LogID = valor.LogID,
                     *          UserID = valor.UserID,
                     *          LogDate = valor.LogDate,
                     *          RegCode = valor.RegCode,
                     *          LogType = valor.LogType,
                     *          Description = valor.Description,
                     *          RegDetails = valor.RegDetails
                     *
                     *      }).ToList();*/
                }
            }
            catch (Exception x) {
                ErrorLogModel.AddError(x); return(null);
            }
        }