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); }