public static int GetAgencyID(string AgencyCode, string StateFIPS) { IDataReader AgencyData = LookupDAL.GetAgencyByCodeState(AgencyCode, StateFIPS); try { AgencyData.Read(); int AgencyID = int.Parse(AgencyData["AgencyID"].ToString()); AgencyData.Close(); return(AgencyID); } finally { AgencyData.Close(); } }