public static void AddNewMember(Member m) { var context = new CommerceDbContext(); context.Members.Add(m); context.SaveChanges(); }
internal static Product GetProductById(int id) { CommerceDbContext context = new CommerceDbContext(); Product p = context.Products.Find(id); return(p); }
public static void DeleteProduct(int id) { var context = new CommerceDbContext(); Product p = context.Products.Find(id); context.Products.Remove(p); context.SaveChanges(); }
public static void Update(Product p) { var context = new CommerceDbContext(); // tells EF this product has only been modified context.Entry(p).State = System.Data.Entity.EntityState.Modified; // send update querty to the database context.SaveChanges(); }
internal static bool UserExists(LoginViewModel login) { var db = new CommerceDbContext(); bool doesExist = (from member in db.Members where member.Username == login.Username && member.Password == login.Password select member).Any(); return(doesExist); }
public static bool IsUserNameTaken(RegistrationViewModel Reg) { // check if username is in use var db = new CommerceDbContext(); bool isNameTaken = (from mem in db.Members where mem.Username == Reg.Username select mem).Count() == 1; return(isNameTaken); }
/// <summary> /// Add product to the database /// </summary> /// <param name="p">Product to be added</param> public static void AddProduct(Product p) { //Create instance of DBContext class var context = new CommerceDbContext(); //Prepare insert statement context.Products.Add(p); //Execute pending insert context.SaveChanges(); }
internal static List <Product> GetProductsByPage(int page, byte pageSize) { CommerceDbContext context = new CommerceDbContext(); List <Product> prodList = context .Products .Take(pageSize) .OrderBy(p => p.Name) .Skip((page - 1) * pageSize) .ToList(); return(prodList); }
/// <summary> /// Gets all products sorted by product name /// </summary> /// <returns></returns> public static List <Product> GetAllProducts() { //LINQ (Language Integrated Query) var db = new CommerceDbContext(); //What we are trying to do //SELECT * FROM Products ORDER BY Name //Method 1: LINQ Query Syntax List <Product> products = (from p in db.Products orderby p.Name select p).ToList(); //Method 2: LINQ Method Syntax List <Product> products2 = db.Products .OrderBy(p => p.Name) .ToList(); return(products); }
public static int GetTotalNumProducts() { var context = new CommerceDbContext(); return(context.Products.Count()); }