void FillRecordList()
{
oMTransactionList = new List <Model.Transaction>();
oBook = new DataAccess.Book();
foreach (DataRow row in oBook.GetBookRecords(eVariable.FILTER_BOOK.BOOK_DEFAULT, "ACTIVE", eVariable.sBookID).Rows)
{
oMTransaction = new Model.Transaction();
oMTransaction.BOOK_ID = row[0].ToString();
oMTransaction.BOOK_NO = row[1].ToString();
oMTransaction.TITLE = row[2].ToString();
oMTransaction.SUBJECT = row[3].ToString();
oMTransaction.CATEGORY = row[4].ToString();
oMTransaction.AUTHOR = row[5].ToString();
oMTransaction.PUBLISH_DATE = row[6].ToString();
oMTransaction.ISBN_NUMBER = row[7].ToString();
oMTransaction.LOCATION = row[8].ToString();
oMTransaction.BOOK_PRICE = row[9].ToString();
oMTransaction.RENT_PRICE = row[10].ToString();
oMTransaction.ADDED_DATE = row[11].ToString();
oMTransaction.ADDED_BY = row[12].ToString();
oMTransaction.MODIFIED_DATE = row[13].ToString();
oMTransaction.MODIFIED_BY = row[14].ToString();
oMTransaction.REMARKS = row[15].ToString();
oMTransaction.STATUS = row[16].ToString();
oMTransactionList.Add(oMTransaction);
}
}
void LoadRecords()
{
oBook = new DataAccess.Book();
dgDetails.Rows.Clear();
eVariable.DisableGridColumnSort(dgDetails);
foreach (DataRow row in oBook.GetBookRecords(oFilterBook, "ACTIVE", txtSearch.Text).Rows)
{
dgDetails.Rows.Add(row["BOOK_ID"], row["TITLE"], row["SUBJECT"], row["CATEGORY"], row["AUTHOR"], row["PUBLISH_DATE"], row["BOOK_PRICE"], row["RENT_PRICE"], row["LOCATION"], row["COPIES_AVAILABLE"], row["TOTAL_COPIES"]);
}
GetPolicy();
}
public void LoadRecords()
{
try
{
oBook = new DataAccess.Book();
dgDetails.Rows.Clear();
eVariable.DisableGridColumnSort(dgDetails);
foreach (DataRow row in oBook.GetBookRecords(oFilterBook, "ACTIVE", txtSearch.Text).Rows)
{
dgDetails.Rows.Add(row["BOOK_ID"], row["TITLE"], row["SUBJECT"], row["CATEGORY"], row["AUTHOR"], row["PUBLISH_DATE"], row["BOOK_PRICE"], row["RENT_PRICE"], row["LOCATION"], row["COPIES_AVAILABLE"], row["TOTAL_COPIES"]);
}
lblTotalRecords.Text = dgDetails.Rows.Count.ToString();
}
catch (Exception ex)
{
}
}