public async Task <IActionResult> Edit(int id, [Bind("ID,Name,PhoneNumber,EmailAddress")] PhoneBooks phoneBooks)
{
if (id != phoneBooks.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(phoneBooks);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhoneBooksExists(phoneBooks.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(phoneBooks));
}
public async Task <IActionResult> PutPhoneBook([FromRoute] int id, [FromBody] PhoneBooks phoneBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != phoneBook.ID)
{
return(BadRequest());
}
_context.Entry(phoneBook).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhoneBookExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Create([Bind("ID,Name,PhoneNumber,EmailAddress")] PhoneBooks phoneBooks)
{
if (ModelState.IsValid)
{
_context.Add(phoneBooks);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(phoneBooks));
}
public async Task <IActionResult> PostPhoneBook([FromBody] PhoneBooks phoneBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.PhoneBook.Add(phoneBook);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPhoneBook", new { id = phoneBook.ID }, phoneBook));
}
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
});
}
}
public MainWindow(string x, string y)
{
InitializeComponent();
this.Current_Owner.Text = x + " " + y;
ActualOwner.fName = x;
ActualOwner.lName = y;
DataContext = new Start_model();
using (OwnerEntities db = new OwnerEntities())
{
ActualOwner.ID = db.Owners.Where(o => o.fName == x).Where(o => o.lName == y).FirstOrDefault().ID;
if (db.Countries.Count() == 0)
{
foreach (var item in Country.GetValues(typeof(Country)))
{
Countries c = new Countries()
{
Country = item.ToString()
};
db.Countries.Add(c);
}
db.SaveChanges();
} // wypełnienie bazy Krajami z enum
if (db.PhoneBooks.Where(a => a.OwnerID == db.Owners.Where(o => o.fName == ActualOwner.fName).Where(o => o.lName == ActualOwner.lName).FirstOrDefault().ID).Count() == 0)
{
PhoneBooks book = new PhoneBooks()
{
OwnerID = db.Owners.Where(o => o.fName == ActualOwner.fName).Where(o => o.lName == ActualOwner.lName).First().ID
};
db.PhoneBooks.Add(book);
db.SaveChanges();
} //stworzenie książki dla aktualnego usera, jeżeli nie istnieje
}
}