protected void Page_Load(object sender, EventArgs e) { var dal = new UsersDal(); GridViewMLeaderBoard.DataSource = dal.GetUserLeaderBordList(); GridViewMLeaderBoard.DataBind(); pbStageProgress.Value = (new StagesDal()).GetCurrentStageProgress(); var devLeader = dal.GetStageLeader("Software Engineering"); var qcLeader = dal.GetStageLeader("Quality Control"); var twLeader = dal.GetStageLeader("Technical Communication"); if (devLeader != null && devLeader.Tables.Count > 0 && devLeader.Tables[0].Rows.Count > 0) { LeaderPreviewDev.Title = "Software Engineering"; LeaderPreviewDev.UserName = devLeader.Tables[0].Rows[0].ItemArray[6].ToString(); LeaderPreviewDev.UserFullName = devLeader.Tables[0].Rows[0].ItemArray[0].ToString(); LeaderPreviewDev.ImageUrl = devLeader.Tables[0].Rows[0].ItemArray[1].ToString(); LeaderPreviewDev.EmblemUrl = devLeader.Tables[0].Rows[0].ItemArray[2].ToString(); LeaderPreviewDev.CountMissionsDoneByUser = Convert.ToInt32(devLeader.Tables[0].Rows[0].ItemArray[3]); LeaderPreviewDev.MissionsOnStage = Convert.ToInt32(devLeader.Tables[0].Rows[0].ItemArray[4]); LeaderPreviewDev.PercentageOfWork = Convert.ToDecimal(devLeader.Tables[0].Rows[0].ItemArray[5]); LeaderPreviewDev.UserName = devLeader.Tables[0].Rows[0].ItemArray[6].ToString(); } if (qcLeader != null && qcLeader.Tables.Count > 0 && qcLeader.Tables[0].Rows.Count > 0) { LeaderPreviewQC.Title = "Quality Control"; LeaderPreviewQC.UserName = qcLeader.Tables[0].Rows[0].ItemArray[6].ToString(); LeaderPreviewQC.UserFullName = qcLeader.Tables[0].Rows[0].ItemArray[0].ToString(); LeaderPreviewQC.ImageUrl = qcLeader.Tables[0].Rows[0].ItemArray[1].ToString(); LeaderPreviewQC.EmblemUrl = qcLeader.Tables[0].Rows[0].ItemArray[2].ToString(); LeaderPreviewQC.CountMissionsDoneByUser = Convert.ToInt32(qcLeader.Tables[0].Rows[0].ItemArray[3]); LeaderPreviewQC.MissionsOnStage = Convert.ToInt32(qcLeader.Tables[0].Rows[0].ItemArray[4]); LeaderPreviewQC.PercentageOfWork = Convert.ToDecimal(qcLeader.Tables[0].Rows[0].ItemArray[5]); } if (twLeader != null && twLeader.Tables.Count > 0 && twLeader.Tables[0].Rows.Count > 0) { LeaderPreviewTW.Title = "Technical communication"; LeaderPreviewTW.UserName = twLeader.Tables[0].Rows[0].ItemArray[6].ToString(); LeaderPreviewTW.UserFullName = twLeader.Tables[0].Rows[0].ItemArray[0].ToString(); LeaderPreviewTW.ImageUrl = twLeader.Tables[0].Rows[0].ItemArray[1].ToString(); LeaderPreviewTW.EmblemUrl = twLeader.Tables[0].Rows[0].ItemArray[2].ToString(); LeaderPreviewTW.CountMissionsDoneByUser = Convert.ToInt32(twLeader.Tables[0].Rows[0].ItemArray[3]); LeaderPreviewTW.MissionsOnStage = Convert.ToInt32(twLeader.Tables[0].Rows[0].ItemArray[4]); LeaderPreviewTW.PercentageOfWork = Convert.ToDecimal(twLeader.Tables[0].Rows[0].ItemArray[5]); } }