public List <BooksTransactionInDetails> GetTransactionInList(string transactionID) { List <BooksTransactionInDetails> list = null; string commandText = OleDBHelper.GetQueryText("BooksTransactionInDetails_SelectID", QueryType.Procedures); OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TransactionID", transactionID) }; using (DataTable table = OleDBHelper.ExecuteParamerizedSelectCommand(commandText, CommandType.Text, parameters)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees list = new List <BooksTransactionInDetails>(); BooksMasterHandler objBookMasterHandler = new BooksMasterHandler(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { BooksTransactionInDetails obj = new BooksTransactionInDetails(); obj.TransactionID = Convert.ToString(row["TransactionID"]); obj.BookMaster = objBookMasterHandler.GetBooksMasterDetails(Convert.ToString(row["BookID"])); obj.Unit = Convert.ToInt32(row["Unit"]); //obj.Subject = Convert.ToString(row["Subject"]); //obj.Author = Convert.ToString(row["Author"]); //obj.Publication = Convert.ToString(row["Publication"]); //obj.EditionNo = Convert.ToInt32(row["EditionNo"]); //obj.EditionYear = Convert.ToInt32(row["EditionYear"]); //obj.Price = Convert.ToInt32(row["Price"]); list.Add(obj); } } } return(list); }
private List <BooksTransactionInDetails> GetTransactionInDetailsInterface() { List <BooksTransactionInDetails> objTrasList = new List <BooksTransactionInDetails>(); int rowCount = dgvMain.RowCount; BooksTransactionInDetails obj; BooksMaster objbookMaster; for (int rowIndex = 0; rowIndex < rowCount; rowIndex++) { obj = new BooksTransactionInDetails(); obj.TransactionID = txtTranID.Text; obj.Unit = Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Unit].Value); objbookMaster = new BooksMaster(); objbookMaster.BookID = Convert.ToString(dgvMain.Rows[rowIndex].Cells[BookID].Value); obj.BookMaster = objbookMaster; objTrasList.Add(obj); } return(objTrasList); }
// Same can be used for deactive user public bool DeleteTransactionInDetails(BooksTransactionInDetails book) { return(true); }