public void AddMessage(MessageModel message, int roomId)
{
using (var context = new ChatAPIContext())
{
Message msg = new Message();
msg.text = message.Message;
msg.MessageTime = message.DateSent;
// msg.To = context.Users.Single(x =>x.UserId==message.To);
ChatRoom room = new ChatRoom();
room = context.ChatRoom.Single(x => x.ChatRoomId == roomId);
room = (from chatroom in context.ChatRoom
.Include(a => a.User1)
.Include(a => a.User2)
where chatroom.ChatRoomId == roomId
select chatroom).First();
if (!(room.User1.UserId == message.From))
{
msg.To = room.User1;
}
else
{
msg.To = room.User2;
}
msg.from = context.Users.Single(x => x.UserId == message.From);
msg.ChatRoom = context.ChatRoom.Single(x => x.ChatRoomId == roomId);
context.Messages.Add(msg);
context.SaveChanges();
}
}
//############################################################################################################################
public void SendRequest(string myEmail, string fEmail)
{
using (var context = new ChatAPIContext())
{
Friend friend = new Friend();
friend.IsFriend = false;
friend.User1 = context.Users.Single(u => u.Email == myEmail);
friend.User2 = context.Users.Single(u => u.Email == fEmail);
context.Friend.Add(friend);
context.SaveChanges();
}
}
//############################################################################################################################
public void AcceptRequest(int myid, string fEmail)
{
using (var context = new ChatAPIContext())
{
var friend = context.Friend.Single(a => a.User2.UserId == myid && a.User1.Email == fEmail);
friend.IsFriend = true;
ChatRoom chatRoom = new ChatRoom();
chatRoom.User2 = context.Users.Single(u => u.UserId == myid);
chatRoom.User1 = context.Users.Single(u => u.Email == fEmail);
context.ChatRoom.Add(chatRoom);
context.SaveChanges();
}
}
public IHttpActionResult Get(int id)
{
using (var context = new ChatAPIContext())
{
var user = (from u in context.Users
where u.UserId == id
select u).SingleOrDefault();
//Delete it from memory
context.Users.Remove(user);
//Save to database
context.SaveChanges();
}
return(Ok());
}
//######### Update Name ###################
public IHttpActionResult Post(int id, string newName)
{
using (var context = new ChatAPIContext())
{
var user = (from u in context.Users
where u.UserId == id
select u).SingleOrDefault();
if (user != null)
{
user.FullName = newName;
context.SaveChanges();
}
}
return(Ok());
}
//#################################### Update Password #########################################################################
public IHttpActionResult Get(string email, string newPassword)
{
try
{
using (var context = new ChatAPIContext())
{
var user = (from u in context.Users
where u.Email == email
select u).SingleOrDefault();
if (user != null)
{
user.Password = newPassword;
context.SaveChanges();
return(Json(true));
}
}
}
catch
{
}
return(Json(false));
}
//############################################################################################################################
public void RejectRequest(int myid, string fEmail)
{
using (var context = new ChatAPIContext())
{
var friend = context.Friend.Single(a =>
(a.User2.UserId == myid && a.User1.Email == fEmail) ||
(a.User1.UserId == myid && a.User2.Email == fEmail));
//try
//{
// var chatroom = context.ChatRoom.Single(a =>
// (a.User2.UserId == myid && a.User1.Email == fEmail) ||
// (a.User1.UserId == myid && a.User2.Email == fEmail));
// context.ChatRoom.Remove(chatroom);
//}
//catch
//{
//}
context.Friend.Remove(friend);
context.SaveChanges();
}
}
public bool AddUser(UserModel model)
{
if (!(ExistingUser(model.Email)))
{
using (var context = new ChatAPIContext())
{
User user = new User()
{
FullName = model.FullName,
Email = model.Email,
Password = model.Password,
Gender = model.Gender,
SecurityQuestion = model.SecurityQuestion,
SecurityAnswer = model.SecurityAnswer,
ProfilePicture = "",
};
context.Users.Add(user);
context.SaveChanges();
return(true);
}
}
return(false);
}
