public void RemoveOrder(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Order order = db.Orders.Where(o => o.orderID == id).FirstOrDefault();
db.Orders.Remove(order);
db.SaveChanges();
}
public void RemoveAddress(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Address address = db.Addresses.Where(a => a.addressID == id).FirstOrDefault();
db.Addresses.Remove(address);
db.SaveChanges();
}
public void RemoveAccountDetail(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
AccountDetail accountDetail = db.AccountDetails.Where(ad => ad.accountDetailID == id).FirstOrDefault();
db.AccountDetails.Remove(accountDetail);
db.SaveChanges();
}
public void RemoveAccount(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Account account = db.Accounts.Where(a => a.accountID == id).FirstOrDefault();
db.Accounts.Remove(account);
db.SaveChanges();
}
public void RemoveProduct(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = db.Products.Where(p => p.productID == id).FirstOrDefault();
db.Products.Remove(product);
db.SaveChanges();
}
public void RemoveFarm(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = db.Farms.Where(f => f.farmID == id).FirstOrDefault();
db.Farms.Remove(farm);
db.SaveChanges();
}
public void RemoveFarmProduct(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
FarmProduct farmProduct = db.FarmProducts.Where(fp => fp.farmProductID == id).FirstOrDefault();
db.FarmProducts.Remove(farmProduct);
db.SaveChanges();
}
public void AddFarmProduct(int farmID, int productID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
FarmProduct farmProduct = new FarmProduct();
farmProduct.farmID = farmID;
farmProduct.productID = productID;
db.FarmProducts.Add(farmProduct);
db.SaveChanges();
}
public void AddOrder(int accountID, int farmProductID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Order order = new Order();
order.accountID = accountID;
order.farmProductID = farmProductID;
db.Orders.Add(order);
db.SaveChanges();
}
public void UpdateAccount(int id, string email)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Account account = db.Accounts.Where(a => a.accountID == id).FirstOrDefault();
if (account != null)
{
account.email = email;
db.SaveChanges();
}
}
public void AddAccountDetail(int accountID, int farmID, int addressID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
AccountDetail accountDetail = new AccountDetail();
accountDetail.accountID = accountID;
accountDetail.farmID = farmID;
accountDetail.addressID = addressID;
db.AccountDetails.Add(accountDetail);
db.SaveChanges();
}
public void UpdateFarm(int id, string name, string profile)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = db.Farms.Where(f => f.farmID == id).FirstOrDefault();
if (farm != null)
{
farm.farmName = name;
farm.farmProfile = profile;
db.SaveChanges();
}
}
public void AddFarm(string name, string profile)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = new Farm();
farm.farmName = name;
farm.farmProfile = profile;
db.Farms.Add(farm);
db.SaveChanges();
}
public IEnumerable<Product> GetProductsByFarm(int farmID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
List<FarmProduct> farmProducts = db.FarmProducts.Where(fp => fp.farmID == farmID).ToList();
List<Product> products = new List<Product>();
foreach (var farmProduct in farmProducts)
{
products.Add(db.Products.Where(p => p.productID == farmProduct.productID).FirstOrDefault());
}
return products;
}
//Need to add encryption to password
public void AddAccount(string username, string password, string email, string accountType)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Account account = new Account();
account.username = username;
account.email = email;
account.accountType = accountType;
db.Accounts.Add(account);
db.SaveChanges();
}
//Need to add encryption to password
public void AddAccount(string username, string password, string email, string accountType)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Account account = new Account();
account.username = username;
account.password = password;//Add encryption? Do we need this field?
account.email = email;
account.accountType = accountType;
db.Accounts.Add(account);
db.SaveChanges();
}
public void AddAddress(string streetName, string streetNum, string province, string city, string zip)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Address address = new Address();
address.streetName = streetName;
address.streetNum = streetNum;
address.province = province;
address.city = city;
address.zip = zip;
db.Addresses.Add(address);
db.SaveChanges();
}
public void AddProduct(string name, decimal price, string category, string description, int qtyInKG)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = new Product();
product.productName = name;
product.priceInKg = price;
product.productCategory = category;
product.productDescription = description;
product.qtyInKG = qtyInKG;
db.Products.Add(product);
db.SaveChanges();
}
public void UpdateAddress(int id, string streetName, string streetNum, string province, string city, string zip)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Address address = db.Addresses.Where(a => a.addressID == id).FirstOrDefault();
if (address != null)
{
address.streetName = streetName;
address.streetNum = streetNum;
address.province = province;
address.city = city;
address.zip = zip;
db.SaveChanges();
}
}
public void InitializeFarmAccount(string username)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = new Farm()
{
farmName = username,
farmProfile = username + "profile"
};
if (farm != null)
{
db.Farms.Add(farm);
db.SaveChanges();
}
}
//Users
public UserProfileVM GetUserProfile(int accountID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
AccountDetail accountDetail = db.AccountDetails.Where(ad => ad.accountID == accountID).FirstOrDefault();
Account account = db.Accounts.Where(a => a.accountID == accountID).FirstOrDefault();
Address address = db.Addresses.Where(adr => adr.addressID == accountDetail.addressID).FirstOrDefault();
UserProfileVM profile = new UserProfileVM();
profile.Username = account.username;
profile.Email = account.email;
profile.StreetNum = address.streetNum;
profile.StreetName = address.streetName;
profile.Province = address.province;
profile.City = address.city;
profile.Zip = address.zip;
return profile;
}
public IEnumerable<CartItemVM> GetCartItemsByUser(string username)
{
FarmSaleDBEntities1 farmDB = new FarmSaleDBEntities1();
var products = farmDB.Products.AsEnumerable();
ShoppingCartEntities db = new ShoppingCartEntities();
IEnumerable<CartItemVM> cartItems =
from p in products
from pv in db.ProductVisits
where p.productID == pv.productID && pv.username == username
select new CartItemVM()
{
ProductID = p.productID,
Name = p.productName,
Qty = (int)pv.qtyOrdered,
Price = (decimal)p.priceInKg,
CartItemTotal = (decimal)(pv.qtyOrdered * p.priceInKg)
};
return cartItems;
}
public static IEnumerable<ProductVM> GetMyProducts(int farmID)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
IEnumerable<ProductVM> products =
from f in db.Farms
from fp in db.FarmProducts
where farmID == fp.farmID && f.farmID == farmID
from p in db.Products
where p.productID == fp.productID
select new ProductVM()
{
ProductName = p.productName,
Price = (decimal)p.priceInKg,
ProductCategory = p.productCategory,
Description = p.productDescription,
QtyInKG = p.qtyInKG,
FarmName = f.farmName
};
return products;
}
public void UpdateProduct(int id, string name, decimal price, string category, string description, int qty)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = db.Products.Where(p => p.productID == id).FirstOrDefault();
if (product != null)
{
product.productName = name;
product.priceInKg = price;
product.productCategory = category;
product.productDescription = description;
product.qtyInKG = qty;
db.SaveChanges();
}
}
public IEnumerable<Product> GetProductsByCategory(string category)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
List<Product> products = db.Products.Where(p => p.productCategory == category).ToList();
return products;
}
public Product GetProduct(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = db.Products.Where(p => p.productID == id).FirstOrDefault();
return product;
}
public IEnumerable<Product> GetAllProducts()
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
return db.Products.ToList();
}
public Farm GetFarm(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = db.Farms.Where(f => f.farmID == id).FirstOrDefault();
return farm;
}
public IEnumerable<Order> GetAllOrders()
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
return db.Orders.ToList();
}
public Order GetOrder(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Order order = db.Orders.Where(o => o.orderID == id).FirstOrDefault();
return order;
}
