public List <BooksTransactionInMaster> GetTransactionInMasterList() { List <BooksTransactionInMaster> list = null; string commandText = OleDBHelper.GetQueryText("BooksTransactionInMaster_SelectAll", QueryType.Views); using (DataTable table = OleDBHelper.ExecuteSelectCommand(commandText, CommandType.Text)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees list = new List <BooksTransactionInMaster>(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { BooksTransactionInMaster obj = new BooksTransactionInMaster(); obj.TransactionID = Convert.ToString(row["TransactionID"]); obj.TransactionDate = Convert.ToDateTime(row["TransactionDate"]); obj.Remarks = Convert.ToString(row["Remarks"]); list.Add(obj); } } } return(list); }
public BooksTransactionInMaster GetTransactionInMaster(string transactionID) { BooksTransactionInMaster obj = null; string commandText = OleDBHelper.GetQueryText("BooksTransactionInMaster_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 obj = new BooksTransactionInMaster(); obj.TransactionID = Convert.ToString(table.Rows[0]["TransactionID"]); obj.TransactionDate = Convert.ToDateTime(table.Rows[0]["TransactionDate"]); obj.Remarks = Convert.ToString(table.Rows[0]["Remarks"]); } } return(obj); }
private void Save() { bool result = false; BooksTransactionInMaster objBooksTransactionInMaster = GetTransactionInMasterInterface(); BooksTransactionInMasterHandler masterhandler = new BooksTransactionInMasterHandler(); List <BooksTransactionInDetails> objDetailsList = GetTransactionInDetailsInterface(); BooksTransactionInDetailsHandler objDetailsHandler = new BooksTransactionInDetailsHandler(); if (AddMode) { result = masterhandler.AddNewTransactionInMaster(objBooksTransactionInMaster); if (result) { result = objDetailsHandler.AddNewTransactionInDetails(objDetailsList); } if (result) { result = GlobalFunction.UpdateUniqueCode("BooksTransactionInMaster"); } } else if (EditMode) { result = masterhandler.UpdateTransactionIn(objBooksTransactionInMaster); if (result) { result = objDetailsHandler.DeleteTransactionInDetails(objBooksTransactionInMaster.TransactionID); if (result) { result = objDetailsHandler.AddNewTransactionInDetails(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 bool AddNewTransactionInMaster(BooksTransactionInMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@TransactionID", obj.TransactionID), new OleDbParameter("@TransactionDate", obj.TransactionDate), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("BooksTransactionInMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
private BooksTransactionInMaster GetTransactionInMasterInterface() { BooksTransactionInMaster obj = new BooksTransactionInMaster(); obj.TransactionID = txtTranID.Text; obj.TransactionDate = GlobalFunction.GetDateTimeWithoutMiliSecond(dtpTranInDate.Value); obj.Remarks = txtRemarks.Text; //book.Subject = txtSubject.Text; //book.Author = txtAuthorName.Text; //book.Publication = txtPublication.Text; //book.EditionNo = Convert.ToInt32(txtEditionNo.Text); //book.EditionYear = Convert.ToInt32(txtEditionYear.Text); //book.Price = Convert.ToInt32(txtPrice.Text); return(obj); }
public void DisplayData(string transactionID = "-1") { try { ClearControl(); //Master Data BooksTransactionInMasterHandler objMasterHandler = new BooksTransactionInMasterHandler(); BooksTransactionInMaster objMaster = objMasterHandler.GetTransactionInMaster(transactionID); txtTranID.Text = objMaster.TransactionID; dtpTranInDate.Value = objMaster.TransactionDate; txtRemarks.Text = objMaster.Remarks; //Transaction Data BooksTransactionInDetailsHandler tranDetailsHandler = new BooksTransactionInDetailsHandler(); List <BooksTransactionInDetails> list = new List <BooksTransactionInDetails>(); list = tranDetailsHandler.GetTransactionInList(transactionID); if (list.Count > 0) { int i; foreach (BooksTransactionInDetails 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); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message); } }
// Same can be used for deactive user public bool DeleteTransactionInMaster(BooksTransactionInMaster book) { return(true); }