internal int DeletePermitByAgentID(int AgentID)
        {
            int Result = -1;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            DSTableAdapters.PermitTableAdapter adap = new DSTableAdapters.PermitTableAdapter();

            try
            {
                conn.Open();
                adap.Connection = conn;
                Result = adap.DeletePermitByAgentID(AgentID);
            }
            catch (Exception ex)
            {
                Result = -1;
            }
            finally
            {
                adap.Connection.Close();
                conn.Close();
            }

            return Result;
        }