public List<Item> selectAll()
{
using (var db = new CustomDBContext())
{
try
{
List<Item> items = db.Items.Select(item => new Item()
{
ID = item.ID,
name = item.name,
country = item.country,
district = item.district,
year = item.year,
type = item.type,
price = item.price,
description = item.description,
stockCount = item.stockCount,
imgURL = item.imgURL
}).ToList();
return items;
}
catch (Exception e)
{
Debug.Write("Failed to read data. Error: " + e.StackTrace.ToString());
return null;
}
}
}
public int insert(Order order)
{
using(var db = new CustomDBContext())
{
try
{
DBOrder dbOrder = db.Orders.Add(new DBOrder()
{
ID = 0,
customerID = order.customer.ID,
lines = order.lines.Select(line => new DBOrderLine()
{
ID = 0,
itemID = line.item.ID,
quantity = line.quantity,
orderID = 0
}).ToList(),
orderTime = order.orderTime,
sentTime = order.sentTime
});
db.SaveChanges();
return dbOrder.ID;
}
catch (Exception e)
{
Debug.Write("Failed to insert data. Error: " + e.StackTrace.ToString());
return -1;
}
}
}
public bool insert(Item item)
{
using (var db = new CustomDBContext())
{
try
{
db.Items.Add(new DBItem()
{
ID = item.ID,
name = item.name,
country = item.country,
district = item.district,
year = item.year,
type = item.type,
price = item.price,
description = item.description,
stockCount = item.stockCount,
imgURL = item.imgURL
});
db.SaveChanges();
return true;
}
catch (Exception e)
{
Debug.Write("Failed to insert data. Error: " + e.StackTrace.ToString());
return false;
}
}
}
public List<Order> selectAll(string customerEmail)
{
using (var db = new CustomDBContext())
{
try
{
List<Order> orders = db.Orders.Select(order => new Order()
{
ID = order.ID,
customer = new Customer()
{
ID = order.customer.ID,
firstName = order.customer.firstName,
lastName = order.customer.lastName,
email = order.customer.email,
password = order.customer.password,
adress = order.customer.adress,
zipCode = order.customer.zipCode,
area = order.customer.area.area
},
lines = order.lines.Select(line => new OrderLine()
{
ID = line.ID,
item = new Item()
{
ID = line.item.ID,
name = line.item.name,
country = line.item.country,
district = line.item.district,
year = line.item.year,
type = line.item.type,
price = line.item.price,
description = line.item.description,
stockCount = line.item.stockCount,
imgURL = line.item.imgURL
},
quantity = line.quantity
}).ToList(),
orderTime = order.orderTime,
sentTime = order.sentTime
}).Where(order => order.customer.email.Equals(customerEmail)).ToList();
foreach(Order order in orders)
{
order.calculateTotalPrice();
}
return orders;
}
catch(Exception e)
{
Debug.Write("Failed to read data. Error: " + e.StackTrace.ToString());
return null;
}
}
}
public bool delete(int ID)
{
using (var db = new CustomDBContext())
{
try
{
DBItem item = db.Items.Find(ID);
db.Items.Remove(item);
db.SaveChanges();
return true;
}
catch (Exception e)
{
Debug.Write("Failed to delete data. Error: " + e.StackTrace.ToString());
return false;
}
}
}
public Order selectOne(int ID)
{
using (var db = new CustomDBContext())
{
try
{
DBOrder dbOrder = db.Orders.Find(ID);
Order order = new Order()
{
ID = dbOrder.ID,
customer = new Customer()
{
ID = dbOrder.customer.ID,
firstName = dbOrder.customer.firstName,
lastName = dbOrder.customer.lastName,
email = dbOrder.customer.email,
password = dbOrder.customer.password,
adress = dbOrder.customer.adress,
zipCode = dbOrder.customer.zipCode,
area = dbOrder.customer.area.area
},
lines = dbOrder.lines.Select(line => new OrderLine()
{
ID = line.ID,
item = new Item()
{
ID = line.item.ID,
name = line.item.name,
country = line.item.country,
district = line.item.district,
year = line.item.year,
type = line.item.type,
price = line.item.price,
description = line.item.description,
stockCount = line.item.stockCount,
imgURL = line.item.imgURL
},
quantity = line.quantity
}).ToList(),
orderTime = dbOrder.orderTime,
sentTime = dbOrder.sentTime
};
if (order == null)
return null;
order.calculateTotalPrice();
return order;
}
catch (Exception e)
{
Debug.Write("Failed to read data. Error: " + e.StackTrace.ToString());
return null;
}
}
}
public Item selectOne(int ID)
{
using (var db = new CustomDBContext())
{
try
{
DBItem item = db.Items.Find(ID);
return item == null ? null : new Item()
{
ID = item.ID,
name = item.name,
country = item.country,
district = item.district,
year = item.year,
type = item.type,
price = item.price,
description = item.description,
stockCount = item.stockCount,
imgURL = item.imgURL
};
}
catch (Exception e)
{
Debug.Write("Failed to read data. Error: " + e.StackTrace.ToString());
return null;
}
}
}
public bool update(int ID, Item item)
{
using (var db = new CustomDBContext())
{
try
{
DBItem itemInDB = db.Items.Find(ID);
if (itemInDB == null)
return false;
itemInDB.name = item.name;
itemInDB.country = item.country;
itemInDB.district = item.district;
itemInDB.year = item.year;
itemInDB.type = item.type;
itemInDB.price = item.price;
itemInDB.description = item.description;
itemInDB.stockCount = item.stockCount;
itemInDB.imgURL = item.imgURL;
db.SaveChanges();
return true;
}
catch (Exception e)
{
Debug.Write("Failed to update data. Error: " + e.StackTrace.ToString());
return false;
}
}
}