private void searchDB() { try { upDateSup update = new upDateSup(); update.Kwrd = txtbSearch.Text; DataTable Table = update.dTable(); ListViewItem entry = null; listViewSupplier.Items.Clear(); foreach (DataRow row in Table.Rows) { entry = new ListViewItem(row["SupplierID"].ToString()); entry.SubItems.Add(row["CompanyName"].ToString()); entry.SubItems.Add(row["ContactSurname"].ToString()); entry.SubItems.Add(row["ContactFirstname"].ToString()); entry.SubItems.Add(row["CompanyAddress"].ToString()); entry.SubItems.Add(row["Address"].ToString()); entry.SubItems.Add(row["Gender"].ToString()); entry.SubItems.Add(row["Marital_Status"].ToString()); entry.SubItems.Add(row["Email"].ToString()); entry.SubItems.Add(row["PhoneNumber"].ToString()); listViewSupplier.Items.Add(entry); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { upDateSup getSupUpdate = new upDateSup(); getSupUpdate.SupID = txtbSupID.Text; getSupUpdate.CompName = txtbCompName.Text; getSupUpdate.CFname = txtbCntctFname.Text; getSupUpdate.CSname = txtbCntctSname.Text; getSupUpdate.CompAddr = txtbCompAddr.Text; getSupUpdate.gender = combGender.Text; getSupUpdate.email = txtbEmail.Text; getSupUpdate.Mstatus = combMarSt.Text; getSupUpdate.Addr = txtbSupAddr.Text; getSupUpdate.Phone = txtbPhone.Text; getSupUpdate.UpDateSupplierInfo(); txtbSupID.Text = null; txtbCompName.Text = null; txtbCntctFname.Text = null; txtbCntctSname.Text = null; txtbCompAddr.Text = null; combGender.Text = null; txtbEmail.Text = null; combMarSt.Text = null; txtbSupAddr.Text = null; txtbPhone.Text = null; MessageBox.Show("Supplier's record updated successfully", "Record Updated", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult Confirm = MessageBox.Show("Are you sure you want to delete this supplier's record?", "Confirm Deletion", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Confirm == DialogResult.Yes) { upDateSup delete = new upDateSup(); delete.SupID = txtbSupID.Text; delete.deleteSup(); txtbSupID.Text = null; txtbCompName.Text = null; txtbCntctFname.Text = null; txtbCntctSname.Text = null; txtbCompAddr.Text = null; combGender.Text = null; txtbEmail.Text = null; combMarSt.Text = null; txtbSupAddr.Text = null; txtbPhone.Text = null; MessageBox.Show("Supplier's record deleted successfully", "Record Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (Confirm == DialogResult.No) { } }
private void FetchListView() { string supplierid = null; try { if (string.IsNullOrEmpty(listViewSupplier.FocusedItem.Text)) { } else { supplierid = listViewSupplier.FocusedItem.Text; upDateSup update = new upDateSup(); update.supplierid = supplierid; DataTable table = update.GetSupplierTable(); foreach (DataRow row in table.Rows) { txtbSupID.Text = row["SupplierID"].ToString(); txtbCompName.Text = row["CompanyName"].ToString(); txtbCntctSname.Text = row["ContactSurname"].ToString(); txtbCntctFname.Text = row["ContactFirstname"].ToString(); txtbCompAddr.Text = row["CompanyAddress"].ToString(); txtbSupAddr.Text = row["Address"].ToString(); combGender.Text = row["Gender"].ToString(); combMarSt.Text = row["Marital_Status"].ToString(); txtbEmail.Text = row["Email"].ToString(); txtbPhone.Text = row["PhoneNumber"].ToString(); } tabUpdateDelete.SelectedTab = pgUpdateDelete; // Activates the Update employee form tab page } } catch { Interaction.MsgBox("Please select record to update", MsgBoxStyle.Exclamation, "Update"); return; } }