// main 3 buttons of supply permission private void btn_EditSP_Click(object sender, EventArgs e) { try { groupBox2.Enabled = true; if (txt_SPid.Text != string.Empty) { var id = int.Parse(txt_SPid.Text); Supply_Permission sp = db.Supply_Permission.FirstOrDefault(a => a.Per_Id == id); txt_SPdate.Text = sp.Per_Date.ToString(); cb_Warehouses.SelectedItem = sp.War_Name; cb_Suppliers.SelectedItem = sp.Sup_Name; var query = db.Supply_Permission_Product.Where(a => a.Per_Id == sp.Per_Id); dgv_Products.DataSource = query.ToList(); } btn_SubmitSP.Enabled = false; btn_DeleteSP.Enabled = false; btn_ModifySP.Enabled = true; btn_EditSP.Enabled = false; txt_SPid.ReadOnly = true; } catch { MessageBox.Show("Can't find permission with giving information"); } }
// create permission button handle private void btn_Create_Click(object sender, EventArgs e) { if (txt_SPid.Text != string.Empty && txt_SPdate.Text != string.Empty) { Supply_Permission sp = new Supply_Permission() { Per_Id = int.Parse(txt_SPid.Text), Per_Date = DateTime.Parse(txt_SPdate.Text), War_Name = cb_Warehouses.SelectedItem.ToString(), Sup_Name = cb_Suppliers.SelectedItem.ToString() }; db.Supply_Permission.Add(sp); db.SaveChanges(); MessageBox.Show("Permission created successfully you can now add products"); dgv_Products.DataSource = db.Supply_Permission_Product.Where(a => a.Per_Id == sp.Per_Id).ToList(); groupBox1.Enabled = true; groupBox2.Enabled = false; if (txt_Quantity.Text != string.Empty || txt_PD.Text != string.Empty || txt_ED.Text != string.Empty) { txt_Quantity.Text = string.Empty; txt_PD.Text = string.Empty; txt_ED.Text = string.Empty; } } else { MessageBox.Show("please complete missing fields Permission No. or Permission Date"); } }
private void btn_DeleteSP_Click(object sender, EventArgs e) { try { if (txt_Cname.Text != string.Empty) { int id = int.Parse(txt_SPid.Text); Supply_Permission sp = db.Supply_Permission.FirstOrDefault(a => a.Per_Id == id); db.Supply_Permission.Remove(sp); db.SaveChanges(); MessageBox.Show("permission deleted sucessfuly"); txt_SPid.Text = string.Empty; txt_SPdate.Text = string.Empty; } } catch { MessageBox.Show("Can't find permission with giving information"); } }
private void btn_ModifySP_Click(object sender, EventArgs e) { int id = int.Parse(txt_SPid.Text); Supply_Permission sp = db.Supply_Permission.FirstOrDefault(a => a.Per_Id == id); if (txt_SPdate.Text != string.Empty) { sp.Per_Date = DateTime.Parse(txt_SPdate.Text); sp.War_Name = cb_Warehouses.SelectedItem.ToString(); sp.Sup_Name = cb_Suppliers.SelectedItem.ToString(); MessageBox.Show("Product is updated"); txt_Pid.Text = string.Empty; txt_Pname.Text = string.Empty; } btn_SubmitSP.Enabled = true; btn_DeleteProd.Enabled = true; btn_ModifyProd.Enabled = false; btn_EditProd.Enabled = true; txt_Pid.ReadOnly = false; groupBox2.Enabled = false; }