Exemple #1
0
        public static void FillDataSet(DataSet dataSet, string orderBy)
        {
            Dal.FillDataSet(dataSet, tableName, orderBy);

            Position_Dal.FillDataSet(dataSet);


            DataRelation dataRelationPosition_NomineePosition = new DataRelation(
                "PositionNominee_Position"
                , dataSet.Tables[Position_Dal.tableName].Columns["ID"]
                , dataSet.Tables[tableName].Columns["Position"]);


            dataSet.Relations.Add(dataRelationPosition_NomineePosition);



            Nominee_Dal.FillDataSet(dataSet);


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


            dataSet.Relations.Add(dataRelationPosition_NomineeNominee);
        }
        public static void FillDataSet(DataSet dataSet)
        {
            Dal.FillDataSet(dataSet, tableName, "[DateTime], [Nominee]");

            Nominee_Dal.FillDataSet(dataSet);


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


            dataSet.Relations.Add(dataRelationLogEntryNominee);



            Position_Dal.FillDataSet(dataSet);
        }
        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);
        }