public void vendor_products_delete(int ID)
 {
     vendor_products.Delete(ID);
     Insert_vendor_products_GridView.DataBind();
     Update_vendor_products_GridView.DataBind();
     Delete_vendor_products_GridView.DataBind();
 }
 public vendor_products vendor_products_insert()
 {
     vendor_products.vendor_id        = Convert.ToInt32(Insert_vendor_id_txt.Text);
     vendor_products.product_id       = Convert.ToInt32(Insert_product_id_txt.Text);
     vendor_products.product_qty      = Convert.ToInt32(Insert_product_qty_txt.Text);
     vendor_products.Product_exp_date = Insert_Product_exp_date_txt.Text;
     vendor_products.lot_id           = Convert.ToInt32(Insert_lot_id_txt.Text);
     vendor_products.Department       = Insert_Department_txt.Text;
     vendor_products = vendor_products.Insert(vendor_products);
     Insert_vendor_products_GridView.DataBind();
     Update_vendor_products_GridView.DataBind();
     Delete_vendor_products_GridView.DataBind();
     return(vendor_products);
 }
 public vendor_products vendor_products_update(int ID)
 {
     vendor_products = vendor_products.Select(ID);
     vendor_products.vendor_prod_id   = Convert.ToInt32(Update_vendor_prod_id_txt.Text);
     vendor_products.vendor_id        = Convert.ToInt32(Update_vendor_id_txt.Text);
     vendor_products.product_id       = Convert.ToInt32(Update_product_id_txt.Text);
     vendor_products.product_qty      = Convert.ToInt32(Update_product_qty_txt.Text);
     vendor_products.Product_exp_date = Update_Product_exp_date_txt.Text;
     vendor_products.lot_id           = Convert.ToInt32(Update_lot_id_txt.Text);
     vendor_products.Department       = Update_Department_txt.Text;
     vendor_products.Update(vendor_products);
     Insert_vendor_products_GridView.DataBind();
     Update_vendor_products_GridView.DataBind();
     Delete_vendor_products_GridView.DataBind();
     return(vendor_products);
 }