public static List <ImprumutModel> GetAllLaondsByUserId(int userId, string connectionString)
{
List <ImprumutModel> imprumuturi = new List <ImprumutModel>();
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string cmdText = "Select * from Imprumuturi where IdCititor = @id";
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
cmd.Parameters.AddWithValue("id", userId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ImprumutModel imprumut = new ImprumutModel
{
IdImprumut = (int)reader["IdImprumut"],
IdCititor = (int)reader["IdCititor"],
IdCarte = (int)reader["IdCarte"],
DataImprumut = (DateTime)reader["DataImprumut"]
};
try
{
imprumut.DataRestituire = (DateTime)reader["DataRestituire"];
}
catch { }
imprumut.Carte = GetBookById(imprumut.IdCarte, connectionString);
imprumuturi.Add(imprumut);
}
}
}
}
return(imprumuturi);
}
public static List <ImprumutModel> GetImprumuturiAn(DateTime anStart, DateTime anEnd)
{
List <ImprumutModel> imprumuturi = new List <ImprumutModel>();
int i = 0;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
string cmdText = "Select c.id_carte, c.titlu, c.autor, i.data_imprumut from carti c, imprumut i where c.id_carte = i.id_carte and i.data_imprumut >= @anStart and i.data_imprumut <=@anEnd";
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
cmd.Parameters.AddWithValue("anStart", anStart);
cmd.Parameters.AddWithValue("anEnd", anEnd);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
i++;
DateTime date = (DateTime)reader[3];
ImprumutModel imprumut = new ImprumutModel
{
Index = i,
IDCarte = (int)reader[0],
Titlu = (string)reader[1],
Autor = (string)reader[2],
DataImprumut = date,
DataDisponibilitate = date.AddDays(30)
};
imprumuturi.Add(imprumut);
}
}
}
}
return(imprumuturi);
}
