public GetPhoneBookResponses GetPhoneBooks()
{
try
{
using (var dbcontext = new PhoneBooksContext())
{
var phonebooks = dbcontext.PhoneBooks.ToList();
GetPhoneBookResponses getPhoneBookResponses = new GetPhoneBookResponses();
getPhoneBookResponses.Books = new List <BookResponses>();
foreach (var book in phonebooks)
{
getPhoneBookResponses.Books.Add(new BookResponses {
ID = book.Id, Name = book.Name
});
}
return(new GetPhoneBookResponses {
Books = getPhoneBookResponses.Books, Success = true, Message = string.Empty
});
}
}
catch (Exception ex)
{
return(new GetPhoneBookResponses {
Books = null, Success = false, Message = ex.Message
});
}
}
private List <EntryResponses> getEntriesByPhoneBookID(int phonebookID)
{
List <EntryResponses> entryResponses = new List <EntryResponses>();
using (var dbcontext = new PhoneBooksContext())
{
var entries = dbcontext.PhoneBookEntries.Where(entry => entry.PhoneBooksId.Equals(phonebookID)).ToList();
foreach (var entry in entries)
{
EntryResponses newEntry = new EntryResponses
{
ID = entry.Id,
Name = entry.Name,
PhoneNumber = entry.PhoneNumber
};
entryResponses.Add(newEntry);
}
return(entryResponses);
}
}
public LoginResponses GetLoginPhoneBooks(GetLoginRequest getLoginRequest)
{
try
{
using (var dbcontext = new PhoneBooksContext())
{
var users = dbcontext.Logins.Where(user => user.Password.Equals(getLoginRequest.Password) &&
user.Username.Equals(getLoginRequest.Username)).FirstOrDefault();
return(new LoginResponses {
Username = users.Username, Success = true, Message = string.Empty
});
}
}
catch (Exception ex)
{
return(new LoginResponses {
Username = string.Empty, Success = false, Message = ex.Message
});
}
}
public PhoneBookResponses GetPhoneEntryByPhoneBookName(GetPhoneBookRequest getPhoneBook)
{
try
{
using (var dbcontext = new PhoneBooksContext())
{
var phonebooks = dbcontext.PhoneBooks.Where(p => p.Name.Equals(getPhoneBook.Name)).FirstOrDefault();
var getEntries = this.getEntriesByPhoneBookID(phonebooks.Id);
return(new PhoneBookResponses {
PhoneBookName = phonebooks.Name, GetEntryResponses = getEntries.ToList(), Success = true, Message = string.Empty
});
}
}
catch (Exception ex)
{
return(new PhoneBookResponses {
PhoneBookName = string.Empty, GetEntryResponses = null, Success = false, Message = ex.Message
});
}
}
public CreatePhoneBookResponses CreatePhoneBooks(CreatePhoneBookRequest createPhoneBookRequest)
{
try
{
using (var dbcontext = new PhoneBooksContext())
{
PhoneBooks addBook = new PhoneBooks {
Name = createPhoneBookRequest.PhoneBookName
};
var checkPhoneBookNameIFExists = dbcontext.PhoneBooks.Where(name => name.Name.Equals(createPhoneBookRequest.PhoneBookName)).SingleOrDefault();
int phonebookID;
if (checkPhoneBookNameIFExists.Id < 0)
{
dbcontext.PhoneBooks.Add(addBook);
dbcontext.SaveChanges();
phonebookID = addBook.Id;
}
else
{
phonebookID = checkPhoneBookNameIFExists.Id;
}
PhoneBookEntry bookEntry = new PhoneBookEntry
{
Name = createPhoneBookRequest.Name,
PhoneBooksId = phonebookID,
PhoneNumber = createPhoneBookRequest.PhoneNumber
};
dbcontext.PhoneBookEntries.Add(bookEntry);
dbcontext.SaveChanges();
return(new CreatePhoneBookResponses {
Success = true, Message = string.Empty
});
}
}
catch (Exception ex)
{
return(new CreatePhoneBookResponses {
Success = false, Message = ex.Message
});
}
}