private List <CustomerModel> GetConsumidores() { List <CustomerModel> consumidores = new List <CustomerModel>(); using (efooddatabaseEntities vuelosData = new efooddatabaseEntities()) { consumidores = (from cliente in vuelosData.Customers select new CustomerModel { CustomerID = cliente.CustomerID, CustomerName = cliente.CustomerName, CustomerLastname = cliente.CustomerLastname, Telephone = cliente.Telephone, Address = cliente.Address, Email = cliente.Email, TicketCode = cliente.TicketCode, RoleID = cliente.RoleID, ContrasenaEmail = cliente.ContrasenaEmail, FacebookID = cliente.FacebookID, TwitterID = cliente.TwitterID }).ToList(); } return(consumidores); }
public static List <ProductoModel> ObtenerProductosFiltrados(ProductoModel modelo) { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var logs = from productos in db.Products select new ProductoModel { ProductCode = productos.ProductCode, ProductDescription = productos.ProductDescription, FoodOptionCode = productos.FoodOptionCode, ProductContent = productos.ProductContent, ProductImage = productos.ProductImage }; if (modelo.FoodOptionCode != null) { logs = logs.Where(producto => producto.FoodOptionCode == modelo.FoodOptionCode); } return(logs.ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
public static void AgregarCustomer(CustomerModel newCustomer) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { //Entidades de la base de datos ProjectHelpers.AppData.Customer customer = new ProjectHelpers.AppData.Customer { CustomerID = newCustomer.CustomerID, CustomerName = newCustomer.CustomerName, CustomerLastname = newCustomer.CustomerLastname, Telephone = newCustomer.Telephone, Address = "No indica", Email = newCustomer.Email, ContrasenaEmail = newCustomer.ContrasenaEmail }; db.Customers.Add(customer); db.SaveChanges(); Payment payment = new Payment { CartID = newCustomer.CustomerID, Quantity = 0, Total = 0, Description = "Carrito de " + newCustomer.CustomerName }; db.Payments.Add(payment); db.SaveChanges(); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static void InsertarUsuario(Admin admin) { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { User user = new User { UserID = admin.UserID, Username = admin.Username, Status = true, PasswordHash = admin.PasswordHash, Email = admin.Email, SecurityQuestion = admin.SecurityQuestion, SecurityAnswerHash = admin.SecurityAnswerHash, RoleID = 1 }; db.Users.Add(user); db.SaveChanges(); } } catch (Exception ex) { string error = "Ha ocurrido un error. Detalles: " + ex.Message; } }
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); } } }
public static void AddLogBook(string tipo, string description, int userID) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { //Entidades de la base de datos LogBook log = new LogBook(); //Toda la data de la base de datos, se almacena en la lista numeroConsecutivo var numeroConsecutivo = (from valor in db.LogBooks select valor); //Primary key int code = numeroConsecutivo.Count() + 1; log.LogID = code; log.UserID = userID; log.LogDate = DateTime.Now; log.RegCode = ConsecutivoModel.GetConsecutivo("Bitacoras"); log.LogType = tipo; log.Description = description; log.RegDetails = "N/A"; //log.User = Admin.ObtenerUsuarioUnico(userID); db.LogBooks.Add(log); db.SaveChanges(); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static void AddDB(ConsecutivoModel consecutivoM) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { //Toda la data de la base de datos, se almacena en la lista numeroConsecutivo var numeroConsecutivo = (from valor in db.Consecutives select valor); //Primary key int code = numeroConsecutivo.Count() + 1; //Tabla base de datos Consecutive consecutive = new Consecutive { //Dando valor al objeto ConsecutiveCode = code, Description = consecutivoM.Description, CurrentConsecutive = consecutivoM.CurrentConsecutive, HasPrefix = consecutivoM.HasPrefix, Prefix = consecutivoM.Prefix }; //Se agrega el objeto a la base de datos db.Consecutives.Add(consecutive); //Commit a la base de datos db.SaveChanges(); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static string GetConsecutivo(string descripcionConsecutivo) { try { //Instancia base datos efooddatabaseEntities db = new efooddatabaseEntities(); //Se consulta el currentConsecutive var data = (from valor in db.Consecutives where valor.Description == descripcionConsecutivo select valor).SingleOrDefault(); //Se cambia de formato int n = int.Parse(data.CurrentConsecutive); //Consecutivo string resultado = data.Prefix + n; //--Aumenta consecutivo en la base de datos--// data.CurrentConsecutive = "" + (n + 1); //Actualiza db.SaveChanges(); return(resultado); } catch (Exception e) { ErrorLogModel.AddError(e); return(null); } }
public static void AddProductDB(ProductoModel modelo, int Carrito) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var log = (from valor in db.Payments where valor.CartID == Carrito select valor).SingleOrDefault(); var precio = (from valor in db.PriceTypeToProducts where valor.ProductCode == modelo.ProductCode select valor).SingleOrDefault(); try { //Entidades de la base de datos ProductToCar agregarACarro = new ProductToCar { CartID = Carrito, ProductCode = modelo.ProductCode, Quantity = 1, }; db.ProductToCars.Add(agregarACarro); db.SaveChanges(); log.Quantity = log.Quantity + 1; log.Total = log.Total + precio.Price; db.SaveChanges(); //BitacoraModel.AddLogBook("a", "Anadir", Customer.ObtenerIdCustomer()); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static void AddError(Exception x) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { //Entidades de la base de datos ErrorLog error = new ErrorLog(); //Toda la data de la base de datos, se almacena en la lista de errores var errores = (from valor in db.ErrorLogs select valor); //Primary key int code = errores.Count() + 1; error.LogID = code; error.LogDate = DateTime.Now; error.ErrCode = x.HResult.ToString(); error.Description = "Ha ocurrido un error. Mensaje: " + x.Message + ". StackTrace: " + x.StackTrace + ". InnerException: " + (x.InnerException != null ? x.InnerException.Message : ""); db.ErrorLogs.Add(error); db.SaveChanges(); } catch (Exception ex) { string error = "Ha ocurrido un error. Detalles: " + ex.Message; AddError(ex); } } }
public static void DeleteAllPedido(int Carrito) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { var productToCar = (from productos in db.ProductToCars where productos.CartID == Carrito select productos); var carrito = (from carro in db.Payments where carro.CartID == Carrito select carro).SingleOrDefault(); foreach (var item in productToCar) { db.ProductToCars.Remove(item); } db.SaveChanges(); carrito.Quantity = 0; carrito.Total = 0; db.SaveChanges(); //BitacoraModel.AddLogBook("a", "Anadir", Customer.ObtenerIdCustomer()); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static void DeleteProductDB(ProductoModel modelo, int Carrito) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { var log = (from valor in db.Payments where valor.CartID == Carrito select valor).SingleOrDefault(); var precio = (from valor in db.PriceTypeToProducts where valor.ProductCode == modelo.ProductCode select valor).SingleOrDefault(); var productoAEliminar = (from producto in db.ProductToCars where producto.CartID == Carrito && producto.ProductCode == modelo.ProductCode select producto).SingleOrDefault(); log.Quantity = log.Quantity - productoAEliminar.Quantity; log.Total = log.Total - (precio.Price * productoAEliminar.Quantity); db.SaveChanges(); db.ProductToCars.Remove(productoAEliminar); db.SaveChanges(); //BitacoraModel.AddLogBook("a", "Anadir", Customer.ObtenerIdCustomer()); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
public static List <ConsultaCarrito> CargarCarrito(int idCarrito) { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var log = from carrito in db.Payments join productosEnCarrito in db.ProductToCars on carrito.CartID equals productosEnCarrito.CartID join productos in db.Products on productosEnCarrito.ProductCode equals productos.ProductCode join preciosProducto in db.PriceTypeToProducts on productos.ProductCode equals preciosProducto.ProductCode where carrito.CartID == idCarrito select new ConsultaCarrito { CartID = carrito.CartID, ProductCode = productos.ProductCode, DescriptionCarrito = carrito.Description, ProductDescription = productos.ProductDescription, PrecioUnitario = preciosProducto.Price, Quantity = productosEnCarrito.Quantity, Total = carrito.Total, ProductImage = productos.ProductImage }; return(log.ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
public static List <ErrorLogModel> FiltrarErrores(ErrorLogModel modelo) { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var logs = from valor in db.ErrorLogs select new ErrorLogModel { LogID = valor.LogID, LogDate = valor.LogDate, ErrCode = valor.ErrCode, Description = valor.Description }; 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); } return(logs.ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
private void UpdateTwitter(string email, string codTwitter) { using (efooddatabaseEntities vuelosData = new efooddatabaseEntities()) { var datos = (from valor in vuelosData.Customers where valor.Email == email select valor).SingleOrDefault(); datos.TwitterID = codTwitter; vuelosData.SaveChanges(); } }
public static void EditProductDB(ProductoModel modelo, int Carrito) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { try { var log = (from valor in db.Payments where valor.CartID == Carrito select valor).SingleOrDefault(); var precio = (from valor in db.PriceTypeToProducts where valor.ProductCode == modelo.ProductCode select valor).SingleOrDefault(); var productoAEditar = (from producto in db.ProductToCars where producto.CartID == Carrito && producto.ProductCode == modelo.ProductCode select producto).SingleOrDefault(); int valorACalcular = productoAEditar.Quantity - modelo.cantidad; if (modelo.cantidad == 0) { DeleteProductDB(modelo, Carrito); } else if (valorACalcular < 0) { // Si la resta del valor actual menos la cantidad nueva ingresada da valores negativo, // este significa que esta agregando más productos. log.Quantity = log.Quantity + Math.Abs(valorACalcular); log.Total = log.Total + (precio.Price * Math.Abs(valorACalcular)); db.SaveChanges(); } else if (valorACalcular > 0) { // Si la resta del valor actual menos la cantidad nueva ingresada da valores positivos, // este significa que están eliminando productos. log.Quantity = log.Quantity - Math.Abs(valorACalcular); log.Total = log.Total - (precio.Price * Math.Abs(valorACalcular)); db.SaveChanges(); } if (modelo.cantidad != 0) { productoAEditar.Quantity = modelo.cantidad; db.SaveChanges(); } //BitacoraModel.AddLogBook("a", "Anadir", Customer.ObtenerIdCustomer()); } catch (Exception e) { ErrorLogModel.AddError(e); } } }
private int GetConsecutivo() { //Instancia base datos efooddatabaseEntities db = new efooddatabaseEntities(); //Se consulta el currentConsecutive var data = (from valor in db.Customers orderby valor.CustomerID descending select valor.CustomerID); //Se cambia de formato int n = data.FirstOrDefault(); n += 1; return(n); }
public static List <TarjetaCreditoDebitoModel> ObtenerTarjetas() { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from card in db.Cards select new TarjetaCreditoDebitoModel { CardCode = card.CardCode, CardDescription = card.CardDescription, }).ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
public static List <LineaComidaModel> ObtenerLineasComida() { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from valor in db.FoodOptions select new LineaComidaModel { FoodOptionCode = valor.FoodOptionCode, FoodOptionDescription = valor.FoodOptionDescription, }).ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
public static List <TipoPrecioModelo> ObtenerTerritorio() { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from territorio in db.PriceTypes select new TipoPrecioModelo { PriceTypeCode = territorio.PriceTypeCode, PriceTypeDescription = territorio.PriceTypeDescription, }).ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
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); } }
public static bool ExisteCustomer(CustomerModel modelo) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var log = (from valor in db.Customers where valor.Email == modelo.Email select valor).SingleOrDefault(); if (log != null) { return(true); } else { return(false); } } }
public static List <ErrorLogModel> CargarErrores() { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from valor in db.ErrorLogs select new ErrorLogModel { LogID = valor.LogID, LogDate = valor.LogDate, ErrCode = valor.ErrCode, Description = valor.Description }).ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
public static bool ExisteEnCarrito(ProductoModel modelo, int Carrito) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var log = (from valor in db.ProductToCars where valor.ProductCode == modelo.ProductCode && valor.CartID == Carrito select valor).SingleOrDefault(); if (log != null) { return(true); } else { return(false); } } }
public static List <TiqueteDescuentoModel> ObtenerTiquetesDescuento() { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from tiquetes in db.TicketDiscounts select new TiqueteDescuentoModel { TicketCode = tiquetes.TicketCode, TicketDescription = tiquetes.TicketDescription, TicketDiscountPercentage = tiquetes.TicketDiscountPercentage, RemainingTickets = tiquetes.RemainingTickets }).ToList()); } } catch (Exception x) { ErrorLogModel.AddError(x); return(null); } }
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 List <Admin> ObtenerAdmin() { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from user in db.Users select new Admin { UserID = user.UserID, Username = user.Username, Status = user.Status, PasswordHash = user.PasswordHash, Email = user.Email, SecurityQuestion = user.SecurityQuestion, SecurityAnswerHash = user.SecurityAnswerHash, RoleID = user.RoleID }).ToList()); } }
public static List <CustomerModel> LoginCustomer(string email, string password) { using (efooddatabaseEntities db = new efooddatabaseEntities()) { return((from customer in db.Customers where customer.Email == email && customer.ContrasenaEmail == password select new CustomerModel { Email = customer.Email, ContrasenaEmail = password, CustomerID = customer.CustomerID, CustomerName = customer.CustomerName, CustomerLastname = customer.CustomerLastname }).ToList()); } }