public ILMPDetailsVO GetTemplateProgrammeForIlmpId(int ilmpId)
{
ILMPDetailsVO ilmpDetails = new ILMPDetailsVO();
try
{
ilmpDetails = ilmpDao.GetTemplateProgrammeForIlmpId(ilmpId);
}
catch (CustomException e)
{
throw e;
}
return(ilmpDetails);
}
public ILMPDetailsVO GetTemplateProgrammeForIlmpId(int ilmpId)
{
ILMPDetailsVO ilmpDetails = new ILMPDetailsVO();
try
{
DBConnection.conn.Open();
string query = "select it.TemplateId, i.StudentID, sm.ProgrammeID, sm.MajorID, it.TemplateName " +
"from dbo.Ilmp i " +
"INNER JOIN dbo.StudentMajor sm on sm.StudentId = i.StudentID " +
"INNER JOIN dbo.IlmpTemplate it on it.TemplateID = i.TemplateId " +
"WHERE sm.Active='Yes' and i.ilmpid=@IlmpId ";
SqlCommand cmd = new SqlCommand(query, DBConnection.conn);
cmd.Parameters.AddWithValue("@IlmpId", ilmpId);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ilmpDetails.StudentId = int.Parse(reader["StudentID"].ToString());
ilmpDetails.IlmpId = ilmpId;
ilmpDetails.TemplateId = int.Parse(reader["TemplateId"].ToString());
ilmpDetails.ProgrammeId = reader["ProgrammeID"].ToString();
ilmpDetails.MajorId = reader["MajorID"].ToString();
ilmpDetails.TemplateName = reader["TemplateName"].ToString();
}
}
}
catch (SqlException ex)
{
ExceptionUtility.LogException(ex, "Error Page");
throw ex;
}
finally
{
if (DBConnection.conn != null)
{
DBConnection.conn.Close();
}
}
return(ilmpDetails);
}
