// Creates contact with contact object public void CreateContact(Contact contact) { using (WhatsUpDbContext db = new WhatsUpDbContext()) { db.Contacts.Add(contact); db.SaveChanges(); } }
// Puts message object into the database public void SendMessage(Message message) { using (WhatsUpDbContext db = new WhatsUpDbContext()) { db.Messages.Add(message); db.SaveChanges(); } }
// Retrieves specific account based on phonenumber string public Account GetAccountByPhoneNumber(string phoneNumber) { Account account = new Account(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { account = db.Accounts.Where(x => x.PhoneNumber == phoneNumber).SingleOrDefault(); } return(account); }
// Returns the list of accounts from the database public IEnumerable <Account> GetAllAccounts() { IEnumerable <Account> accounts = new List <Account>(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { accounts = db.Accounts.ToList(); } return(accounts); }
// Gets account based on accountId public Account GetAccount(int accountId) { Account account = new Account(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { account = db.Accounts.Where(x => x.AccountId == accountId).SingleOrDefault(); } return(account); }
public void CreateAcccount(Account account) { account.ContactlistId = CreateContactList().ContactListId; using (WhatsUpDbContext db = new WhatsUpDbContext()) { db.Accounts.Add(account); db.SaveChanges(); } }
// Function that checks given phone number if entry already exists in database public bool AccountExists(Account account) { bool accountExists = false; using (WhatsUpDbContext db = new WhatsUpDbContext()) { accountExists = db.Accounts.Where(x => x.PhoneNumber == account.PhoneNumber).Any(); } return(accountExists); }
// Gets a specific contact based on contactlistId and friendId public Contact GetContact(int contactlistId, int friendId) { Contact contact = new Contact(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { contact = db.Contacts.Where(x => x.ContactListId == contactlistId && x.FriendId == friendId).FirstOrDefault(); } return(contact); }
// Gets list of contacts that match contactlistId public IEnumerable <Contact> GetContactsByContactListId(int contactlistId) { IEnumerable <Contact> contacts = new List <Contact>(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { contacts = db.Contacts.Where(x => x.ContactListId == contactlistId).ToList(); } return(contacts); }
// Gets message list based on chatId public IEnumerable <Message> GetMessages(int chatId) { List <Message> messages = new List <Message>(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { messages = db.Messages.Where(x => x.ChatId == chatId).ToList(); } return(messages); }
// Gets a chat object based on chatId public Chat GetChat(int chatId) { Chat chat = new Chat(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { chat = db.Chats.Where(x => x.ChatId == chatId).FirstOrDefault(); } return(chat); }
// Creates new chat and gives chat object a chatId public Chat CreateChat(Chat chat) { using (WhatsUpDbContext db = new WhatsUpDbContext()) { Chat chatz = new Chat(); chatz = db.Chats.Add(chat); db.SaveChanges(); chat.ChatId = chatz.ChatId; } return(chat); }
// Returns true or false based on database entries, only true if a phone number and password match public bool LogIn(Account account) { bool login = false; using (WhatsUpDbContext db = new WhatsUpDbContext()) { var acc = db.Accounts.SingleOrDefault(x => x.PhoneNumber == account.PhoneNumber); login = acc != null && Argon2.Verify(acc.Password, account.Password); } return(login); }
public ContactList CreateContactList() { ContactList contactList = new ContactList(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { contactList = db.ContactLists.Add(contactList); db.SaveChanges(); } return(contactList); }
// Returns accounts based on contactlistId public IEnumerable <Account> GetAccountsByContactListId(int contactlistId) { List <Account> accounts = new List <Account>(); using (WhatsUpDbContext db = new WhatsUpDbContext()) { IEnumerable <Contact> contacts = contactRep.GetContactsByContactListId(contactlistId); foreach (Contact contact in contacts) { Account account = GetAccount(contact.FriendId); accounts.Add(account); } } return(accounts); }
// Gets chatId based by checking database if entry exists where contactId + accountId match or vice versa public int GetChatId(Chat chat) { int chatId = 0; using (WhatsUpDbContext db = new WhatsUpDbContext()) { if (db.Chats.Where(x => x.AccountId == chat.AccountId && x.ContactId == chat.ContactId).Any()) { chatId = db.Chats.Where(x => x.AccountId == chat.AccountId && x.ContactId == chat.ContactId).FirstOrDefault().ChatId; } else if (db.Chats.Where(x => x.AccountId == chat.ContactId && x.ContactId == chat.AccountId).Any()) { chatId = db.Chats.Where(x => x.AccountId == chat.ContactId && x.ContactId == chat.AccountId).FirstOrDefault().ChatId; } } return(chatId); }