public bool DeleteBookIssues(int studentID, int bookNumber)
{
LibraryManagementEntities context = new LibraryManagementEntities();
bool flag = false;
var query = (from data in context.Books
where data.Book_Number == bookNumber
select data).FirstOrDefault();
int quantity = query.Quantity;
query.Quantity = quantity + 1;
var deleteQuery = (from data in context.BookIssues
where data.Student_Number == studentID && data.Book_Number == bookNumber
select data).FirstOrDefault();
context.BookIssues.Remove(deleteQuery);
context.SaveChanges();
flag = true;
return(flag);
}
public List <Book> SearchBooks(string searchData)
{
try
{
LibraryManagementEntities context = new LibraryManagementEntities();
int search = 0;
if (int.TryParse(searchData, out search))
{
;
}
var query = from data in context.Books
where data.Book_Number == search || data.Book_Name.Contains(searchData) ||
data.Publication.Contains(searchData) || data.Author.Contains(searchData)
select data;
return(query.ToList());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool NewBookIssue(BookIssue book)
{
try
{
bool flag = false;
LibraryManagementEntities context = new LibraryManagementEntities();
var query = (from data in context.Books
where data.Book_Number == book.Book_Number
select data).FirstOrDefault();
int quantity = query.Quantity;
query.Quantity = quantity - 1;
context.BookIssues.Add(book);
context.SaveChanges();
flag = true;
return(flag);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
