public static GroupsDto AddGroup(AddGroupRequest request)
{
using (familydbEntities1 db = new familydbEntities1())
{
Groups group = db.Groups.Add(Convertion.GroupsConvertion.ConvertAddGroupRequestToUser(request));
db.SaveChanges();
if (group == null)
{
return(null);
}
User user = db.User.FirstOrDefault(x => x.Id == request.UserId);
group.User.Add(user);
db.SaveChanges();
return(Convertion.GroupsConvertion.ConvertToDto(group));
}
}
public static List <ChatMessagesDto> GetMessages(int groupId)
{
using (familydbEntities1 db = new familydbEntities1())
{
// Groups find = new Groups();
var msgIds = (from msg in db.ChatMessages
where msg.GroupId == groupId
select msg.Id).ToList();
var find = db.ChatMessages
.Where(x => msgIds.Contains(x.Id)).ToList();
if (find == null)
{
return(null);
}
return(Convertion.ChatMessagesConvertor.ConvertToDtoList(find));
}
}
public static List <GroupsDto> Get(int userId)
{
using (familydbEntities1 db = new familydbEntities1())
{
// Groups find = new Groups();
var groupIds = (from groups in db.Groups
where groups.User.Any(c => c.Id == userId)
select groups.Id).ToList();
var find = db.Groups.Include("User").Include("Events")
.Where(x => groupIds.Contains(x.Id)).ToList();
if (find == null)
{
return(null);
}
return(Convertion.GroupsConvertion.ConvertToDtoList(find));
}
}
public static UserDto UpdateUser(UpdateUserRequest request)
{
using (familydbEntities1 db = new familydbEntities1())
{
User user = new User();
User find = db.User.ToList().FirstOrDefault(u => u.Id == request.Id);
if (find != null)
{
user = Convertion.UserConvertion.ConvertUpdateUserRequestToUser(request);
db.User.AddOrUpdate(user);
db.SaveChanges();
}
else
{
return(null);
}
return(Convertion.UserConvertion.ConvertToDto(user));
}
}
public static UserDto SignUp(UserRequest request)
{
using (familydbEntities1 db = new familydbEntities1())
{
User user = new User();
User find = db.User.ToList().FirstOrDefault(u => u.Password == request.Password && u.UserName == request.UserName);
if (find == null)
{
user = db.User.Add(Convertion.UserConvertion.ConvertUserRequestToUser(request));
db.SaveChanges();
if (user == null)
{
return(null);
}
}
else
{
return(null);
}
return(Convertion.UserConvertion.ConvertToDto(user));
}
}
public static GroupsDto DeleteGroup(DeleteGroupRequest request)
{
using (familydbEntities1 db = new familydbEntities1())
{
var group = db.Groups.Include(a => a.User).SingleOrDefault(a => a.Id == request.GroupId);
if (group != null)
{
foreach (var user in group.User
.Where(u => u.Groups.Contains(group)).ToList())
{
group.User.Remove(user);
}
db.Groups.Remove(group);
db.SaveChanges();
}
if (group == null)
{
return(null);
}
return(Convertion.GroupsConvertion.ConvertToDto(group));
}
}
