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