public static int Create(Group group)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
if (context.Groups.FirstOrDefault(g => g.Name == group.Name) == null)
{
context.Groups.Add(group);
context.SaveChanges();
var UserSearch = context.Users.Include("Group").First(u => u.Id == group.UserOwnerId);
var GroupSearch = context.Groups.Include("Users").First(g => g.Id == group.Id);
UserSearch.Group.Add(GroupSearch);
return(context.SaveChanges());
}
else
{
return(-1);
}
}
}
catch (Exception)
{
return(-1);
}
}
public static User Create(User user)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
// check user already exist
user.Group = null;
user.Likes = null;
user.Posts = null;
if (context.Users.Where(s => s.Email == user.Email).FirstOrDefault() == null)
{
// create user
context.Users.Add(user);
// assign group to user
string email = user.Email;
string[] split = email.Split('@');
string nomDomaine = split[1].ToString();
split = nomDomaine.Split('.');
string nomGroupe = split[0].ToString();
// check group already exist
Group existGroup = context.Groups.Where(s => s.Name == nomGroupe).FirstOrDefault();
if (existGroup == null)
{
Group groupForUser = new Group();
groupForUser.Name = nomGroupe;
groupForUser.UserOwnerId = user.Id;
context.Groups.Add(groupForUser);
context.SaveChanges();
User_Repo.AddUserToGroup(user.Id, groupForUser.Id);
}
else
{
context.SaveChanges();
User_Repo.AddUserToGroup(user.Id, existGroup.Id);
}
context.SaveChanges();
return(user);
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
public static int Delete(int id)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
Post Delete = context.Posts.Include("Likes").First(s => s.Id == id);
//Delete picture
if (Delete.Picture != null)
{
try
{
System.IO.File.Delete(Delete.Picture);
}
catch (System.IO.IOException e)
{
Console.WriteLine(e.Message);
}
}
context.Posts.Remove(Delete);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int Create(Like like)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
context.Likes.Add(like);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int Create(Comment comment)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
context.Comments.Add(comment);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int Delete(int id)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
Like delete = context.Likes.Find(id);
context.Likes.Remove(delete);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int AddPictureToAPost(Post post, String pathPicture)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
Post postEdit = context.Posts.Find(post.Id);
postEdit.Picture = pathPicture;
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int RemoveFollow(int idUser, int IdUserDestinataire)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
User userDestinataire = context.Users.Include("Users").Where(s => s.Id == IdUserDestinataire).First();
User user = context.Users.Include("Follow").Where(s => s.Id == idUser).First();
user.Follow.Remove(userDestinataire);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static int RemoveUserFromGroup(int idUser, int idGroup)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
User userSearch = context.Users.Include("Group").First(s => s.Id == idUser);
Group groupSearch = context.Groups.Include("Users").First(s => s.Id == idGroup);
userSearch.Group.Remove(groupSearch);
return(context.SaveChanges());
}
}
catch (Exception)
{
return(-1);
}
}
public static Post Create(Post post, int idUser, int idGroup)
{
try
{
using (ZoombuM1ServiceContext context = new ZoombuM1ServiceContext())
{
User userSearch = context.Users.Include("Group").Single(s => s.Id == idUser);
Group groupSearch = context.Groups.Include("User").Single(s => s.Id == idGroup);
post.Group = groupSearch;
post.User = userSearch;
context.Posts.Add(post);
context.SaveChanges();
return(post);
}
}
catch (Exception)
{
return(null);
}
}