protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { btnApproveProfile.Visible = false; //Create a new object from the Suggestion Class StudentClass objStudent = new StudentClass(); objStudent.studentId = Convert.ToInt32(Request.QueryString["StudentId"]); objStudent.getDetails(); Suggestion objSuggestion = new Suggestion(); MentorClass objMentor = new MentorClass(); objMentor.emailaddr = (string)Session["LoginID"]; objSuggestion.mentorId = (int)Session["MentorID"]; objSuggestion.studentId = Convert.ToInt32(Request.QueryString["StudentId"]); objSuggestion.description = tbSuggestions.Text; objSuggestion.status = Convert.ToChar("N"); objSuggestion.dateCreated = DateTime.Now; //Check if the selected Student Profile status is "N", if the Mentor Suggestion is not acknowledged yet if (objStudent.status == Convert.ToChar("Y") && objSuggestion.status == Convert.ToChar("N")) { //Call the add method to insert the suggestions record to database objStudent.studentId = Convert.ToInt32(Request.QueryString["StudentId"]); objStudent.status = Convert.ToChar("N"); int updateprofilestatus = objStudent.updateprofilestatus(); //Call the add method to insert the suggestions record to database int newsuggestionid = objSuggestion.insertsuggestions(); lblMessage.Text = "Reply successfully sent!"; lblMessage.ForeColor = System.Drawing.Color.Red; } else { //Call the add method to insert the suggestions record to database int newsuggestionid = objSuggestion.insertsuggestions(); lblMessage.Text = "Reply successfully sent!"; lblMessage.ForeColor = System.Drawing.Color.Red; } } }
protected void Page_Load(object sender, EventArgs e) { if ((string)Session["LoginID"] != null) { //Create a new Mentor, Reply, Parent and ViewingRequest object MentorClass objMentor = new MentorClass(); MessageClass objMessage = new MessageClass(); ParentClass objParent = new ParentClass(); ViewingRequest objViewingRequest = new ViewingRequest(); //Read Mentor, Reply, Parent and ViewingRequest from query string objMentor.mentorId = Convert.ToInt32(Session["MentorId"]); objMessage.messageId = Convert.ToInt32(Request.QueryString["MessageId"]); objParent.parentId = Convert.ToInt32(Request.QueryString["ParentId"]); objViewingRequest.parentId = Convert.ToInt32(Request.QueryString["ParentId"]); //Load Mentor, Reply, Parent and ViewingRequest information to controls int mentorerrorCode = objMentor.getDetails(); int messageerrorCode = objMessage.getDetails(); int parenterrorCode = objParent.getDetails(); int viewingrequesterrorCode = objViewingRequest.getDetails(); if (mentorerrorCode == 0) { lblMentorName.Text = objMentor.mentorname; } else if (mentorerrorCode == -2) { lblMentorName.Text = "Unable to retrieve Mentor details for ID " + objMentor.mentorId; lblMentorName.ForeColor = System.Drawing.Color.Red; } if (messageerrorCode == 0) { lblMessage.Text = objMessage.text; lblOriginalMessage.Text = objMessage.text; } else if (messageerrorCode == -2) { lblMessage.Text = "Unable to retrieve Message details for ID " + objMessage.messageId; lblMessage.ForeColor = System.Drawing.Color.Red; } if (parenterrorCode == 0) { lblParentName.Text = objParent.parentName; lblOriginalParent.Text = objParent.parentName; } else if (parenterrorCode == -2) { lblParentName.Text = "Unable to retrieve Parent details for ID " + objParent.parentId; lblParentName.ForeColor = System.Drawing.Color.Red; } if (viewingrequesterrorCode == 0) { lblStudent.Text = objViewingRequest.studentName; } else if (viewingrequesterrorCode == -2) { lblStudent.Text = "Unable to retrieve Student details for ID " + objViewingRequest.parentId; lblStudent.ForeColor = System.Drawing.Color.Red; } displayReplyList(); } }