public void DisplayData(string transactionID = "-1") { try { //Master Data BooksTransactionOutMaster objMaster = new BooksTransactionOutMaster(); objMaster = objMaster.GetTransactionOutMaster(transactionID); if (objMaster != null) { ClearControl(); txtTranID.Text = objMaster.TransactionID; dtpTranInDate.Value = objMaster.TransactionDate; txtRemarks.Text = objMaster.Remarks; //Transaction Data BooksTransactionOutDetails tranDetails = new BooksTransactionOutDetails(); List <BooksTransactionOutDetails> list = new List <BooksTransactionOutDetails>(); list = tranDetails.GetTransactionInList(transactionID); if (list.Count > 0) { int i; foreach (BooksTransactionOutDetails obj in list) { i = dgvMain.RowCount; dgvMain.RowCount = i + 1; dgvMain.Rows[i].Cells[SNo].Value = i + 1; dgvMain.Rows[i].Cells[BookID].Value = obj.BookMaster.BookID; dgvMain.Rows[i].Cells[Subject].Value = obj.BookMaster.Subject; dgvMain.Rows[i].Cells[Author].Value = obj.BookMaster.Author; dgvMain.Rows[i].Cells[EditionYear].Value = obj.BookMaster.EditionYear; dgvMain.Rows[i].Cells[EditionNo].Value = obj.BookMaster.EditionNo; dgvMain.Rows[i].Cells[Unit].Value = obj.Unit; } } ControlStatus(true); } else { MessageBox.Show("No Record found"); } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message); } }
private void Save() { bool result = false; BooksTransactionOutMaster objOutMaster = GetTransactionOutMasterInterface(); List <BooksTransactionOutDetails> objDetailsList = GetTransactionInDetailsOutiterface(); BooksTransactionOutDetails objDetails = new BooksTransactionOutDetails(); if (AddMode) { result = objOutMaster.AddNewTransactionOutMaster(objOutMaster); if (result) { result = objDetails.AddNewTransactionOutDetails(objDetailsList); } if (result) { result = GlobalFunction.UpdateUniqueCode("BooksTransactionOutMaster"); } } else if (EditMode) { result = objOutMaster.UpdateTransactionOutMaster(objOutMaster); if (result) { result = objDetails.DeleteTransactionOutMaster(objOutMaster.TransactionID); if (result) { result = objDetails.AddNewTransactionOutDetails(objDetailsList); } } } if (result == true) { if (AddMode) { MessageBox.Show("New Record added successfully"); } else { MessageBox.Show("Record updated successfully"); } ControlStatus(true); } else { MessageBox.Show("Errror Occurs!"); } }
public List <BooksTransactionOutDetails> GetTransactionInList(string transactionID) { List <BooksTransactionOutDetails> list = null; string commandText = OleDBHelper.GetQueryText("BooksTransactionOutDetails_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 <BooksTransactionOutDetails>(); BooksMasterHandler objBookMasterHandler = new BooksMasterHandler(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { BooksTransactionOutDetails obj = new BooksTransactionOutDetails(); 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 <BooksTransactionOutDetails> GetTransactionInDetailsOutiterface() { List <BooksTransactionOutDetails> objTrasList = new List <BooksTransactionOutDetails>(); int rowCount = dgvMain.RowCount; BooksTransactionOutDetails obj; BooksMaster objbookMaster; for (int rowIndex = 0; rowIndex < rowCount; rowIndex++) { obj = new BooksTransactionOutDetails(); 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); }
public bool UpdateTransactionOutDetails(BooksTransactionOutDetails book) { return(true); }