コード例 #1
0
        public DataTable ViewStaff()
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string        conString   = csLayer.cs;
            ViewScoresDAL viewDetails = new ViewScoresDAL(conString);
            DataTable     dt          = viewDetails.ViewStaff();

            return(dt);
        }
コード例 #2
0
        public string SubmitScore(string score, string Comments, string TeamName)
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string            conString = csLayer.cs;
            JudgeAddScoresDAL loadDAL   = new JudgeAddScoresDAL(conString);
            string            dt        = loadDAL.SubmitScore(Convert.ToInt32(score), Comments, TeamName);

            return(dt);
        }
コード例 #3
0
        public DataTable LoadGrid(string appointmentDate)
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string            conString = csLayer.cs;
            JudgeAddScoresDAL loadDAL   = new JudgeAddScoresDAL(conString);
            DataTable         dt        = loadDAL.LoadGrid(appointmentDate);

            return(dt);
        }
コード例 #4
0
        public string UserAuthentication(string UserName, string UserPwd)
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string conString = csLayer.cs;

            UserAuthenticationDAL regDAL = new UserAuthenticationDAL(conString);
            string userRole = regDAL.UserAuthentication(UserName, UserPwd);

            return(userRole);
        }
コード例 #5
0
        public string[] AddTeams(string TeamName, string UseCase, string TeamSize, string leader, string leaderEmail, string teamMembers, string MemberEmail, string Comments)
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string           conString = csLayer.cs;
            AdminAddTeamsDAL regDAL    = new AdminAddTeamsDAL(conString);

            string[] credentials = new string[2];
            credentials = regDAL.AddTeam(TeamName, UseCase, TeamSize, leader, leaderEmail, teamMembers, MemberEmail, Comments);
            return(credentials);
        }
コード例 #6
0
        public string[] JudgeRegister(string firstName, string lastName, string gender, string company, string phoneNo, string email, string address, string city, string pincode, string username, string password)
        {
            csLayer = new ConnectionStringLayer();              /*Connection String which is accessed from Connection string layer*/
            string conString            = csLayer.cs;
            JudgeRegistrationDAL regDAL = new JudgeRegistrationDAL(conString);

            string[] credentials = new string[2];
            credentials = regDAL.RegisterDetailsDAL(firstName, lastName, gender, company, phoneNo, email, address, city, pincode, username, password);
            return(credentials);
        }