private void button4_Click(object sender, EventArgs e) { DBContext myDb = new DBContext(); myDb.categories.Where(o => o.Name == "دسته1").Load(); var cats = myDb.categories.ToList(); StoreModels.Category c; if (cats.Count == 0) { c = new StoreModels.Category() { Name = "دسته جدید" }; } else { c = cats[0]; } StoreModels.Product p = new StoreModels.Product() { Availability = 10, BuyPrice = 1000, SellPrice = 1500, Category = c, Name = "محصول1", }; myDb.save(p); }
private void button19_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); StoreModels.Product p = myDb.products.Where(i => i.Code == 5).FirstOrDefault(); myDb.products.Attach(p); myDb.delete(p); } 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
private void buttonX2_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox3.Text == "" || textBox4.Text == "") { MessageBox.Show("لطفا تمام اطلاعات را تکمیل کنید", "خطا"); return; } try { long buyPrice = long.Parse(textBox3.Text); long sellPrice = long.Parse(textBox4.Text); int avail = (int)numericUpDown1.Value; StoreModels.Product p = new StoreModels.Product() { Name = textBox1.Text, BarCode = textBox2.Text, BuyPrice = buyPrice, SellPrice = sellPrice, Availability = avail, Category = null }; DBContext myDb = new DBContext(); myDb.save(p); this.Close(); } 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); } }