protected void btnUpdateStudent_Click(object sender, EventArgs e) { try { int studentID = Convert.ToInt32(txtStudentID.Text.Trim()); string firstName = txtFirstName.Text.Trim(); string lastName = txtLastName.Text.Trim(); string programmeId = ddlStudentProgramme.SelectedValue.Trim(); string emailID = txtEmailID.Text.Trim(); string status = ddlStatus.Text.Trim(); DateTime updatedDTM = DateTime.Now; string active = ""; if (ddlStatus.Text != "Studying") { active = "No"; } else { active = "Yes"; } if (!txtEmailID.Text.Trim().EndsWith("@ess.ais.ac.nz")) { Response.Write("<script>alert('Please enter valid email ess.ais.ac.nz');</script>"); } StudentVO studentVO = new StudentVO(studentID, firstName, lastName, status, updatedDTM); UserVO userVO = new UserVO(studentID, emailID, active); if (active == "No" || status == "Withdrawn" || status == "Graduated" || status == "Postponed") { ILMPBO ilmpBO = new ILMPBO(); bool ilmpUpdationStatus = ilmpBO.UpdateILMPStatusForStudent(studentID, "No"); } if (txtFirstName.Text == "" || txtLastName.Text == "" || txtEmailID.Text == "" || lbMajor.Items.Count == 0) { Response.Write("<script>alert('Please check First Name, Last Name, Email and Major is filled');</script>"); } else if (studentBO.UpdateStudent(studentVO) && userBO.UpdateUser(userVO)) { DBConnection.conn.Open(); string query = "DELETE FROM StudentMajor WHERE StudentID=" + studentID; SqlCommand cmd2 = new SqlCommand(query, DBConnection.conn); cmd2.ExecuteNonQuery(); DBConnection.conn.Close(); for (int i = 0; i < lbMajor.Items.Count; i++) { ListItem lmajor = lbMajor.Items[i]; StudentMajorVO studentMajorVO = new StudentMajorVO(studentID, programmeId, lmajor.Value, active); StudentMajorBO studentMajorBO = new StudentMajorBO(); if (studentMajorBO.AddStudent(studentMajorVO)) { Response.Write("<script>alert('Student updated successfully');</script>"); } else { Response.Write("<script>alert('Error in updating student major');</script>"); } } } else { Response.Write("<script>alert('Student update Fail');</script>"); } } catch (CustomException ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } catch (SqlException ex) { ExceptionUtility.LogException(ex, "Error Page"); Response.Write("<script>alert('" + ex.Message + "');</script>"); } catch (Exception ex) { ExceptionUtility.LogException(ex, "Error Page"); Response.Write("<script>alert('Student updation failed');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { ILMPVO ilmpVO = new ILMPVO(); try { ilmpVO.Name = txtName.Text; if (txtStudentId.Text.Trim() != "") { try { ilmpVO.StudentId = Int32.Parse(txtStudentId.Text); } catch (ParseException) { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert(' StudentId is not valid ');", true); // Response.Write("<script>alert('StudentId is not valid');</script>"); return; } } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert(' Please enter student id');", true); // Response.Write("<script>alert('Please enter student id');</script>"); return; } ilmpVO.Active = ddActive.SelectedItem.Text; ilmpVO.Description = txtDescription.Text; List <ILMPCourseVO> templateCourses = new List <ILMPCourseVO>(); if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; // storing the grid values in KeyValue Pair because every semester will have multiple entries, it should be consolidated to store in database if (dt.Rows.Count > 0) { ILMPCourseVO ilmpCourseVO = new ILMPCourseVO(); for (int i = 0; i < dt.Rows.Count - 1; i++) { ilmpCourseVO = new ILMPCourseVO(); Label courseCode = (Label)gvIlmp.Rows[i].Cells[0].FindControl("lblCourseCode"); DropDownList ddl1 = (DropDownList)gvIlmp.Rows[i].Cells[1].FindControl("ddCourseType"); DropDownList ddl2 = (DropDownList)gvIlmp.Rows[i].Cells[2].FindControl("ddSemester"); DropDownList ddl3 = (DropDownList)gvIlmp.Rows[i].Cells[3].FindControl("ddYear"); string courseType = ddl1.SelectedItem.Text; int semester = Int32.Parse(ddl2.SelectedItem.Text); int year = 0; if (ddl3.SelectedItem.Text != null && ddl3.SelectedItem.Text != "Select") { year = Int32.Parse(ddl3.SelectedItem.Text); } ilmpCourseVO.CourseCode = courseCode.Text; ilmpCourseVO.Semester = semester; ilmpCourseVO.Year = year; ilmpCourseVO.CourseType = courseType; templateCourses.Add(ilmpCourseVO); } ilmpVO.IlmpCourses = templateCourses; ilmpVO.TemplateId = int.Parse(hfTemplateId.Value); ILMPBO ilmpBO = new ILMPBO(); string status = ilmpBO.AddILMP(ilmpVO); ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + status + "');", true); //Response.Write("<script>alert('" + status + "');</script>"); /* if (status.Contains("success")) * { * // btnSave.Enabled = false; * } * else * { * btnSave.Enabled = true; * }*/ } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('There are no courses added in ILMP');", true); // Response.Write("<script>alert('There are no courses added in ILMP');</script>"); } } } catch (CustomException ex) { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + ex.Message + "');", true); } }