public void Fill()
        {
            this.Clear();
            DataTable dataTable = Interviewer_Dal.GetDataTable();


            DataRow     dataRow;
            Interviewer interviewer;

            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                dataRow = dataTable.Rows[i];

                interviewer = new Interviewer(dataRow);
                if (interviewer.DBId != 0)
                {
                    Add(interviewer);
                }
            }
        }
        public static void FillDataSet(DataSet dataSet, string orderBy)
        {
            Dal.FillDataSet(dataSet, tableName, orderBy);

            Interviewer_Dal.FillDataSet(dataSet);


            DataRelation dataRelationNomineeScoreType_Interviewer = new DataRelation(
                "NomineeScoreType_Interviewer"
                , dataSet.Tables[Interviewer_Dal.tableName].Columns["ID"]
                , dataSet.Tables[tableName].Columns["Interviewer"]);


            dataSet.Relations.Add(dataRelationNomineeScoreType_Interviewer);



            Nominee_Dal.FillDataSet(dataSet);


            DataRelation dataRelationNomineeScoreType_Nominee = new DataRelation(
                "NomineeScoretype_Nominee"
                , dataSet.Tables[Nominee_Dal.tableName].Columns["Id"]
                , dataSet.Tables[tableName].Columns["Nominee"]);


            dataSet.Relations.Add(dataRelationNomineeScoreType_Nominee);



            ScoreType_Dal.FillDataSet(dataSet);


            DataRelation dataRelationNomineeScoreType_ScoreType = new DataRelation(
                "NomineeScoretype_ScoreType"
                , dataSet.Tables[ScoreType_Dal.tableName].Columns["Id"]
                , dataSet.Tables[tableName].Columns["ScoreType"]);


            dataSet.Relations.Add(dataRelationNomineeScoreType_ScoreType);
        }