public Student1098TReport GetStudent1098TPdf(int studentNo)
{
var report = new Student1098TReport
{
StudentNo = studentNo,
PdfData = new byte[] { 0x12, 0x0F, 0xF0 }
};
return(report);
}
public Student1098TReport GetStudent1098TPDF(int studentNo)
{
Student1098TReport student1098TPDF = null;
try
{
student1098TPDF = _repository.GetStudent1098TPdf(studentNo);
}
catch (SqlException sqlEx)
{
throw new Exception(EnumUtils.GetStringValue(ErrorMessage.UserDefinedMessage), sqlEx);
}
catch (Exception ex)
{
throw new Exception(EnumUtils.GetStringValue(ErrorMessage.UserDefinedMessage), ex);
}
return(student1098TPDF);
}
public Student1098TReport GetStudent1098TPdf(int studentNo)
{
var query = new StringBuilder();
query.AppendFormat("SELECT * FROM Student1098TPDF WHERE StudentNo = {0}", studentNo);
var report = new Student1098TReport();
using (var reader = this.ExecuteReader(CommandType.Text, query.ToString()))
{
while (reader.Read())
{
int colIndex = -1;
report.StudentNo = Convert.ToInt32(reader[++colIndex]);
report.PdfData = reader[++colIndex] as byte[];
}
}
return(report);
}
