public void CreateUserSimple(string registerUsername, string registerPassword) { using (var db = new myContext()) { db.Users.Add(new User(registerUsername, registerPassword)); db.SaveChanges(); } }
public void DeleteUser(int userId) { using (var db = new myContext()) { db.Users.Remove(db.Users.Find(userId)); db.SaveChanges(); } }
public void DeleteMessage(int messageId) { using (var db = new myContext()) { db.Messages.Remove(db.Messages.Find(messageId)); db.SaveChanges(); } }
// Superadmin public void CreateUserExtended(string username, string password, Role role) { using (var db = new myContext()) { db.Users.Add(new User(username, password, role)); db.SaveChanges(); } }
public void SendMessage(string title, string body, int receiverId) { using (var db = new myContext()) { db.Messages.Add(new Message(title, body, db.Users.Find(userRepository.currentUser.Id), db.Users.Find(receiverId))); db.SaveChanges(); } }
public void UpdateUserRole(int userId, Role role) { using (var db = new myContext()) { var user = db.Users.Find(userId); user.Role = role; db.SaveChanges(); } }
public void UpdateUserPassword(int userId, string password) { using (var db = new myContext()) { var user = db.Users.Find(userId); user.Password = password; db.SaveChanges(); } }
public void UpdateUserUsername(int userId, string username) { using (var db = new myContext()) { var user = db.Users.Find(userId); user.Username = username; db.SaveChanges(); } }
public void EditMessageTitle(int messageId, string title) { using (var db = new myContext()) { var message = db.Messages.Find(messageId); message.Title = title; db.SaveChanges(); } }
public void EditMessageBody(int messageId, string body) { using (var db = new myContext()) { var message = db.Messages.Find(messageId); message.Body = body; db.SaveChanges(); } }
public string ViewMessage(int messageId) { using (var db = new myContext()) { var message = db.Messages.Include("Sender").Include("Receiver").Where(x => x.Id == messageId).SingleOrDefault(); message.Read = true; db.SaveChanges(); return($" {message.Date}\n From : {message.Sender.Username} -> To : {message.Receiver.Username}\n Title : {message.Title}\n Message : {message.Body}"); } }
// SuperAdmin public void ChangeIdOfUserToDelete(int userId) { using (var db = new myContext()) { var deletedUserMessages = db.Messages.Include("Sender").Include("Receiver").Where(x => x.Sender.Id == userId || x.Receiver.Id == userId).ToList(); if (deletedUserMessages.Count != 0) { foreach (Message message in deletedUserMessages) { if (message.Sender.Id == userId) { message.Sender = db.Users.Where(x => x.Username == "DeletedUser").SingleOrDefault(); db.SaveChanges(); } if (message.Receiver.Id == userId) { message.Receiver = db.Users.Where(x => x.Username == "DeletedUser").SingleOrDefault(); db.SaveChanges(); } } } } }