public static void ChangeUsername(User oldU, string newU, string currentU) { using (var db = new PostingContext()) { if (oldU.Username == currentU) { Console.WriteLine("Current User cannot delete himself"); } else { User oldUser = new User(); oldUser = oldUser.PullUser(oldU.Username); User newUser = new User() { Username = newU, Password = oldUser.Password, Role = oldUser.Role }; db.Users.Remove(oldUser); db.Users.Add(newUser); db.SaveChanges(); } } }
//Insert new Super Admin public static void InsertSuperAdmin(SuperAdmin user) { using (var db = new PostingContext()) { db.Users.Add(user); db.SaveChanges(); } }
public static void DeletePost(int id) { using (var db = new PostingContext()){ var post = db.Posts.FirstOrDefault(p => p.Id == id); db.Posts.Remove(post); db.SaveChanges(); } }
//-------------------------------- POSTS ------------------------------------------------------ //Insert new Post public static void NewPost(Post post) { using (var db = new PostingContext()) { db.Posts.Add(post); db.SaveChanges(); } }
//---------------------- Insert new Users about demo objects ------------------------------------------ public static void InsertSimpleUser(SimpleUser user) { using (var db = new PostingContext()) { db.Users.Add(user); db.SaveChanges(); } }
//-------------------------- Users' Roles ----------------------------------------------- public static void ChangeRoles(string username, string Role) { using (var db = new PostingContext()) { var user = db.Users.FirstOrDefault(u => u.Username == username); user.Role = Role; db.SaveChanges(); } }
//-------------------- Insert new Users for App.cs --------------------------------------------- public static void InsertNewSimpleUser(string username, string password) { var user = new SimpleUser { Username = username, Password = password, Role = "SimpleUser" }; using (var db = new PostingContext()) { db.Users.Add(user); db.SaveChanges(); } }
public void InsertNewAdmin(string username, string password) { var user = new SuperAdmin { Username = username, Password = password }; using (var db = new PostingContext()) { db.Users.Add(user); db.SaveChanges(); } }
public static bool EditPost(int id, string message) { bool result = false; result = FindPost(id); if (result) { using (var db = new PostingContext()) { var post = db.Posts.Where(p => p.Id == id).FirstOrDefault(); post.Message = message; post.ConditionEdited = true; db.SaveChanges(); } return(true); } return(false); }
public static void ChangePassword(string name, string pass) { using (var db = new PostingContext()) { if (DBCommands.FindUser(name)) { var user = db.Users.Where(u => u.Username == name).FirstOrDefault(); //DBCommands. user.Password = pass; db.SaveChanges(); } else { Console.WriteLine("Changing password was cancelled.Please try again and use a unique username."); } } }
public static void DeleteUser(string deleteUser, string user) { using (var db = new PostingContext()) { if (DBCommands.FindUser(deleteUser)) { if (deleteUser == user) { Console.WriteLine("The current user cannot be deleted!!"); } else { var duser = db.Users.FirstOrDefault(u => u.Username == deleteUser); db.Users.Remove(duser); db.SaveChanges(); } } else { Console.WriteLine("Changing username was cancelled.Please try again and use a unique username."); } } }