public void agency_delete(int ID)
 {
     agency.Delete(ID);
     Insert_agency_GridView.DataBind();
     Update_agency_GridView.DataBind();
     Delete_agency_GridView.DataBind();
 }
 public agency agency_insert()
 {
     agency.address_id    = Convert.ToInt32(Insert_address_id_txt.Text);
     agency.agency_name   = Insert_agency_name_txt.Text;
     agency.primary_fName = Insert_primary_fName_txt.Text;
     agency.primary_lName = Insert_primary_lName_txt.Text;
     agency.primary_phone = Insert_primary_phone_txt.Text;
     agency.sec_fName     = Insert_sec_fName_txt.Text;
     agency.sec_lName     = Insert_sec_lName_txt.Text;
     agency.sec_phone     = Insert_sec_phone_txt.Text;
     agency = agency.Insert(agency);
     Insert_agency_GridView.DataBind();
     Update_agency_GridView.DataBind();
     Delete_agency_GridView.DataBind();
     return(agency);
 }
 public agency agency_update(int ID)
 {
     agency               = agency.Select(ID);
     agency.agency_id     = Convert.ToInt32(Update_agency_id_txt.Text);
     agency.address_id    = Convert.ToInt32(Update_address_id_txt.Text);
     agency.agency_name   = Update_agency_name_txt.Text;
     agency.primary_fName = Update_primary_fName_txt.Text;
     agency.primary_lName = Update_primary_lName_txt.Text;
     agency.primary_phone = Update_primary_phone_txt.Text;
     agency.sec_fName     = Update_sec_fName_txt.Text;
     agency.sec_lName     = Update_sec_lName_txt.Text;
     agency.sec_phone     = Update_sec_phone_txt.Text;
     agency.Update(agency);
     Insert_agency_GridView.DataBind();
     Update_agency_GridView.DataBind();
     Delete_agency_GridView.DataBind();
     return(agency);
 }