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 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 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); }
public void sell(List <ProductTransactionItem> pti, DateTime date, string not = null, bool isPaid = true, Contact con = null, Check chk = null) { DateTime?paydate = null; if (isPaid) { paydate = DateTime.Now; } ProductTransaction pt = new ProductTransaction() { CreationDate = date, PaymentDate = paydate, Check = chk, Contact = con, Note = not, }; DBContext myDBContext = new DBContext(); foreach (ProductTransactionItem item in pti) { pt.items.Add(item); myDBContext.products.Attach(item.Product); //association with product and dbcontext } myDBContext.save(pt); }
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 button5_Click(object sender, EventArgs e) { StoreModels.Contact con = new StoreModels.Contact() { Name = "Arash", Type = StoreModels.Contact.Types.Person, Phone = "09355000000" }; DBContext myDB = new DBContext(); myDB.save(con); }
private void button1_Click(object sender, EventArgs e) { StoreModels.Check ch = new StoreModels.Check() { Date = DateTime.Now, Price = 2000, VosoolStatus = StoreModels.Check.VosoolStatuses.pishAzMoed, BankBranch = "1234" }; DBContext myDb = new DBContext(); myDb.save(ch); }
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); } }
private void button6_Click(object sender, EventArgs e) { try { StoreModels.MoneyTransaction mt = new StoreModels.MoneyTransaction() { CreationDate = DateTime.Now, IsPersonal = true, TotalPrice = 10000, Type = StoreModels.MoneyTransaction.MTTypes.Hazine }; DBContext myDB = new DBContext(); myDB.save(mt); } catch (Exception ex) { throw ex; } }
private void button7_Click(object sender, EventArgs e) { try { StoreModels.FinancialTransaction ft = new StoreModels.FinancialTransaction() { CreationDate = DateTime.Now, IsPersonal = true, TotalPrice = 10000, Type = StoreModels.FinancialTransaction.FTTypes.Talab, PayType = StoreModels.Transaction.PaymentTypes.Naghd }; DBContext myDB = new DBContext(); myDB.save(ft); } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } }