public static void AddUserGroupToDB(UserGroup userGroupToDB)
{
using (var db = new Community_ASPNETContext())
{
db.Add(userGroupToDB);
db.SaveChanges();
}
}
public static void AddGroupToDB(Group groupToDb)
{
using (var db = new Community_ASPNETContext())
{
db.Add(groupToDb);
db.SaveChanges();
}
}
public static bool DeleteUserGroup(UserGroup deletedUserGroup)
{
using (var db = new Community_ASPNETContext())
{
db.Remove(deletedUserGroup);
db.SaveChanges();
return true;
}
}
public static bool UpdateMessage(Message updatedMessage)
{
using (var db = new Community_ASPNETContext())
{
db.Update(updatedMessage);
db.SaveChanges();
return(true);
}
}
public static bool DeleteUser(Community_ASPNETUser deletedUser)
{
using (var db = new Community_ASPNETContext())
{
db.Remove(deletedUser);
db.SaveChanges();
return(true);
}
}
public static bool UpdateUser(Community_ASPNETUser updatedUser)
{
using (var db = new Community_ASPNETContext())
{
db.Update(updatedUser);
db.SaveChanges();
return(true);
}
}
public static bool UpdateGroup(Group updatedGroup)
{
using (var db = new Community_ASPNETContext())
{
db.Update(updatedGroup);
db.SaveChanges();
return(true);
}
}
public static Group GetGroup(int id)
{
using (var db = new Community_ASPNETContext())
{
var group = db.Groups
.Include(g => g.UserGroups)
.ThenInclude(u => u.User)
.First(g => g.Id == id);
return(group);
}
}
public static void AddMessageToDB(IEnumerable <Message> messageToDB)
{
using (var db = new Community_ASPNETContext())
{
foreach (var m in messageToDB)
{
db.Add(m);
}
db.SaveChanges();
}
}
public static Group GetGroup(string name)
{
using (var db = new Community_ASPNETContext())
{
var group = db.Groups
.Include(g => g.UserGroups)
.ThenInclude(u => u.User)
.First(g => g.Name == name);
return(group);
}
}
public static IEnumerable <Message> GetSenderGroupMessages(string userId, int senderId)
{
using (var db = new Community_ASPNETContext())
{
var message = db.Messages
.Include(m => m.Sender)
.Include(m => m.Reciver)
.Include(m => m.Group)
.Where(m => m.ReciverId.Equals(userId) & m.GroupId.Equals(senderId));
return(message.ToArray());
}
}
public static IEnumerable <Message> GetMessages()
{
using (var db = new Community_ASPNETContext())
{
var messages = db.Messages
.Include(m => m.Sender)
.Include(m => m.Reciver)
.Include(m => m.Group)
.OrderBy(m => m.Id);
return(messages.ToArray());
}
}
public static Message GetMessage(int id)
{
using (var db = new Community_ASPNETContext())
{
var message = db.Messages
.Include(m => m.Sender)
.Include(m => m.Reciver)
.Include(m => m.Group)
.First(m => m.Id.Equals(id));
return(message);
}
}
public static IEnumerable <Group> GetGroups()
{
using (var db = new Community_ASPNETContext())
{
var groups = db.Groups
.Include(g => g.UserGroups)
.ThenInclude(u => u.User)
.OrderBy(g => g.Id);
return(groups.ToArray());
}
}
public static Community_ASPNETUser GetUserWithEmail(string email)
{
using (var db = new Community_ASPNETContext())
{
var user = db.Users
.Include(u => u.UserGroups)
.ThenInclude(g => g.Group)
.Include(u => u.LoginLogs)
.First(u => u.Email.Equals(email));
return(user);
}
}
public static IEnumerable <Community_ASPNETUser> GetUsers()
{
using (var db = new Community_ASPNETContext())
{
var users = db.Users
.Include(u => u.UserGroups)
.ThenInclude(g => g.Group)
.Include(u => u.LoginLogs)
.OrderBy(u => u.Id);
return(users.ToArray());
}
}
public static Community_ASPNETUser GetUser(string userId)
{
using (var db = new Community_ASPNETContext())
{
var user = db.Users
.Include(u => u.UserGroups)
.ThenInclude(g => g.Group)
.Include(u => u.LoginLogs)
.Include(u => u.Messages)
.First(u => u.Id.Equals(userId));
return(user);
}
}
public static bool DeleteMessage(Message deletedMessage)
{
using (var db = new Community_ASPNETContext())
{
db.Remove(deletedMessage);
foreach (var u in db.Users)
{
if (u.Id == deletedMessage.ReciverId)
{
db.Remove(deletedMessage);
u.numberOfDeletedMessages++;
db.Update(u);
break;
}
}
db.SaveChanges();
return(true);
}
}
