public AccountDetail GetAccountDetail(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
AccountDetail accountDetail = db.AccountDetails.Where(ad => ad.accountDetailID == id).FirstOrDefault();
return(accountDetail);
}
public Order GetOrder(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Order order = db.Orders.Where(o => o.orderID == id).FirstOrDefault();
return(order);
}
public Product GetProduct(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = db.Products.Where(p => p.productID == id).FirstOrDefault();
return(product);
}
public Farm GetFarm(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Farm farm = db.Farms.Where(f => f.farmID == id).FirstOrDefault();
return(farm);
}
public Account GetAccount(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Account account = db.Accounts.Where(a => a.accountID == id).FirstOrDefault();
return(account);
}
public IEnumerable <Product> GetProductsByCategory(string category)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
List <Product> products = db.Products.Where(p => p.productCategory == category).ToList();
return(products);
}
public Address GetAddress(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Address address = db.Addresses.Where(a => a.addressID == id).FirstOrDefault();
return(address);
}
public FarmProduct GetFarmProduct(int id)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
FarmProduct farmProduct = db.FarmProducts.Where(fp => fp.farmProductID == id).FirstOrDefault();
return(farmProduct);
}
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 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 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 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 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 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, int qty)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Order order = new Order();
order.accountID = accountID;
order.farmProductID = farmProductID;
order.qty = qty;
db.Orders.Add(order);
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 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 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);
}
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 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 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();
}
//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 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 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.price = price;
product.productCategory = category;
product.productDescription = description;
product.qty = qty;
db.SaveChanges();
}
}
public void AddProduct(string name, decimal price, string category, string description, int qty)
{
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
Product product = new Product();
product.productName = name;
product.price = price;
product.productCategory = category;
product.productDescription = description;
product.qty = qty;
db.Products.Add(product);
db.SaveChanges();
}
public ActionResult Add(string productName, decimal price, string productCategory, string productDescription, int qty)
{
Product product = new Product();
product.productName = productName;
product.price = price;
product.productCategory = productCategory;
product.productDescription = productDescription;
product.qty = qty;
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
db.Products.Add(product);
db.SaveChanges();
return RedirectToAction("List");
}
public ActionResult Add(string productName, decimal price, string productCategory, string productDescription, int qty)
{
Product product = new Product();
product.productName = productName;
product.price = price;
product.productCategory = productCategory;
product.productDescription = productDescription;
product.qty = qty;
FarmSaleDBEntities1 db = new FarmSaleDBEntities1();
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("List"));
}
//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 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.price,
ProductCategory = p.productCategory,
Description = p.productDescription,
Qty = (int)p.qty,
FarmName = f.farmName
};
return(products);
}