//Add New User to DB public void UpdateUser(User user) { if (user != null) { using (ChatDbContext context = new ChatDbContext()) { var oldUser = GetUserByName(user.UserName); try { oldUser.Password = user.Password; oldUser.FirstName = user.FirstName; oldUser.LastName = user.LastName; //oldUser.Messages = user.Messages; context.Users.Add(user); context.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } } } else { throw new Exception("The user object is null"); } }
//Add New Message to DB public void AddMessage(Message msg) { if (msg != null) { using (ChatDbContext context = new ChatDbContext()) { var user = GetUserByName(msg.UserName); try { var count = context.Messages.Count(); if (count > 1000) { DeleteAllMessage(); } msg.MessageId = context.Messages.Count(); context.Messages.Add(msg); context.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } } } else { throw new Exception("The message object is null"); } }
//Remove All Message public void DeleteAllMessage() { using (ChatDbContext context = new ChatDbContext()) { try { context.Messages.RemoveRange(context.Messages); context.SaveChanges(); } catch (Exception ex) { throw new Exception("En Error during registration", ex); } } }
//Delete User public void DeleteUser(string userName, string password) { if (!string.IsNullOrEmpty(userName) && !string.IsNullOrEmpty(password)) { User user = GetUser(userName, password); if (user != null) { using (ChatDbContext context = new ChatDbContext()) { try { context.Users.Remove(user); context.SaveChanges(); } catch (Exception ex) { throw new Exception("En Error during removing the user", ex.InnerException); } } } } }
//Add New User to DB public void AddUser(User user) { if (user != null) { using (ChatDbContext context = new ChatDbContext()) { try { user.UserId = context.Users.Count(); context.Users.Add(user); context.SaveChanges(); } catch (Exception ex) { throw new Exception("En Error during registration", ex); } } } else { throw new Exception("The user object is null"); } }