//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();
}
}
