private void FillListView() { List <BooksMaster> list = new List <BooksMaster>(); BooksMasterHandler handler = new BooksMasterHandler(); list = handler.GetBooksMasterList(); ListViewItem lvi = new ListViewItem(); if (list.Count > 0) { foreach (BooksMaster obj in list) { lvi = new ListViewItem(obj.BookID); lvi.SubItems.Add(obj.ISBN); lvi.SubItems.Add(obj.Title); lvi.SubItems.Add(obj.Subject); lvi.SubItems.Add(obj.Author); lvi.SubItems.Add(obj.Publication); lvi.SubItems.Add(Convert.ToString(obj.EditionNo)); lvi.SubItems.Add(Convert.ToString(obj.EditionYear)); lvi.SubItems.Add(Convert.ToString(obj.Price)); listView1.Items.Add(lvi); } } }
public void DisplayData(string bookID = "-1") { try { ClearControl(); //Master Data BooksMasterHandler objHandler = new BooksMasterHandler(); BooksMaster obj = objHandler.GetBooksMasterDetails(bookID); if (obj != null) { SetBook(obj); ControlStatus(true); } else { MessageBox.Show("No record exist"); } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message); } }
private void Save() { bool result = false; BooksMaster book = GetBook(); BooksMasterHandler handler = new BooksMasterHandler(); if (AddMode) { result = handler.AddNewBooksMaster(book); if (result) { result = GlobalFunction.UpdateUniqueCode("BooksMaster"); } } else if (EditMode) { result = handler.UpdateBooksMaster(book); } if (result == true) { MessageBox.Show("New Account created"); } else { MessageBox.Show("Errror Occurs!"); } }
private void cmdAddItem_Click(object sender, EventArgs e) { ProcessInterface(); if (AddMode || EditMode) { BooksMasterHandler handler = new BooksMasterHandler(); if (_bookID != "") { bookMasterItem = handler.GetBooksMasterDetails(_bookID); AddItemToGrid(bookMasterItem); } //CalculateTotalAmount(); } }
private void txtSearch_TextChanged(object sender, EventArgs e) { string strText = txtSearch.Text; BooksMasterHandler objHandler = new BooksMasterHandler(); List <BooksMaster> list = objHandler.SearchBooksMasterList(strText); dgvMain.RowCount = 0; if ((list != null) && list.Count > 0) { foreach (BooksMaster obj in list) { AddItemToGrid(obj); } dgvMain.Rows[0].Selected = true; } }
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 void Save() { bool result = false; BooksMaster book = GetBook(); BooksMasterHandler handler = new BooksMasterHandler(); if (AddMode) { result = handler.AddNewBooksMaster(book); if (result) { result = GlobalFunction.UpdateUniqueCode("BooksMaster"); } } else if (EditMode) { result = handler.UpdateBooksMaster(book); } if (result == true) { if (AddMode) { MessageBox.Show("New Record added successfully"); } else { MessageBox.Show("Record is updated successfully"); } ControlStatus(true); } else { MessageBox.Show("Errror Occurs!"); } }