public bool AuthenticateUser(string email, string password)
{
using (var db = new LeoBayContext())
{
var encryptedPassword = db.Users.Where(u => u.Email == email).Select(u => u.Password).FirstOrDefault();
var decryptedPassword = _encryption.Decrypt(encryptedPassword);
var details =
(from user in db.Users
where user.Email == email
select new
{
user.UserId,
user.FirstName,
user.LastName,
user.Email
}).ToList();
if (details.FirstOrDefault() != null && decryptedPassword == password)
{
int currentUserId = details.FirstOrDefault().UserId;
string currentFirstName = details.FirstOrDefault().FirstName;
string currentLastName = details.FirstOrDefault().LastName;
string currentEmail = details.FirstOrDefault().Email;
SetCurrentUser(currentUserId, currentFirstName, currentLastName, currentEmail);
return(true);
}
return(false);
}
}
//Login
public List <User> GetUser()
{
using (var db = new LeoBayContext())
{
var users = db.Users.ToList();
return(users);
}
}
public List <Order> GetOrder()
{
using (var db = new LeoBayContext())
{
var orders = db.Orders.ToList();
return(orders);
}
}
public List <Product> GetCurrentUserItems()
{
using (var db = new LeoBayContext())
{
var items = db.Products.Where(p => p.SellerId == CurrentUser.Id).ToList();
return(items);
}
}
public void DeleteSoldItem(int currentProductId)
{
using (var db = new LeoBayContext())
{
var products = db.Products.Where(p => p.ProductId == currentProductId).FirstOrDefault();
Console.WriteLine(products);
db.Remove(products);
db.SaveChanges();
}
}
public void ConfirmPayment(int currentProductId)
{
using (var db = new LeoBayContext())
{
var order = db.Orders.Where(o => o.BuyerId == CurrentUser.Id).FirstOrDefault();
order.Sold = "Sold";
db.SaveChanges();
}
DeleteSoldItem(currentProductId);
}
//CRUD Items
public void DeleteItem()
{
using (var db = new LeoBayContext())
{
var items = db.Products.Where(p => p.SellerId == p.User.UserId).ToList();
items.Reverse();
var lastItem = items[0];
db.Products.Remove(lastItem);
db.SaveChanges();
}
}
public void DeleteUser()
{
using (var db = new LeoBayContext())
{
var users = db.Users.ToList();
users.Reverse();
var lastUser = users[0];
db.Users.Remove(lastUser);
db.SaveChanges();
}
}
public string GetCurrentOrder()
{
using (var db = new LeoBayContext())
{
var orders =
(from product in db.Products
join order in db.Orders on product.ProductId equals order.ProductId
select order).FirstOrDefault();
return(orders.Sold.ToString());
}
}
public void ConfirmPayment()
{
CurrentUser.Id = 1;
using (var db = new LeoBayContext())
{
var order = db.Orders.Where(o => o.BuyerId == CurrentUser.Id).FirstOrDefault();
order.Sold = "Sold";
db.SaveChanges();
}
CurrentUser.Id = 0;
}
public void DeleteOrder()
{
using (var db = new LeoBayContext())
{
var orders = db.Orders.ToList();
orders.Reverse();
var lastOrder = orders[0];
db.Orders.Remove(lastOrder);
db.SaveChanges();
}
}
//static void Main(string[] args)
//{
// //Console.WriteLine(GetName());
//}
public void CreateNewUser(string firstName, string lastName, string email, string password)
{
using (var db = new LeoBayContext())
{
string encryptedPassword = _encryption.Encrypt(password);
db.Add(new User {
FirstName = firstName, LastName = lastName, Email = email, Password = encryptedPassword
});
db.SaveChanges();
}
}
//Checkout
public void AddToCart()
{
using (var db = new LeoBayContext())
{
CurrentUser.Id = 1;
db.Add(new Order {
ProductId = 1, BuyerId = CurrentUser.Id, Date = DateTime.Now
});
db.SaveChanges();
CurrentUser.Id = 0;
}
}
public void AddToCart(int productId)
{
using (var db = new LeoBayContext())
{
var user = db.Users.Where(u => u.UserId == CurrentUser.Id).FirstOrDefault();
var order = db.Orders;
db.Add(new Order {
ProductId = productId, BuyerId = CurrentUser.Id, Date = DateTime.Now
});
db.SaveChanges();
}
}
public void AddNewItem(string name, double price, string description, string image)
{
using (var db = new LeoBayContext())
{
var newProduct = db.Users.Where(u => u.UserId == CurrentUser.Id).Include(p => p.Products).FirstOrDefault();
newProduct.Products.Add(
new Product
{
ProductName = name,
Price = price,
Description = description,
ImageData = image,
SellerId = CurrentUser.Id,
Date = DateTime.Now
});
db.SaveChanges();
}
}
public bool AuthenticateUser(string email, string password)
{
using (var db = new LeoBayContext())
{
var encryptedPassword = db.Users.Where(u => u.Email == email).Select(u => u.Password).FirstOrDefault();
var details =
(from user in db.Users
where user.Email == email
select new
{
user.UserId,
user.FirstName,
user.LastName,
user.Email
}).ToList();
if (details.FirstOrDefault() != null && encryptedPassword == password)
{
return(true);
}
return(false);
}
}
