public int Insert(Remboursement model)
{
int result = -1;
connexion.Open(); using (SqlCommand cmd = connexion.CreateCommand()) {
result = this.ExecuteInsert(cmd, model);
} connexion.Close();
return(result);
}
private int ExecuteInsert(SqlCommand cmd, Remboursement model)
{
cmd.CommandText = "INSERT INTO Remboursement VALUES(@val1, @val2, @val3, @val4, @val5, @val6)";
cmd.Parameters.AddWithValue("@val1", model.Id);
cmd.Parameters.AddWithValue("@val2", model.Pret.ToString());
cmd.Parameters.AddWithValue("@val3", model.DateRemboursement);
cmd.Parameters.AddWithValue("@val4", model.Montant);
cmd.Parameters.AddWithValue("@val5", model.Interet);
cmd.Parameters.AddWithValue("@val6", model.Fait);
return(cmd.ExecuteNonQuery());
}
// METHODS :
private int ExecuteUpdate(SqlCommand cmd, Remboursement model)
{
cmd.CommandText = "UPDATE Remboursement SET pret=@val1, dateRemboursement=@val2, montant=@val3, interet=@val4, fait=@val5 WHERE id=@val6";
cmd.Parameters.AddWithValue("@val1", model.Pret.ToString());
cmd.Parameters.AddWithValue("@val2", model.DateRemboursement);
cmd.Parameters.AddWithValue("@val3", model.Montant);
cmd.Parameters.AddWithValue("@val4", model.Interet);
cmd.Parameters.AddWithValue("@val5", model.Fait);
cmd.Parameters.AddWithValue("@val6", model.Id);
return(cmd.ExecuteNonQuery());
}
public Remboursement SelectOne(String condition)
{
Remboursement result = null;
if (connexion.State == ConnectionState.Open)
{
connexion = new SqlConnection(connexion.ConnectionString + "Password=itu");
}
connexion.Open();
using (SqlCommand cmd = connexion.CreateCommand()) {
result = this.ExecuteSelectOne(cmd, condition);
} connexion.Close();
return(result);
}
private Remboursement ExecuteSelectOne(SqlCommand cmd, String condition)
{
Remboursement result = null;
string cond = "";
if (condition != null)
{
cond = " " + condition;
}
cmd.CommandText = "SELECT * FROM Remboursement" + cond;
using (SqlDataReader reader = cmd.ExecuteReader()) {
if (reader.Read())
{
result = this.Map(reader);
}
} return(result);
}
// METHODS :
public bool Equals(Remboursement cmp)
{
return(this.id == cmp.Id);
}