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
