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) { } }