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