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