public bool AddFriend(int firstuserId, int secondUserId)
{
using (var db = new groubel_dbEntities1())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var item = db.Friendships.FirstOrDefault(i => i.UserId == firstuserId && i.FriendId == secondUserId);
if (item != null)
{
return(false);
}
db.Friendships.Add(new Friendship
{
UserId = firstuserId,
FriendId = secondUserId,
Date = DateTime.Now,
Status = true
});
db.Friendships.Add(new Friendship
{
UserId = secondUserId,
FriendId = firstuserId,
Date = DateTime.Now,
Status = true
});
db.SaveChanges();
_notificationService.SetApproved(firstuserId, secondUserId);
_notificationService.AddNotification(firstuserId, secondUserId, NotificationTypeEnum.AddEdYouAsFriend, 0, "", null);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
return(false);
}
}
}
}
public PostEntity AddPost(PostEntity post, HttpPostedFileBase file)
{
using (var db = new groubel_dbEntities1())
{
var upload = new IOHandler("~/Uploads/PostAttachements/");
var name = upload.Save(file);
using (var transaction = db.Database.BeginTransaction())
{
try
{
var newPost = new Post
{
Attachement = name,
Text = post.Text,
Date = DateTime.Now,
Anonoimus = post.Anonoimus,
Ip = post.Ip,
UserId = post.UserId,
Image = "",
Video = "",
};
db.Posts.Add(newPost);
db.SaveChanges();
var postInterests = _interestService.GetInterestObjectsByName(post.InterestNames, post.UserId);
foreach (var intere in postInterests)
{
db.PostInterests.Add(new PostInterest
{
PostId = newPost.Id,
InterestId = intere.Id
});
_notificationService.AddNotification(post.UserId, 0, NotificationTypeEnum.PostAddedOnInterest, intere.Id, newPost.Ip, newPost.Anonoimus);
}
db.SaveChanges();
transaction.Commit();
return(new PostEntity
{
Id = newPost.Id,
Attachement = newPost.Attachement,
Text = newPost.Text,
Anonoimus = newPost.Anonoimus,
Ip = newPost.Ip,
UserId = newPost.UserId,
PostInterests = postInterests,
PostComments = new List <PostCommentEntity>(),
OldUser = null,
Rate = null,
User = _userService.GetUserById(newPost.UserId, newPost.UserId),
Saved = 0,
Date = DateTime.Now,
CommentsCount = 0,
Reported = false,
PostLikers = GetPostLikers(newPost.Id, newPost.UserId)
});
}
catch (Exception ex)
{
transaction.Rollback();
return(null);
}
}
}
}
public ChatEntity AddRoom(ChatEntity chat, HttpPostedFileBase file)
{
using (var db = new groubel_dbEntities1())
{
// var upload = new IOHandler("~/Uploads/RoomFile/");
// var name = upload.Save(file);
using (var transaction = db.Database.BeginTransaction())
{
try
{
var newChat = new Chat
{
Image = chat.Image,
Anonimus = chat.Anonimus,
IsArchive = false,
IsRoom = chat.IsRoom,
Date = DateTime.Now,
MaxUsers = chat.MaxUsers,
Name = chat.Name,
Visibility = chat.Visibility,
UserId = chat.UserId
};
db.Chats.Add(newChat);
db.SaveChanges();
var roomInterests = _interestService.GetInterestObjectsByName(chat.Interests.Select(i => i.Name).ToList(), chat.UserId);
foreach (var intere in roomInterests)
{
db.ChatInterests.Add(new ChatInterest
{
ChatId = newChat.Id,
InterestId = intere.Id
});
}
db.SaveChanges();
db.ChatMembers.Add(new ChatMember
{
UserId = chat.UserId,
RoomId = newChat.Id,
Date = DateTime.Now,
Agree = true,
SenderId = chat.UserId,
Status = 1,
Avatar = "",
});
foreach (var us in chat.Members)
{
db.ChatMembers.Add(new ChatMember
{
UserId = us.Id,
RoomId = newChat.Id,
Date = DateTime.Now,
Agree = true,
SenderId = chat.UserId,
Status = 1,
Avatar = "",
});
}
db.SaveChanges();
_notificationService.AddNotification(chat.UserId, 0, NotificationTypeEnum.AddedYouInRoom, newChat.Id, "", null);
transaction.Commit();
chat.Id = newChat.Id;
chat.Interests = roomInterests;
chat.Members = GetChatMembers(chat.Id, chat.UserId);
chat.Comments = new List <ChatCommentEntity>();
return(chat);
}
catch (Exception ex)
{
transaction.Rollback();
return(null);
}
}
}
}