public static
bool RemoveBook(string BookTitle, int Quantity, string AuthorName,
string CategoryName)
{
bool IsSuccess = false;
try
{
OleDbConnection conn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Documents and Settings\\SOURABH DEY\\My Documents\\Visual
Studio 2008\\Projects\\Library Management System\\Library Management
System\\Library.mdb;");
conn.Open();
OleDbCommand cmd = new OleDbCommand("", conn);
String OleDbCommand = "BEGIN TRANSACTION\r\n";
//
rows are not removed from system but inventory status is set as false
and such records
// are not at all considered in
system for issue etc.
for (int i = 0; i <
Quantity; i++)
{
OleDbCommand
+= "update [Lib_Book_Details] set [Lib_Book_In_Inventory] = 0 where
[Lib_Book_ID] = ";
OleDbCommand += "(select top 1
Lib_Book_ID from [Lib_Book_Details] [a] join [Lib_Book_Categories] [b]
on [b].[Category_ID] = [a].[Lib_Book_Category] where
[a].[Lib_Book_Title] = '" + BookTitle + "' and
[a].[Lib_book_issue_status] = 0 and [a].[Lib_Book_In_Inventory] = 1 ";
OleDbCommand += "and [a].[Lib_Book_Author_Name]= '" + AuthorName + "'
and [b].[Category_Name] = '" + CategoryName + "')\r\n";
}
OleDbCommand += "Commit Transaction";
cmd.CommandText = OleDbCommand;
int Count =
cmd.ExecuteNonQuery();
if (Count >= 1)
{
IsSuccess = true;
}
conn.Close();
}
catch (Exception ex)
{
throw ex;
}
return
IsSuccess;
}