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