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