// LoanDTO - Select All public static List <LoanDTO> getAllLoanDTO() { try { // Begin declaration string storeProcedure = "getAllLoanDTO"; List <LoanDTO> listLoansDTO = new List <LoanDTO>(); //// Dataset //DataSet ds = new DataSet(); //using (Helper db = new Helper()) //{ // using (ds = db.ExecDataSet(storeProcedure)); //} // Set command using (Helper db = new Helper()) { using (SqlDataReader reader = db.ExecDataReader(storeProcedure)) { while (reader.Read()) { LoanDTO loan = new LoanDTO(); // Get the columns of the row n loan.CopyId = reader.GetInt32((reader.GetOrdinal("CopyId"))); loan.LoanId = reader.GetInt32((reader.GetOrdinal("LoanId"))); loan.LoanDate = reader.GetDateTime((reader.GetOrdinal("LoanDate"))); loan.DeliveryDate = reader.GetDateTime((reader.GetOrdinal("DeliveryDate"))); loan.Name = reader.GetString((reader.GetOrdinal("Name"))); loan.LastName = reader.GetString((reader.GetOrdinal("LastName"))); loan.Dni = reader.GetInt32((reader.GetOrdinal("Dni"))); loan.Title = reader.GetString((reader.GetOrdinal("Title"))); loan.Author = reader.GetString((reader.GetOrdinal("Author"))); loan.Section = reader.GetString((reader.GetOrdinal("Section"))); // Save the row n in a list listLoansDTO.Add(loan); } } } return(listLoansDTO); } catch (Exception e) { throw e; } }
// LoanDTO - Select by Id public static LoanDTO getLoanDTOById(int _loanId) { try { // Begin declaration string storeProcedure = "getLoanDTOByCopyId"; LoanDTO loan = new LoanDTO(); // End declaration // Set parameters SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@LoanId", _loanId); ////DataSet set; //DataSet ds = new DataSet(); //using (Helper db = new Helper()) //{ // using (ds = db.ExecDataSet(storeProcedure, parameters)); //} // Set command with procedure and parameters using (Helper db = new Helper()) { using (SqlDataReader reader = db.ExecDataReader(storeProcedure, parameters)) { if (reader.Read()) { loan.CopyId = reader.GetInt32((reader.GetOrdinal("CopyId"))); loan.LoanId = reader.GetInt32((reader.GetOrdinal("LoanId"))); loan.LoanDate = reader.GetDateTime((reader.GetOrdinal("LoanDate"))); loan.DeliveryDate = reader.GetDateTime((reader.GetOrdinal("DeliveryDate"))); loan.Name = reader.GetString((reader.GetOrdinal("Name"))); loan.LastName = reader.GetString((reader.GetOrdinal("LastName"))); loan.Dni = reader.GetInt32((reader.GetOrdinal("Dni"))); loan.Title = reader.GetString((reader.GetOrdinal("Title"))); loan.Author = reader.GetString((reader.GetOrdinal("Author"))); loan.Section = reader.GetString((reader.GetOrdinal("Section"))); } } } return(loan); } catch (Exception e) { throw e; } }