//done
public bool Delete(string email)
{
try
{
using (var context = new OrderManagmentDbContext())
{
var query = context.Set<Customer>().SingleOrDefault(c => c.Email == email);
if (query != null)
{
query.IsActive = false;
context.SaveChanges();
}
else
{
Console.WriteLine("No customer with this email not found");
}
return true;
}
}
catch (Exception e)
{
return false;
}
}
public SearcBasket BasketSearch(int basketId)
{
var tempBasket = new SearcBasket();
try
{
using (var context = new OrderManagmentDbContext())
{
var basketquery = context.Set <Basket>().SingleOrDefault(b => b.BasketId == basketId);
if (basketquery != null)
{
tempBasket.BasketThatWeSearch = basketquery;
tempBasket.QueryResault = true;
return(tempBasket);
}
else
{
tempBasket.BasketThatWeSearch = null;
tempBasket.QueryResault = false;
return(tempBasket);
}
}
}
catch (Exception e)
{
tempBasket.BasketThatWeSearch = null;
tempBasket.QueryResault = false;
return(tempBasket);
}
}
//done
public bool Update(string email, string name, string address, DateTime birthDate, bool status)
{
try
{
using (var context = new OrderManagmentDbContext())
{
var query = context.Set<Customer>().SingleOrDefault(c => c.Email == email);
if (query != null)
{
query.Email = email;
query.Name = name;
query.Address = address;
query.Dob = birthDate;
query.IsActive = status;
context.SaveChanges();
}
return true;
}
}
catch (Exception e)
{
return false;
}
}
//done
public bool Register(string email, string name, string address, DateTime birthDate)
{
using (var context = new OrderManagmentDbContext())
{
var newCustomer = new Customer(email, name, address, true, birthDate);
context.Add(newCustomer);
context.SaveChanges();
return true;
}
}
public bool CreateNewProduct(string name, decimal price, ProductCategoryId categoryid)
{
using (var context = new OrderManagmentDbContext())
{
var newProduct = new Product();
newProduct.Name = name;
newProduct.Price = price;
newProduct.Category = categoryid;
context.Add(newProduct);
context.SaveChanges();
return(true);
}
}
//done
public List<Customer> GetRecentCustomers()
{
using (var context = new OrderManagmentDbContext())
{
var customerList = new List<Customer>();
customerList = context.Set<Customer>()
.Where(t => t.RegisterDay.AddDays(30) >= DateTime.Today)
.Where(t => t.IsActive == true)
.ToList();
//this return all the customer that have been registered the last month
return customerList;
}
}
//done
public bool DeleteBasket(string email, int basketId)
{
try
{
using (var context = new OrderManagmentDbContext())
{
var query = context.Set<Customer>().SingleOrDefault(c => c.Email == email);
if (query != null)
{
//var basketquery = context.Set<Basket>().SingleOrDefault(b => b.BasketId == basket.BasketId);
var basketRemover = context.Set<Basket>().SingleOrDefault(b => b.BasketId == basketId);
basketRemover.CustomerBelong = null;
context.Remove(basketRemover);
context.SaveChanges();
}
return true;
}
}
catch (Exception e)
{
return false;
}
}
//done
public bool AddBasket(string email, Basket basket)
{
try
{
using (var context = new OrderManagmentDbContext())
{
var query = context.Set<Customer>().SingleOrDefault(c => c.Email == email);
var basketquery = context.Set<Basket>().SingleOrDefault(b => b.BasketId == basket.BasketId);
if (query != null && basketquery != null)
{
basketquery.CustomerBelong = email;
context.SaveChanges();
}
return true;
}
}
catch (Exception e)
{
return false;
}
}
