private void btn_EdittoDGV_Click(object sender, EventArgs e)
{
Supply_Permission_Product spp = new Supply_Permission_Product();
spp.Per_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["PermissionId"].Value);
spp.Prod_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["ProductId"].Value);
spp = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id && a.Prod_Id == spp.Prod_Id).FirstOrDefault();
if (txt_Quantity.Text != string.Empty && txt_PD.Text != string.Empty && txt_ED.Text != string.Empty)
{
spp.Prod_Id = cb_Products.SelectedIndex;
spp.Prod_Name = cb_Products.Text;
spp.Prod_Quantity = int.Parse(txt_Quantity.Text);
spp.Production_Date = DateTime.Parse(txt_PD.Text);
spp.Expiration_Date = DateTime.Parse(txt_ED.Text);
MessageBox.Show("product is updated");
dgv_Products.DataSource = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id).ToList();
txt_Quantity.Text = string.Empty;
txt_PD.Text = string.Empty;
txt_ED.Text = string.Empty;
btn_AddtoDGV.Enabled = true;
}
else
{
MessageBox.Show("please complete missing fields in product form");
}
}
/// <summary>
/// list product in permission operation inside supply permission tab page
/// </summary>
private void btn_AddtoDGV_Click(object sender, EventArgs e)
{
if (txt_Quantity.Text != string.Empty && txt_PD.Text != string.Empty && txt_ED.Text != string.Empty)
{
Supply_Permission_Product spp = new Supply_Permission_Product()
{
Per_Id = int.Parse(txt_SPid.Text),
Prod_Id = cb_Products.SelectedIndex,
Prod_Name = cb_Products.Text,
Prod_Quantity = int.Parse(txt_Quantity.Text),
Production_Date = DateTime.Parse(txt_PD.Text),
Expiration_Date = DateTime.Parse(txt_ED.Text)
};
db.Supply_Permission_Product.Add(spp);
db.SaveChanges();
MessageBox.Show("product added successfully");
dgv_Products.DataSource = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id).ToList();
txt_Quantity.Text = string.Empty;
txt_PD.Text = string.Empty;
txt_ED.Text = string.Empty;
}
else
{
MessageBox.Show("please complete missing fields in product form");
}
}
private void btn_DeletefromDGV_Click(object sender, EventArgs e)
{
Supply_Permission_Product spp = new Supply_Permission_Product();
spp.Per_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["PermissionId"].Value);
spp.Prod_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["ProductId"].Value);
spp = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id && a.Prod_Id == spp.Prod_Id).FirstOrDefault();
db.Supply_Permission_Product.Remove(spp);
db.SaveChanges();
MessageBox.Show("product deleted sucessfuly");
dgv_Products.DataSource = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id && a.Prod_Id == spp.Prod_Id).ToList();
txt_Quantity.Text = string.Empty;
txt_PD.Text = string.Empty;
txt_ED.Text = string.Empty;
btn_AddtoDGV.Enabled = true;
}
// edit selected row by double click event
private void dgv_Products_DoubleClick(object sender, EventArgs e)
{
if (dgv_Products.CurrentRow.Index != -1)
{
Supply_Permission_Product spp = new Supply_Permission_Product();
spp.Per_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["PermissionId"].Value);
spp.Prod_Id = Convert.ToInt32(dgv_Products.CurrentRow.Cells["ProductId"].Value);
spp = db.Supply_Permission_Product.Where(a => a.Per_Id == spp.Per_Id && a.Prod_Id == spp.Prod_Id).FirstOrDefault();
txt_Quantity.Text = spp.Prod_Quantity.ToString();
txt_PD.Text = spp.Production_Date.ToString();
txt_ED.Text = spp.Expiration_Date.ToString();
cb_Products.SelectedIndex = spp.Prod_Id;
btn_EdittoDGV.Text = "Update";
btn_AddtoDGV.Enabled = false;
}
}