public ILMPTemplateVO GetTemplate(ILMPTemplateVO inilmptemplateVO) { ILMPTemplateVO ilmpTemplateVO = new ILMPTemplateVO(); try { DBConnection.conn.Open(); SqlCommand cmd = new SqlCommand("dbo.spGetILMPTemplate", DBConnection.conn); cmd.Parameters.AddWithValue("@ProgrammeID", inilmptemplateVO.ProgrammeId); cmd.Parameters.AddWithValue("@MajorID", inilmptemplateVO.MajorId); cmd.Parameters.AddWithValue("@TemplateName", inilmptemplateVO.TemplateName); cmd.Parameters.AddWithValue("@StudentID", inilmptemplateVO.StudentId); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { List <TemplateCourseVO> templateCourses = new List <TemplateCourseVO>(); TemplateCourseVO ilmpTemplateCourseVO; while (reader.Read()) { ilmpTemplateCourseVO = new TemplateCourseVO(); ilmpTemplateVO.TemplateId = int.Parse(reader["TemplateId"].ToString()); ilmpTemplateCourseVO.Semester = int.Parse(reader["Semester"].ToString()); ilmpTemplateCourseVO.Year = int.Parse(reader["Year"].ToString()); ilmpTemplateCourseVO.TemplateCourseId = int.Parse(reader["TemplateCourseID"].ToString()); ilmpTemplateCourseVO.CourseCode = reader["CourseCode"].ToString(); ilmpTemplateCourseVO.WorkshopId = int.Parse(reader["WorkshopID"].ToString()); templateCourses.Add(ilmpTemplateCourseVO); } ilmpTemplateVO.TemplateName = inilmptemplateVO.TemplateName; ilmpTemplateVO.ProgrammeId = inilmptemplateVO.ProgrammeId; ilmpTemplateVO.MajorId = inilmptemplateVO.MajorId; ilmpTemplateVO.StudentId = inilmptemplateVO.StudentId; ilmpTemplateVO.TemplateCourses = templateCourses; } else { // return no templates message } reader.Close(); } catch (SqlException e) { ExceptionUtility.LogException(e, "Error Page"); } finally { if (DBConnection.conn != null) { DBConnection.conn.Close(); } } return(ilmpTemplateVO); }
private void AddNewRowToCourseGrid(TemplateCourseVO templateCourseVO) { if (ViewState["CurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { drCurrentRow = dtCurrentTable.NewRow(); //add new row to DataTable dtCurrentTable.Rows.Add(drCurrentRow); //Store the current data to ViewState ViewState["CurrentTable"] = dtCurrentTable; for (int i = 0; i < dtCurrentTable.Rows.Count - 1; i++) { if (i != dtCurrentTable.Rows.Count - 2) { } else { DropDownList ddl1 = (DropDownList)gvIlmp.Rows[i].Cells[2].FindControl("ddSemester"); DropDownList ddl2 = (DropDownList)gvIlmp.Rows[i].Cells[3].FindControl("ddYear"); // Update the DataRow with the DDL Selected Items dtCurrentTable.Rows[i]["Column1"] = templateCourseVO.CourseCode; CourseProgrammeVO coursePgmVO = new CourseProgrammeVO(); coursePgmVO.CourseCode = templateCourseVO.CourseCode; coursePgmVO.ProgrammeId = ddProgramme.SelectedItem.Value; coursePgmVO.MajorId = ddMajor.SelectedItem.Value; ILMPCourseGridVO ilmpCourseGridVO = new ILMPCourseGridVO(); // for custom template, course may not be in same major selected if (rbtnILMPTemplateType.SelectedItem.Text == "Generic") { ilmpCourseGridVO = courseBO.GetCourseDetailsForTemplate(coursePgmVO); dtCurrentTable.Rows[i]["Column2"] = ilmpCourseGridVO.CourseType; dtCurrentTable.Rows[i]["Column5"] = ilmpCourseGridVO.Title; dtCurrentTable.Rows[i]["Column6"] = ilmpCourseGridVO.Credits; dtCurrentTable.Rows[i]["Column7"] = ilmpCourseGridVO.Level; dtCurrentTable.Rows[i]["Column8"] = ilmpCourseGridVO.Prerequisites; } else { CourseVO courseVO = courseBO.GetCourseDetailsForCourseCode(coursePgmVO.CourseCode); dtCurrentTable.Rows[i]["Column2"] = "COM"; dtCurrentTable.Rows[i]["Column5"] = courseVO.Title; dtCurrentTable.Rows[i]["Column6"] = courseVO.Credits; dtCurrentTable.Rows[i]["Column7"] = courseVO.Level; dtCurrentTable.Rows[i]["Column8"] = courseVO.Prerequisites.AllPrerequisites; } // fills the semester dropdown from courseoffering. If there is any courseoffering, by default first value coming from db will be selected in semester dropdown FillSemesterDropDown(ddl1, coursePgmVO.CourseCode); // checks whether courseoffering is present by checking semster default selected value if (ddl1.SelectedItem != null && ddl1.SelectedItem.Text != "Select") { dtCurrentTable.Rows[i]["Column3"] = templateCourseVO.Semester; //set the selected semester of dropdown to semester from ILMP template FillYearDropDown(ddl2, coursePgmVO.CourseCode, int.Parse(ddl1.SelectedItem.Text)); } if (ddl2.SelectedItem != null) { dtCurrentTable.Rows[i]["Column4"] = templateCourseVO.Year;//set the selected year of dropdown to year from ILMP template } } } //Rebind the Grid with the current data gvIlmp.DataSource = dtCurrentTable; gvIlmp.DataBind(); } } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert(' ViewState is null ');", true); // Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreviousDataInCourseGrid(); }