public DataTable GetBorrowedBookISBNPerBorrower(eVariable.FIND_TYPE oFilter, string sBookID, string sBorrowerID)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery = string.Empty;
switch (oFilter)
{
case eVariable.FIND_TYPE.BOOK_ID:
sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND [STATUS] = 'BORROWED'";
break;
case eVariable.FIND_TYPE.BORROWER_ID:
sQuery = "SELECT BOOK_ID,BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND BORROWER_ID = '" + sBorrowerID + "' AND [STATUS] = 'BORROWED' ";
break;
default:
sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED' ";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean IsBookRecordDataExists(eVariable.FIND_TYPE oFilter, string sFindText)
{
try
{
string sQuery = string.Empty;
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
switch (oFilter)
{
case eVariable.FIND_TYPE.ISBN_NUMBER:
sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'";
break;
case eVariable.FIND_TYPE.BOOK_NO:
sQuery = "SELECT * FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'";
break;
default:
sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetBookISBN(eVariable.FIND_TYPE o_FindType, string sFindText)
{
try
{
string sQuery = string.Empty;
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
switch (o_FindType)
{
case eVariable.FIND_TYPE.BOOK_ID:
sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE ID = '" + sFindText + "'";
break;
case eVariable.FIND_TYPE.BOOK_NO:
sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'";
break;
default:
sQuery = "SELECT ID,BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
