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