private void EditSupplierButton_Click(object sender, EventArgs e) { //get the key of the current Supplier in the data grid view int rowNum = supplierDataGridView.CurrentCell.RowIndex; string supplierID = supplierDataGridView["dataGridViewTextBoxColumn1", rowNum].Value.ToString(); //create a current Supplier object Supplier existingSupplier; using (SupplierDataContext dataContext = new SupplierDataContext()) { existingSupplier = (from s in dataContext.Suppliers where s.SupplierId.ToString() == supplierID select s).Single(); } //instantiate the addeditSupplierForm frmAddEditSupplier frmAddEdit = new frmAddEditSupplier(); frmAddEdit.EditMode = true; //editing Supplier frmAddEdit.exsistingSupplier = existingSupplier; DialogResult result = frmAddEdit.ShowDialog(); // display second form modal if (result == DialogResult.OK || result == DialogResult.Retry) // successful update or concurrency exception { reloadGridView(); } }
private void Updatebutton_Click(object sender, EventArgs e) { if (!EditMode) //if adding a Supplier { Supplier newSupplier = new Supplier //create a new Supplier from user input { SupplierId = int.Parse(supplierIdTextBox.Text), SupName = supNameTextBox.Text }; using (SupplierDataContext dataContext = new SupplierDataContext()) { //insert through data context from the main form dataContext.Suppliers.InsertOnSubmit(newSupplier); dataContext.SubmitChanges(); //submit to the database } DialogResult = DialogResult.OK; } else //if editing Supplier { try { using (SupplierDataContext dataContext = new SupplierDataContext()) { //get the product ID from current text box Supplier supplier = dataContext.Suppliers.Single(p => p.SupplierId.ToString() == supplierIdTextBox.Text); if (supplier != null) { supplier.SupName = supNameTextBox.Text; //submit changes dataContext.SubmitChanges(); DialogResult = DialogResult.OK; } } } catch (ChangeConflictException) { MessageBox.Show("Another user changed or deleted the current record", "Concurrency Exception"); DialogResult = DialogResult.Retry; } catch (Exception excp) { MessageBox.Show(excp.Message, excp.GetType().ToString()); } } }
private void FrmSupplier_Load(object sender, EventArgs e) { using (SupplierDataContext dataContext = new SupplierDataContext()) { supplierDataGridView.DataSource = dataContext.Suppliers; } supplierDataGridView.BorderStyle = BorderStyle.None; supplierDataGridView.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(238, 239, 249); supplierDataGridView.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; supplierDataGridView.DefaultCellStyle.SelectionBackColor = Color.DarkTurquoise; supplierDataGridView.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; supplierDataGridView.BackgroundColor = Color.White; supplierDataGridView.EnableHeadersVisualStyles = false; supplierDataGridView.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; supplierDataGridView.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); supplierDataGridView.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
private void reloadGridView() { SupplierDataContext dataContext = new SupplierDataContext(); supplierDataGridView.DataSource = dataContext.Suppliers; }