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();
}
}
}
}
}
