C# (CSharp) Recruitment_System.DAL Dal.FillDataSet Exemples

Exemple #1

        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);
        }

Exemple #2

Fichier : Position_Dal.cs Projet : RonUcitel/Recruitment-System

 public static void FillDataSet(DataSet dataSet)
 {
     if (!dataSet.Tables.Contains(tableName))
     {
         Dal.FillDataSet(dataSet, tableName, "[Name]");
     }
 }

Exemple #3

Fichier : Nominee_Dal.cs Projet : RonUcitel/Recruitment-System

        public static void FillDataSet(DataSet dataSet)
        {
            Dal.FillDataSet(dataSet, tableName, "[lastName],[FirstName]");

            City_Dal.FillDataSet(dataSet);


            DataRelation dataRelationNomineeCity = new DataRelation(
                "NomineeCity"
                , dataSet.Tables[City_Dal.tableName].Columns["Id"]
                , dataSet.Tables[tableName].Columns["City"]);


            dataSet.Relations.Add(dataRelationNomineeCity);
        }

Exemple #4

Fichier : ScoreType_Dal.cs Projet : RonUcitel/Recruitment-System

        public static void FillDataSet(DataSet dataSet)
        {
            Dal.FillDataSet(dataSet, tableName, "[Position],[Name]");

            Position_Dal.FillDataSet(dataSet);


            DataRelation dataRelationScoreType_Position = new DataRelation(
                "ScoreType_Position"
                , dataSet.Tables[Position_Dal.tableName].Columns["Id"]
                , dataSet.Tables[tableName].Columns["Position"]);


            dataSet.Relations.Add(dataRelationScoreType_Position);
        }

Exemple #5

Fichier : LogEntry_Dal.cs Projet : RonUcitel/Recruitment-System

        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);
        }

Exemple #6

Fichier : NomineeScoreType_Dal.cs Projet : RonUcitel/Recruitment-System

        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);
        }

Exemple #7

 public static void FillDataSet(DataSet dataSet)
 {
     Dal.FillDataSet(dataSet, tableName, "");
 }