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