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);
}
public ILMPTemplateVO GetCutomTemplate(ILMPTemplateVO inilmptemplateVO)
{
ILMPTemplateVO ilmpTemplateVO;
try
{
ilmpTemplateVO = ilmpTemplateDao.GetCutomTemplate(inilmptemplateVO);
}
catch (CustomException e)
{
throw e;
}
return(ilmpTemplateVO);
}
public string AddILMPTemplate(ILMPTemplateVO inIlmpTemplateVO)
{
string status = "";
try
{
status = ilmpTemplateDao.AddILMPTemplate(inIlmpTemplateVO);
}
catch (CustomException e)
{
throw e;
}
return(status);
}
public ILMPTemplateVO GetTemplateForId(int templateId)
{
ILMPTemplateVO ilmpTemplateVO = new ILMPTemplateVO();
try
{
ilmpTemplateVO = ilmpTemplateDao.GetTemplateForId(templateId);
}
catch (CustomException e)
{
throw e;
}
return(ilmpTemplateVO);
}
public string AddILMPTemplate(ILMPTemplateVO inIlmpTemplateVO)
{
string status = "";
int ilmpTemplateId = 0;
try
{
DBConnection.conn.Open();
SqlCommand cmd = new SqlCommand("dbo.spAddILMPForTemplate", 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();
while (reader.Read())
{
ilmpTemplateId = int.Parse(reader[0].ToString());
}
reader.Close();
if (ilmpTemplateId > 0)
{
if (null != inIlmpTemplateVO.TemplateCourses && inIlmpTemplateVO.TemplateCourses.Count > 0)
{
foreach (TemplateCourseVO templateCourse in inIlmpTemplateVO.TemplateCourses)
{
String query = "INSERT INTO dbo.TemplateCourse (TemplateId,CourseCode,CourseType,Semester,Year,WorkshopId) VALUES (@TemplateId,@CourseCode,@CourseType,@Semester,@Year,@WorkshopId)";
SqlCommand cmd1 = new SqlCommand(query, DBConnection.conn);
cmd1.Parameters.AddWithValue("@TemplateId", ilmpTemplateId);
cmd1.Parameters.AddWithValue("@Semester", templateCourse.Semester);
cmd1.Parameters.AddWithValue("@Year", templateCourse.Year);
cmd1.Parameters.AddWithValue("@CourseType", templateCourse.CourseType);
cmd1.Parameters.AddWithValue("@CourseCode", templateCourse.CourseCode);
cmd1.Parameters.AddWithValue("@WorkshopId", templateCourse.WorkshopId);
// Add other parameters here
int result = cmd1.ExecuteNonQuery();
if (result <= 0)
{
status = "Template creation failed";
break;
}
else
{
status = "Template added successfully";
}
}
}
else
{
status = "No semesters found in the ILMP template";
}
}
else
{
status = "Error in addition";
}
}
catch (SqlException ex)
{
ExceptionUtility.LogException(ex, "Error Page");
if (ex.Number == 2627)
{
throw new CustomException("Template name already exists.Please provide different template name");
}
else
{
throw new CustomException("Error in template addition.Please contact system administrator");
}
}
finally
{
if (DBConnection.conn != null)
{
DBConnection.conn.Close();
}
}
return(status);
}
protected void btnGetTemplate_Click(object sender, EventArgs e)
{
ILMPTemplateVO ilmpTemplateVO = new ILMPTemplateVO();
ILMPTemplateVO inilmpTemplateVO = new ILMPTemplateVO();
if (ddProgramme.SelectedItem != null && ddProgramme.SelectedItem.Text != "" &&
ddMajor.SelectedItem != null && ddMajor.SelectedItem.Text != "" &&
ddTemplateName.SelectedItem != null && ddTemplateName.SelectedItem.Text != "")
{
inilmpTemplateVO.ProgrammeId = ddProgramme.SelectedItem.Value;
inilmpTemplateVO.MajorId = ddMajor.SelectedItem.Value;
inilmpTemplateVO.TemplateName = ddTemplateName.SelectedItem.Value;
if (txtCustomStudentId.Text != null && txtCustomStudentId.Text != "")
{
inilmpTemplateVO.StudentId = int.Parse(txtCustomStudentId.Text);
}
if (rbtnILMPTemplateType.SelectedItem.Text == "Custom")
{
ilmpTemplateVO = ilmpTemplateBO.GetCutomTemplate(inilmpTemplateVO);
}
else
{
ilmpTemplateVO = ilmpTemplateBO.GetTemplate(inilmpTemplateVO);
}
hfTemplateId.Value = ilmpTemplateVO.TemplateId.ToString();
if (ilmpTemplateVO.TemplateCourses.Count > 0)
{
DataTable dt = new DataTable();
DataRow dr = null;
//Define the Columns
dt.Columns.Add(new DataColumn("Column1", typeof(string)));
dt.Columns.Add(new DataColumn("Column2", typeof(string)));
dt.Columns.Add(new DataColumn("Column3", typeof(string)));
dt.Columns.Add(new DataColumn("Column4", typeof(string)));
dt.Columns.Add(new DataColumn("Column5", typeof(string)));
dt.Columns.Add(new DataColumn("Column6", typeof(string)));
dt.Columns.Add(new DataColumn("Column7", typeof(string)));
dt.Columns.Add(new DataColumn("Column8", typeof(string)));
//Add a Dummy Data on Initial Load
dr = dt.NewRow();
dt.Rows.Add(dr);
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
//Bind the DataTable to the Grid
gvIlmp.DataSource = dt;
gvIlmp.DataBind();
// AddNewRowToGrid();
DataTable dt1 = new DataTable();
DataRow dr1 = null;
dt1.Columns.Add(new DataColumn("Column1", typeof(string)));
//Add a Dummy Data on Initial Load
dr1 = dt1.NewRow();
dt1.Rows.Add(dr1);
//Store the DataTable in ViewState
ViewState["CurrentTableWorkshop"] = dt1;
//Bind the DataTable to the Grid
gvWorkshop.DataSource = dt1;
gvWorkshop.DataBind();
foreach (TemplateCourseVO templateCourseVO in ilmpTemplateVO.TemplateCourses)
{
if (templateCourseVO.WorkshopId == 0 && templateCourseVO.CourseCode != "")
{
AddNewRowToCourseGrid(templateCourseVO);
}
else
{
AddNewRowToWorkshopGrid(templateCourseVO.WorkshopId);
}
}
if ((gvIlmp.Rows[gvIlmp.Rows.Count - 1].Cells[0].FindControl("lblCourseCode") as Label).Text == "")
{
gvIlmp.Rows[gvIlmp.Rows.Count - 1].Visible = false;
}
if ((gvWorkshop.Rows[gvWorkshop.Rows.Count - 1].Cells[0].FindControl("lblWorkshop") as Label).Text == "")
{
gvWorkshop.Rows[gvWorkshop.Rows.Count - 1].Visible = false;
}
btnSave.Enabled = true;
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert(' There are no courses found in this template.Please choose different template ');", true);
//Response.Write("<script>alert(' There are no courses found in this template.Please choose different template ');</script>");
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert(' Please select Programme, Major and Title ');", true);
//Response.Write("<script>alert(' Please select Programme, Major and Title ');</script>");
}
}
