// 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);
}
