public async Task <AUser> GetUserById(long userId) { AUser user = null; try { using (var messDbContext = new MessageDatabaseCont()) { user = (await messDbContext.Users.SingleAsync <User>(u => u.UserId == userId)).ConvertToAUser(); var messages = messDbContext.Messages.Where(m => m.UserId == userId); var aMessages = new List <AMessage>(); foreach (var message in messages) { aMessages.Add(message.ConvertToAMessage()); } user.Messages = aMessages; } } catch (InvalidOperationException) { throw; } return(user); }
public async Task <List <AUser> > GetUsersById(int skip, int numberUsers) { List <AUser> result = new List <AUser>(); try { using (var messDbContext = new MessageDatabaseCont()) { var users = await messDbContext.Users .OrderBy(user => user.UserId) .Skip(skip) .Take(numberUsers).ToListAsync(); foreach (var user in users) { result.Add(user.ConvertToAUser()); } } } catch (NullReferenceException) { throw; } return(result); }
public async Task <List <AMessage> > GetMessagesById(int skip, int numberMessages) { List <AMessage> result = new List <AMessage>(); try { using (var messDbContext = new MessageDatabaseCont()) { var messages = await messDbContext.Messages .OrderBy(message => message.MessageId) .Skip(skip) .Take(numberMessages).ToListAsync(); foreach (var message in messages) { result.Add(message.ConvertToAMessage()); } } } catch (NullReferenceException) { throw; } return(result); }
public async Task <bool> IsUserExist(string email) { bool result; try { using (var messDbContext = new MessageDatabaseCont()) { var user = await messDbContext.Users.SingleAsync(u => u.Email == email); result = true; } } catch (InvalidOperationException) { result = false; } return(result); }
public async Task <long> GetCountMessages() { long result = -1; try { using (var messDbContext = new MessageDatabaseCont()) { result = await messDbContext.Messages.CountAsync(); } } catch (ArgumentNullException) { throw; } catch (Exception e) { MessageBox.Show(e.Message); } return(result); }
public async Task <List <AMessage> > GetMessagesByUser(long userId) { List <AMessage> result = new List <AMessage>(); try { using (var messDbContext = new MessageDatabaseCont()) { var messages = await messDbContext.Messages.Where(m => m.UserId == userId).ToListAsync(); foreach (var message in messages) { result.Add(message.ConvertToAMessage()); } } } catch (NullReferenceException) { throw; } return(result); }
public void AddUser(AUser user) { if (user != null) { User us = new User { Email = user.Email, FirstName = user.FirstName, SecondName = user.SecondName }; try { using (var messDbContext = new MessageDatabaseCont()) { messDbContext.Users.Add(us); } } catch (Exception e) { throw new NotImplementedException(); } } }
public void AddMessage(AMessage mess) { if (mess != null) { Message ms = new Message() { Body = mess.Body, UserId = mess.UserId, Date = mess.Date }; try { using (var messDbContext = new MessageDatabaseCont()) { messDbContext.Messages.Add(ms); } } catch (Exception e) { throw new NotImplementedException(); } } }