// Update row public bool Update(Authors author, int oldID) { bool result = false; using (var db = new LibData()) { var selectedAuthor = db.Authors.Find(oldID); selectedAuthor.Name = author.Name; selectedAuthor.Surname = author.Surname; if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Delete row public bool Delete(Authors author) { bool result = false; using (var db = new LibData()) { db.Authors.Attach(author); db.Authors.Remove(author); try { if (db.SaveChanges() != 0) { result = true; } else { result = false; } } catch (Exception exp) { } } if (result == true) { return(true); } return(false); }
// Update row public bool Update(Categories category, int oldID) { bool result = false; using (var db = new LibData()) { var selectedCategory = db.Categories.Find(oldID); selectedCategory.Name = category.Name; if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Update row public bool Update(Books book, int oldID) { bool result = false; using (var db = new LibData()) { var selectedBook = db.Books.Find(oldID); selectedBook.Name = book.Name; selectedBook.CategoryID = book.CategoryID; selectedBook.Count = book.Count; selectedBook.Price = book.Price; if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Update row public bool Update(Clients client, int oldID) { bool result = false; using (var db = new LibData()) { var selectedClient = db.Clients.Find(oldID); selectedClient.Name = client.Name; selectedClient.Surname = client.Surname; if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Update row public bool Update(AuthorsBooks authorBook, int bookId) { bool result = false; using (var db = new LibData()) { var selectedAuthorBook = db.AuthorsBooks.Where(s => s.BookID == bookId).FirstOrDefault(); selectedAuthorBook.AuthorID = authorBook.AuthorID; selectedAuthorBook.BookID = authorBook.BookID; if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Delete multiple rows by bookID public bool DeleteRows(int bookID) { bool result; using (var db = new LibData()) { db.AuthorsBooks.RemoveRange(db.AuthorsBooks.Where(s => s.BookID == bookID)); if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } else { return(false); } }
// insert into row public int Add(Books book) { int lastID; using (var db = new LibData()) { db.Books.Add(book); if (db.SaveChanges() != 0) { lastID = book.id; } else { lastID = -1; } } return(lastID); }
// insert into row public bool Add(Authors author) { bool result = false; using (var db = new LibData()) { db.Authors.Add(author); if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// insert into row public bool Add(Categories category) { bool result = false; using (var db = new LibData()) { db.Categories.Add(category); if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// insert into row public bool Add(Clients client) { bool result = false; using (var db = new LibData()) { db.Clients.Add(client); if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }
// Delete row public bool Delete(Books book) { bool result = false; using (var db = new LibData()) { db.Books.Attach(book); db.Books.Remove(book); if (db.SaveChanges() != 0) { result = true; } else { result = false; } } if (result == true) { return(true); } return(false); }