public void requestor_Order_delete(int ID)
 {
     requestor_Order.Delete(ID);
     Insert_requestor_Order_GridView.DataBind();
     Update_requestor_Order_GridView.DataBind();
     Delete_requestor_Order_GridView.DataBind();
 }
 public requestor_Order requestor_Order_insert()
 {
     requestor_Order.Requestor_ID      = Convert.ToInt32(Insert_Requestor_ID_txt.Text);
     requestor_Order.EncounterID       = Convert.ToInt32(Insert_EncounterID_txt.Text);
     requestor_Order.OrderPriority     = Convert.ToInt32(Insert_OrderPriority_txt.Text);
     requestor_Order.OrderNum          = Convert.ToInt32(Insert_OrderNum_txt.Text);
     requestor_Order.ShipToAddressID   = Convert.ToInt32(Insert_ShipToAddressID_txt.Text);
     requestor_Order.OrderDeliveryType = Insert_OrderDeliveryType_txt.Text;
     requestor_Order.OrderPickUpDate   = Convert.ToDateTime(Insert_OrderPickUpDate_txt.Text);
     requestor_Order = requestor_Order.Insert(requestor_Order);
     Insert_requestor_Order_GridView.DataBind();
     Update_requestor_Order_GridView.DataBind();
     Delete_requestor_Order_GridView.DataBind();
     return(requestor_Order);
 }
 public requestor_Order requestor_Order_update(int ID)
 {
     requestor_Order                   = requestor_Order.Select(ID);
     requestor_Order.OrderID           = Convert.ToInt32(Update_OrderID_txt.Text);
     requestor_Order.Requestor_ID      = Convert.ToInt32(Update_Requestor_ID_txt.Text);
     requestor_Order.EncounterID       = Convert.ToInt32(Update_EncounterID_txt.Text);
     requestor_Order.OrderPriority     = Convert.ToInt32(Update_OrderPriority_txt.Text);
     requestor_Order.OrderNum          = Convert.ToInt32(Update_OrderNum_txt.Text);
     requestor_Order.ShipToAddressID   = Convert.ToInt32(Update_ShipToAddressID_txt.Text);
     requestor_Order.OrderDeliveryType = Update_OrderDeliveryType_txt.Text;
     requestor_Order.OrderPickUpDate   = Convert.ToDateTime(Update_OrderPickUpDate_txt.Text);
     requestor_Order.Update(requestor_Order);
     Insert_requestor_Order_GridView.DataBind();
     Update_requestor_Order_GridView.DataBind();
     Delete_requestor_Order_GridView.DataBind();
     return(requestor_Order);
 }