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();
}
