public void DeleteEmprunt(Emprunt emp)
{
SqlConnection connect = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Jean\Downloads\EasyBorrowing.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand command = new SqlCommand("DELETE FROM Emprunts WHERE ID = @id", connect);
command.Parameters.AddWithValue("@id", emp.Id);
connect.Open();
command.ExecuteNonQuery();
connect.Close();
}
public void AddModifyEmprunt(Emprunt emp)
{
SqlConnection connect = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Jean\Downloads\EasyBorrowing.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand command = new SqlCommand("UPDATE Emprunts SET ID = @id, ID_LIVRE = @idli, ID_EMPRUNTEUR = @idemp, DATE_DEBUT = @Date debut, DATE_FIN = @datefin, DATE_FIN_PREVUE = @datefinprevu FROM (SELECT ID FROM Emprunts WHERE ID = @id", connect);
command.Parameters.AddWithValue("@id", emp.Id);
command.Parameters.AddWithValue("@idli", emp.Livre.Id);
command.Parameters.AddWithValue("@idemp", emp.Emprunteur.Id);
command.Parameters.AddWithValue("@Datedebut", emp.DateDebut);
command.Parameters.AddWithValue("@datefin", emp.DateFin);
command.Parameters.AddWithValue("@datefinprevu", emp.DateDebut.AddDays(14));
connect.Open();
command.ExecuteNonQuery();
connect.Close();
}
public static List <Emprunt> getEmprunt()
{
List <Emprunt> res = new List <Emprunt>();
DataTable dt = Datafill("SELECT * FROM Emprunts");
foreach (DataRow dr in dt.Rows)
{
Emprunt n = new Emprunt(
(DateTime)dr["DATE_DEBUT"],
(DateTime)dr["DATE_FIN"],
getEmprunteurByID((int)dr["ID_EMPRUNTEUR"]),
getLivreByID((int)dr["ID_LIVRE"])
);
}
return(res);
}