private void btn_edit_Click(object sender, EventArgs e)
{
FRM_PUR_ADD frm_pur_add = new FRM_PUR_ADD();
id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID_PUR"));
tb_pur = dbs.TB_PUR.Where(x => x.ID_PUR == id).FirstOrDefault();
frm_pur_add.txt_name.Text = tb_pur.PUR_NAME;
frm_pur_add.txt_name.Text = tb_pur.PUR_NAME;
frm_pur_add.txt_type.Text = tb_pur.PUR_TYPE;
frm_pur_add.add_cat.Text = tb_pur.PUR_CAT;
frm_pur_add.add_supp.Text = tb_pur.PUR_SUPP;
frm_pur_add.txt_det.Text = tb_pur.PUR_DET;
frm_pur_add.txt_buy.Text = tb_pur.PUR_BUY.ToString();
frm_pur_add.txt_sell.Text = tb_pur.PUR_SELL.ToString();
frm_pur_add.txt_qt.Text = tb_pur.PUR_QT.ToString();
frm_pur_add.t_buy.Text = tb_pur.PUR_Tbuy.ToString();
frm_pur_add.t_sell.Text = tb_pur.PUR_Tsell.ToString();
frm_pur_add.t_all.Text = tb_pur.PUR_TRev.ToString();
frm_pur_add.id = id;
frm_pur_add.btn_add.Text = "التعديل";
frm_pur_add.Show();
}
private void btn_delete_Click(object sender, EventArgs e)
{
Toast toast = new Toast();
Dialog dialog = new Dialog();
id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
if (id > 0)
{
try
{
var rs = MessageBox.Show("عملية حذف", "هل انت متاكد من هذه العملية", MessageBoxButtons.YesNo);
if (rs == DialogResult.Yes)
{
tb_pur = db.TB_PUR.Where(x => x.ID == id).FirstOrDefault();
db.Entry(tb_pur).State = EntityState.Deleted;
db.SaveChanges();
toast.txt_caption.Text = "تم حذف عملية الشراء";
toast.Show();
update_data();
}
}
catch
{
}
}
else
{
dialog.txt_caption.Text = "لا توجد عملية لحذفها";
dialog.Width = this.Width;
dialog.Show();
}
}
private void txt_name_SelectedIndexChanged(object sender, EventArgs e)
{
tb_pur = dbs.TB_PUR.Where(x => x.PUR_NAME == txt_name.Text).FirstOrDefault();
t_sell.Text = tb_pur.PUR_SELL.ToString();
t_buy.Text = tb_pur.PUR_BUY.ToString();
t_qt.Text = tb_pur.PUR_QT.ToString();
txt_sell.Text = tb_pur.PUR_SELL.ToString();
}
private void edt_name_SelectedIndexChanged(object sender, EventArgs e)
{
tb_pur = db.TB_PUR.Where(x => x.Pur_Name == edt_name.Text).FirstOrDefault();
txt_buy.Text = tb_pur.Pur_Buy.ToString();
txt_sell.Text = tb_pur.Pur_Sell.ToString();
txt_qt.Text = tb_pur.Pur_Qt.ToString();
edt_sell.Text = tb_pur.Pur_Sell.ToString();
}
private void btn_delete_Click(object sender, EventArgs e)
{
id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID_PUR"));
var res = MessageBox.Show("هل انت متأكد من حذف شراء ؟؟", "عملية الحذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
tb_pur = dbs.TB_PUR.Where(x => x.ID_PUR == id).FirstOrDefault();
dbs.Entry(tb_pur).State = System.Data.Entity.EntityState.Deleted;
dbs.SaveChanges();
MessageBox.Show("تم عملية الحذف بالنجاح", " تم عملية الحذف", MessageBoxButtons.OK, MessageBoxIcon.Information);
update_data();
}
else
{
return;
}
}
//edit
private void btn_edit_Click(object sender, EventArgs e)
{
PL.FRM_PUR_ADD frm_add = new FRM_PUR_ADD();
id = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
tb_pur = db.TB_PUR.Where(x => x.ID == id).FirstOrDefault();
frm_add.edt_name.Text = tb_pur.Pur_Name;
frm_add.edt_type.Text = tb_pur.Pur_Type;
frm_add.edt_cat.Text = tb_pur.Pur_Cat;
frm_add.edt_sup.Text = tb_pur.Pur_Sup;
frm_add.edt_det.Text = tb_pur.Pur_Det;
frm_add.edt_buy.Text = tb_pur.Pur_Buy.ToString();
frm_add.edt_sell.Text = tb_pur.Pur_Sell.ToString();
frm_add.edt_qt.Text = tb_pur.Pur_Qt.ToString();
frm_add.edt_tsell.Text = tb_pur.Pur_Tsell.ToString();
frm_add.edt_tbuy.Text = tb_pur.Pur_Tbuy.ToString();
frm_add.edt_trev.Text = tb_pur.Pur_TRev.ToString();
frm_add.id = id;
frm_add.btn_add.Text = "تعديل";
frm_add.Show();
}
