private void button20_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); StoreModels.Contact c = myDb.contacts.Where(i => i.Code == 1).FirstOrDefault(); myDb.contacts.Attach(c); myDb.delete(c); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button22_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); StoreModels.FinancialTransaction ft = myDb.FinancialTransactions.Where(i => i.Code == 2).FirstOrDefault(); myDb.FinancialTransactions.Attach(ft); myDb.delete(ft); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button16_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); StoreModels.Check ck = myDb.checks.Where(i => i.Code == 4).First(); myDb.checks.Attach(ck); myDb.delete(ck); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridViewButtonXCell cell = dataGridViewX1.CurrentCell as DataGridViewButtonXCell; if (cell != null) { DataGridViewButtonXColumn bc = dataGridViewX1.Columns[e.ColumnIndex] as DataGridViewButtonXColumn; if (bc != null) { switch (bc.Name) { case "Delete": DialogResult dr = MessageBox.Show("آیا از حذف محصول \"" + dataGridViewX1.Rows[e.RowIndex].Cells["Name"].Value + "\" اطمینان دارید؟", "تایید حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == System.Windows.Forms.DialogResult.Yes) { int m = (int)dataGridViewX1.Rows[e.RowIndex].Cells["code"].Value; DBContext myDb2 = new DBContext(); StoreModels.Product p = myDb2.products.Where(i => i.Code == m).First(); try { myDb2.delete(p); refresh(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { String s = "خطا در ذخیره اطلاعات در پایگاه داده\nمشخصات فنی:\n"; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Diagnostics.Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); s = s + "\nProperty: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage; } } MessageBox.Show(s); } catch (Exception ex) { MessageBox.Show("خطایی رخ داد\n" + ex.Message); } } break; } } } //if cell ! null } //void dataGridViewX1_CellContentClick