/////// /// <summary> /// Add Product /// </summary> /// <param name="product">AddProduct</param> public void AddProduct(Product product) { var db = new LLDbContext(); db.Products.Add(product); db.SaveChanges(); }
//Method to add content to the database. public void AddContent(Content contentToBeAdded) { LLDbContext contentDB = new LLDbContext(); contentDB.Content.Add(contentToBeAdded); contentDB.SaveChanges(); }
// Add new Member to database public void AddMember(Member member) { var db = new LLDbContext(); db.Members.Add(member); db.SaveChanges(); }
//Method to retrieve a specific section of content via its ContentID. ContentID may be switched from string to integer later. public Content GetContent(string contentID) { LLDbContext contentDB = new LLDbContext(); Content selectedContent = (from content in contentDB.Content where contentID == content.ContentID select content).FirstOrDefault <Content>(); return(selectedContent); }
/// <summary> /// Delete Product /// </summary> /// <param name="productID">DeleteProduct</param> /// <returns></returns> public Product DeleteProduct(int productID) { var db = new LLDbContext(); Product dbEntry = db.Products.Find(productID); if (dbEntry != null) { db.Products.Remove(dbEntry); db.SaveChanges(); } return dbEntry; }
// Deletes member from database public Member DeleteMember(int memberId) { var db = new LLDbContext(); Member dbEntry = db.Members.Find(memberId); if (dbEntry != null) { db.Members.Remove(dbEntry); db.SaveChanges(); } return(dbEntry); }
/// <summary> /// Delete Product /// </summary> /// <param name="productID">DeleteProduct</param> /// <returns></returns> public Product DeleteProduct(int productID) { var db = new LLDbContext(); Product dbEntry = db.Products.Find(productID); if (dbEntry != null) { db.Products.Remove(dbEntry); db.SaveChanges(); } return(dbEntry); }
//To be used in conjunction with the UpdateSection method of the Content class. //This will take the content object passed in, attempt to find it in the database, and then update the information in the database. public void SaveContent(Content content) { LLDbContext contentDB = new LLDbContext(); //Find the content in the DB: Content contentToUpdate = contentDB.Content.Find(content.ContentID); if (contentToUpdate != null) { //Edit its existing content to reflect the changes. //Take the entry in the database and make it have the new (updated) text from the object passed in as a parameter. contentToUpdate.CurrentText = content.NewText; } contentDB.SaveChanges(); }
// Saves member information to database public void SaveMember(Member member) { var db = new LLDbContext(); if (member.MemberId == 0) { db.Members.Add(member); } else { // If member exists, it updates information Member dbEntry = db.Members.Find(member.MemberId); if (dbEntry != null) { dbEntry.LoginName = member.LoginName; dbEntry.Password = member.Password; dbEntry.FirstName = member.FirstName; dbEntry.LastName = member.LastName; dbEntry.Email = member.Email; } } db.SaveChanges(); }
/// <summary> /// Save Product /// </summary> /// <param name="product">Save Product</param> public void SaveProduct(Product product) { var db = new LLDbContext(); if (product.ProductID == 0) { db.Products.Add(product); } else { Product dbEntry = db.Products.Find(product.ProductID); if (dbEntry != null) { dbEntry.ProductName = product.ProductName; dbEntry.Price = product.Price; dbEntry.Shipping = product.Shipping; dbEntry.Category = product.Category; dbEntry.Description = product.Description; dbEntry.InStock = product.InStock;//May be disabled if not used?! but must be done in all refd } } db.SaveChanges(); }
// Returns a singe member by Login name public Member GetMemberbyLoginName(string loginName) { var db = new LLDbContext(); return(db.Members.First(m => m.LoginName == loginName)); }
public Product GetProductByProductName(string productName) { var db = new LLDbContext(); return(db.Products.First(p => p.ProductName == productName)); }
/// <summary> /// Get Product By ID /// </summary> /// <param name="productID">GetProductByID</param> /// <returns>ProductByID</returns> public Product GetProductByProductID(int productID) { var db = new LLDbContext(); return(db.Products.First(p => p.ProductID == productID)); }
/// <summary> /// Save Product /// </summary> /// <param name="product">Save Product</param> public void SaveProduct(Product product) { var db = new LLDbContext(); if (product.ProductID == 0) { db.Products.Add(product); } else { Product dbEntry = db.Products.Find(product.ProductID); if (dbEntry != null) { dbEntry.ProductName = product.ProductName; dbEntry.Price = product.Price; //dbEntry.Shipping = product.Shipping; dbEntry.Category = product.Category; dbEntry.Description = product.Description; dbEntry.InStock = product.InStock;//May be disabled if not used?! but must be done in all refd } } db.SaveChanges(); }
public Product GetProductByProductName(string productName) { var db = new LLDbContext(); return (db.Products.First(p => p.ProductName == productName)); }
/// <summary> /// Get Product By ID /// </summary> /// <param name="productID">GetProductByID</param> /// <returns>ProductByID</returns> public Product GetProductByProductID(int productID) { var db = new LLDbContext(); return (db.Products.First(p => p.ProductID == productID)); }
/////// /// <summary> /// Add Product /// </summary> /// <param name="product">AddProduct</param> public void AddProduct(Product product) { var db = new LLDbContext(); db.Products.Add(product); db.SaveChanges(); }