/// <summary> /// Admin-Method, sets bookamount. /// </summary> public bool SetAmount(int adminID, int bookID, int amount) { using (var db = new WScontext()) { var hm = new HelperMethods(); var book = db.Books. FirstOrDefault( b => b.Id == bookID ); if (book != null && hm.AdminCheck(adminID) == true) { book.Amount = amount; db.Books.Update(book); db.SaveChanges(); return(true); } return(false); } }
public int GetAdminID(int userID) { using (var db = new WScontext()) { var hm = new HelperMethods(); var user = db.Users. FirstOrDefault( u => u.Id == userID && u.IsAdmin == true ); if (user != null) { return(user.Id); } else { return(0); } } }
/// <summary> /// Admin-Method, update category. /// </summary> /// <returns> /// True if category is updated, else false. /// </returns> public bool UpdateCategory(int adminID, int categoryID, string name) { using (var db = new WScontext()) { var hm = new HelperMethods(); var category = db.BookCategories. FirstOrDefault( c => c.Id == categoryID ); if (category != null && hm.AdminCheck(adminID)) { category.Name = name; db.BookCategories.Update(category); db.SaveChanges(); return(true); } return(false); } }
public int CheckUser(int userID) { using (var db = new WScontext()) { var hm = new HelperMethods(); var user = db.Users. FirstOrDefault( u => u.Id == userID ); hm.SessionCheck(userID); if (user != null && user.IsActive) { return(user.Id); } else { return(0); } } }
/// <summary> /// Admin-Method, adds category. /// </summary> /// <returns> /// True if category is added, else false. /// </returns> public bool AddCategory(int adminID, string name) { using (var db = new WScontext()) { var hm = new HelperMethods(); var category = db.BookCategories. FirstOrDefault( c => c.Name == name ); if (category == null && hm.AdminCheck(adminID)) { category = new BookCategory { Name = name }; db.BookCategories.Add(category); db.SaveChanges(); return(true); } return(false); } }
/// <summary> /// Admin-Method, list of users. /// </summary> public void ListUsers(int adminID) { using (var db = new WScontext()) { var hm = new HelperMethods(); var users = db.Users.ToArray(); if (users != null && hm.AdminCheck(adminID)) { foreach (var user in users) { if (user.IsAdmin == false) { Console.WriteLine($"{user.Id}. {user.Name}"); } else { Console.WriteLine($"{user.Id}. {user.Name} (Admin)"); } } } } }
/// <summary> /// Method for user to register. /// </summary> /// <returns> /// True if user is added, else false. /// </returns> public bool Register(string name, string password, string passwordVerify) { using (var db = new WScontext()) { var user = db.Users. FirstOrDefault( u => u.Name == name ); if (user == null && passwordVerify == password) { user = new Users { Name = name, Password = password }; db.Users.Add(user); db.SaveChanges(); return(true); } return(false); } }