//delete private void btn_delete_Click(object sender, EventArgs e) { Toast toast = new Toast(); try { id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID")); var res = MessageBox.Show("هل انت متاكد من عملية الحذف", "حذف", MessageBoxButtons.YesNo); if (res == DialogResult.Yes) { tb_cat = db.TB_CAT.Where(x => x.ID == id).FirstOrDefault(); db.Entry(tb_cat).State = EntityState.Deleted; db.SaveChanges(); toast.labl_caption.Text = "تم حذف الصنف بنجاح"; toast.Show(); this.Close(); //renew tale update_data(); } } catch { MessageBox.Show("قم بالتحديد لحذف الصنف"); } }
private void txtitemName_SelectedIndexChanged(object sender, EventArgs e) { int i = Convert.ToInt32(txtitemName.SelectedValue.ToString()); TB_CAT tb1_cat = db.TB_CAT.Where(x => x.ID == i).FirstOrDefault(); txtSell.Text = tb1_cat.CAT_Price_sale.ToString(); }
//renew function private void update_data() { Toast toast = new Toast(); var w = tb_cat = db.TB_CAT.Where(x => x.ItemQuantity <= 0).FirstOrDefault(); toast.labl_caption.Text = "(" + w.CAT_Name + ")" + "\t لا يوجد كمية من هذا الصنف "; toast.Show(); db = new DB_SMPEntities1(); gridControl1.DataSource = db.TB_CAT.ToList(); }
private void BtnAdd_Click(object sender, EventArgs e) { Toast toast = new Toast(); Sell sel_add = new Sell(); if (txtitemName.Text == "" || TxtCustomerName.Text == "" || numericUpDown1.Value == 0) { toast.labl_caption.Text = "يجيب ان تدخل البيانات"; toast.Show(); } else { if (BtnAdd.Text == "إضافة") { sel_add.ItemName = txtitemName.Text; sel_add.CustomerId = TxtCustomerName.Text; sel_add.SellDate = DateTime.Parse(txtSellDate.Text); // sel_add.InvoiceId = Convert.ToInt32( txtInvoiceName.Text); sel_add.SellPrice = float.Parse(txtSell.Text); sel_add.SellQuantity = int.Parse(numericUpDown1.Value.ToString()); sel_add.TotalPrrice = float.Parse(txtTotalPrice.Text); db.Sells.Add(sel_add); int i = int.Parse(txtitemName.SelectedValue.ToString()); TB_CAT tb_cat = db.TB_CAT.Where(x => x.ID == i).FirstOrDefault(); tb_cat.ItemQuantity -= int.Parse(numericUpDown1.Value.ToString()); db.SaveChanges(); toast.labl_caption.Text = "تم اضافة صنف بيع جديد"; toast.Show(); this.Close(); } else { int i = int.Parse(txtid.Text); sel_add = db.Sells.Where(s => s.Id == i).FirstOrDefault(); //sel_add.Id = id; sel_add.ItemName = txtitemName.Text; sel_add.CustomerId = TxtCustomerName.Text; sel_add.SellDate = DateTime.Parse(txtSellDate.Text); // sel_add.InvoiceId = int.Parse(txtInvoiceName.Text); sel_add.SellPrice = float.Parse(txtSell.Text); sel_add.SellQuantity = int.Parse(numericUpDown1.Value.ToString()); sel_add.TotalPrrice = float.Parse(txtTotalPrice.Text); db.SaveChanges(); toast.labl_caption.Text = "تم تعديل صنف مبيع جديد"; toast.Show(); this.Close(); } } }
//edit private void btn_edit_Click(object sender, EventArgs e) { FRM_CAT_ADD frm_add = new FRM_CAT_ADD(); id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID")); tb_cat = db.TB_CAT.Where(x => x.ID == id).FirstOrDefault(); frm_add.txt_name.Text = tb_cat.CAT_Name.ToString(); frm_add.txt_price_buy.Text = tb_cat.CAT_Price_buy.ToString(); frm_add.txt_price_sell.Text = tb_cat.CAT_Price_sale.ToString(); frm_add.id = id; frm_add.btn_add.Text = "تعديل"; frm_add.Show(); }
private void BtnAdd_Click(object sender, EventArgs e) { Toast toast = new Toast(); try { if (txtitemName.Text == "" || txtSuppliersName.Text == "" || numericUpDown1.Value == 0 || txtBuy.Text == "") { toast.labl_caption.Text = "يجيب ان تدخل البيانات"; toast.Show(); } else { if (BtnAdd.Text == "إضافة") { Buyer bu = new Buyer() { name = (txtitemName.Text), SuppliersName = txtSuppliersName.Text, BuyingDate = this.dateTimePicker1.Value.Date, BuyingPrice = float.Parse(txtBuy.Text), SellingPrice = float.Parse(txtSell.Text), Profit = float.Parse(txtTotalPrice.Text), itemsNumbers = int.Parse(numericUpDown1.Value.ToString()) }; db.Buyers.Add(bu); int i = int.Parse(txtitemName.SelectedValue.ToString()); TB_CAT tb_cat = db.TB_CAT.Where(x => x.ID == i).FirstOrDefault(); tb_cat.ItemQuantity += int.Parse(numericUpDown1.Value.ToString()); db.SaveChanges(); toast.labl_caption.Text = "تم اضافة صنق جديد"; toast.Show(); this.Close(); } else { Buyer buyer_add = new Buyer(); int i = int.Parse(txtid.Text); buyer_add = db.Buyers.Where(s => s.Id == i).FirstOrDefault(); //sel_add.Id = id; buyer_add.name = (txtitemName.Text); buyer_add.SuppliersName = txtSuppliersName.Text; buyer_add.BuyingDate = this.dateTimePicker1.Value.Date; buyer_add.BuyingPrice = float.Parse(txtBuy.Text); buyer_add.SellingPrice = float.Parse(txtSell.Text); buyer_add.Profit = float.Parse(txtTotalPrice.Text); buyer_add.itemsNumbers = int.Parse(numericUpDown1.Value.ToString()); db.SaveChanges(); toast.labl_caption.Text = "تم تعديل صنف مبيع جديد"; toast.Show(); this.Close(); } } } catch { toast.labl_caption.Text = "برجاء ادخال البيانات صحيحة"; toast.Show(); } }