private void button3_Click(object sender, EventArgs e) { DBContext myDb = new DBContext(); myDb.superCategories.Where(o => o.Name == "سوپر دسته1").Load(); var scats = myDb.superCategories.ToList(); StoreModels.SuperCategory sc; if (scats.Count == 0) { sc = new StoreModels.SuperCategory() { Name = "سوپر دسته جدید" } } ; else { sc = scats[0]; } StoreModels.Category c = new StoreModels.Category() { Name = "دسته1", SuperCategory = sc }; myDb.save(c); }
private void button23_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); myDb.products.Load(); var lst = myDb.products.ToList(); if (lst.Count == 0) { //لیست خالی } else { bool flag = false; myDb.superCategories.Load(); var lst1 = myDb.superCategories.ToList(); for (int i = 0; i < lst1.Count; i++) { if (lst1[i].Name == "") { flag = true; } if (!flag) { StoreModels.SuperCategory sc = new StoreModels.SuperCategory() { Name = "سوپر دسته" }; myDb.save(sc); } } myDb.categories.Load(); var lst2 = myDb.categories.ToList(); for (int i = 0; i < lst1.Count; i++) { if (lst2[i].Name == "دسته1") { flag = true; } if (!flag) { StoreModels.Category c = new StoreModels.Category() { Name = "کالا" }; myDb.save(c); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { StoreModels.SuperCategory sc = new StoreModels.SuperCategory() { Name = "سوپر دسته1" }; DBContext myDb = new DBContext(); myDb.save(sc); }
private void button17_Click(object sender, EventArgs e) { DBContext myDb = null; try { myDb = new DBContext(); StoreModels.SuperCategory sc = myDb.superCategories.Where(i => i.Code == 1).FirstOrDefault(); myDb.superCategories.Attach(sc); myDb.delete(sc); } catch (Exception ex) { MessageBox.Show(ex.Message); } }