protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int sessionId = -1;
int pictureid = -1;
GetParams(ref sessionId, ref pictureid);
HyperLinkReturnToPictures.NavigateUrl = "~/SessionAssignPictures.aspx?sessionid=" + sessionId;
LabelPresenterName.Text = Utils.GetUserNameOfSession(sessionId);
SessionsODS sessionsODS = new SessionsODS();
List<SessionsODS.DataObjectSessions> li =
sessionsODS.GetByPrimaryKeySessions(sessionId);
LabelSessionName.Text = li[0].Title;
Image1.ImageUrl = "~/DisplayImage.ashx?sizex=0&pictureid=" + pictureid.ToString();
string fileName = string.Empty;
// Get the description
using (SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CodeCampSV06"].ConnectionString))
{
sqlConnection.Open();
string sqlSelect =
@"SELECT Pictures.FileName,
SessionPictures.Description
FROM Pictures
INNER JOIN SessionPictures ON (Pictures.id = SessionPictures.PictureId)
WHERE (SessionPictures.PictureId = pictures.id) AND
SessionPictures.SessionId = @SessionId AND
SessionPictures.PictureId = @PictureId";
SqlDataReader reader = null;
try
{
SqlCommand command = new SqlCommand(sqlSelect, sqlConnection);
command.Parameters.Add("@PictureId", SqlDbType.Int).Value = pictureid;
command.Parameters.Add("@SessionId", SqlDbType.Int).Value = sessionId;
reader = command.ExecuteReader();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
fileName = CodeCampSV.Utils.ConvertEncodedHTMLToRealHTML(reader.GetString(0));
}
if (!reader.IsDBNull(1))
{
TextBoxDescription.Text = CodeCampSV.Utils.ConvertEncodedHTMLToRealHTML(reader.GetString(1));
}
}
}
catch (Exception eee)
{
throw new ApplicationException(eee.ToString());
}
finally
{
if (reader != null) reader.Close();
}
}
HyperLinkFullRes.NavigateUrl = "http://peterkellner.net/images/CodeCampSV06/" + fileName.ToUpper();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// http://localhost:4443/Web/SessionEval.aspx?id=2
string requestIdStr = Request.QueryString["id"];
bool good = Int32.TryParse(requestIdStr, out sessionId);
if (!good)
{
Response.Redirect("~/Sessions.aspx");
}
if (!IsPostBack)
{
if (Context.User.Identity.IsAuthenticated) // should always be to get here
{
Label1.Text = string.Empty;
Label2.Text = string.Empty;
HyperLinkReturn1.NavigateUrl = "~/Sessions.aspx?OnlyOne=true&id=" + sessionId.ToString();
HyperLinkReturn2.NavigateUrl = "~/Sessions.aspx?OnlyOne=true&id=" + sessionId.ToString();
HyperLinkReturn4.NavigateUrl = "~/SessionsOverview.aspx";
HyperLinkReturn3.NavigateUrl = "~/SessionsOverview.aspx";
HyperLink2.NavigateUrl = "~/MyEvals.aspx";
HyperLink1.NavigateUrl = "~/MyEvals.aspx";
LabelPresenterName.Text = Utils.GetUserNameOfSession(sessionId);
SessionsODS sessionsODS = new SessionsODS();
List<SessionsODS.DataObjectSessions> li =
sessionsODS.GetByPrimaryKeySessions(sessionId);
LabelSessionName.Text = li[0].Title;
ButtonUpdate1.Enabled = true;
ButtonUpdate2.Enabled = true;
this.AddRadioButtonChoices(RBLCourseAsWhole);
this.AddRadioButtonChoices(RBLCourseContent);
this.AddRadioButtonChoices(RBLInstructorAbilityExplain);
this.AddRadioButtonChoices(RBLInstructorEffective);
this.AddRadioButtonChoices(RBLInstructorKnowledge);
this.AddRadioButtonChoices(RBLQualityOfFacility);
this.AddRadioButtonChoices(RBLContentLevel);
this.AddRadioButtonChoices(RBLOverallCodeCamp);
SessionEvalsODS seODS = new SessionEvalsODS();
List<CodeCampSV.SessionEvalsODS.DataObjectSessionEvals> liEvals =
seODS.GetByUsernameSessionId(Context.User.Identity.Name, sessionId);
if (liEvals.Count > 0)
{
SessionEvalsODS.DataObjectSessionEvals se = (SessionEvalsODS.DataObjectSessionEvals)liEvals[0];
RBLCourseAsWhole.SelectedValue = se.Courseaswhole.ToString();
RBLCourseContent.SelectedValue = se.Coursecontent.ToString();
RBLInstructorAbilityExplain.SelectedValue = se.Instructorabilityexplain.ToString();
RBLInstructorEffective.SelectedValue = se.Instructoreffective.ToString();
RBLInstructorKnowledge.SelectedValue = se.Instructorknowledge.ToString();
RBLQualityOfFacility.SelectedValue = se.Qualityoffacility.ToString();
RBLContentLevel.SelectedValue = se.Contentlevel.ToString();
RBLOverallCodeCamp.SelectedValue = se.Overallcodecamp.ToString();
CheckBoxDiscloseName.Checked = se.Discloseeval;
TextBoxFavorite.Text = se.Favorite;
TextBoxImproved.Text = se.Improved;
TextBoxGeneralComments.Text = se.Generalcomments;
}
}
else
{
Label1.Text = "You Must Be Logged In To Enter Evaluations";
Label2.Text = "You Must Be Logged In To Enter Evaluations";
}
}
}