public static void save(Versement versement)
{
if (versement.Id == 0)
{
OdbcCommand cmd = new OdbcCommand("insert into versement (Numero, Montant,Description,Date,Carte,Admin) values(?,?,?,?,?,?)", AccesBd.getConnection());
cmd.Parameters.Add("@Numero", OdbcType.VarChar).Value = versement.Numero;
cmd.Parameters.Add("@Montant", OdbcType.Double).Value = versement.Montant;
cmd.Parameters.Add("@Description", OdbcType.VarChar).Value = versement.Description;
cmd.Parameters.Add("@Date", OdbcType.DateTime).Value = versement.Date;
cmd.Parameters.Add("@carte", OdbcType.VarChar).Value = versement.carte.Numero;
cmd.Parameters.Add("@admin", OdbcType.VarChar).Value = versement.admin.Numero;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
else
{
OdbcCommand cmd = new OdbcCommand("update versement set Numero=?,Montant=?,Description=?,Date=?,Carte=?,Admin=? where Id=?", AccesBd.getConnection());
cmd.Parameters.Add("@Date", OdbcType.VarChar).Value = versement.Numero;
cmd.Parameters.Add("@Montant", OdbcType.Double).Value = versement.Montant;
cmd.Parameters.Add("@Description", OdbcType.VarChar).Value = versement.Description;
cmd.Parameters.Add("@Date", OdbcType.DateTime).Value = versement.Date;
cmd.Parameters.Add("@carte", OdbcType.VarChar).Value = versement.carte.Numero;
cmd.Parameters.Add("@admin", OdbcType.VarChar).Value = versement.admin.Numero;
cmd.Parameters.Add("@id", OdbcType.Int).Value = versement.Id;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
public void Model2Form(Versement vers)
{
versement = vers;
txtNumero.Text = versement.Numero;
txtMontant.Text = versement.Montant.ToString();
txtDescrip.Text = versement.Description;
cbDate.Value = versement.Date;
cbNumeroCarte.GetItemText(versement.carte.Numero);
}
public static List <Versement> findAll()
{
List <Versement> versements = new List <Versement>();
OdbcCommand cmd = new OdbcCommand("select Id from versement", AccesBd.getConnection());
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Versement versement = find(dr.GetInt32(0));
versements.Add(versement);
}
cmd.Dispose();
return(versements);
}
public static List <Versement> findby(string tab, string val)
{
List <Versement> versements = new List <Versement>();
OdbcCommand cmd = new OdbcCommand("select Id from versement where " + tab + " LIKE('%" + val + "%') ", AccesBd.getConnection());
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Versement chau = find(dr.GetInt32(0));
versements.Add(chau);
}
cmd.Dispose();
return(versements);
}
private void dgVersement_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
for (int i = 0; i < dgVersement.RowCount; i++)
{
if ((bool)dgVersement.Rows[i].Selected)
{
AddVersemForm adf = new AddVersemForm(administrateur);
Versement bus = VersementDao.findByNumero(dgVersement.Rows[i].Cells[0].Value.ToString());
adf.LabelTitle.Text = "MODIFICATION VERSEMENT";
adf.Model2Form(bus);
adf.ShowDialog();
}
}
}
public static Versement findByNumero(string numero)
{
Versement versement = null;
OdbcCommand cmd = new OdbcCommand("select * from versement where Numero=?", AccesBd.getConnection());
cmd.Parameters.Add("@numero", OdbcType.VarChar).Value = numero;
OdbcDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
versement = new Versement {
Id = dr.GetInt32(0), Numero = dr.GetString(1), Montant = dr.GetDouble(3), Description = dr.GetString(2), Date = dr.GetDateTime(4), carte = CarteDao.findByNumero(dr.GetString(5)), admin = AdminDao.findByNumero(dr.GetString(6))
};
}
cmd.Dispose();
return(versement);
}
private void btnChange_Click(object sender, EventArgs e)
{
if (DroitDao.findDroit(administrateur.Numero, "Versement", "Modifier"))
{
for (int i = 0; i < dgVersement.RowCount; i++)
{
if ((bool)dgVersement.Rows[i].Selected)
{
AddVersemForm adf = new AddVersemForm(administrateur);
Versement bus = VersementDao.findByNumero(dgVersement.Rows[i].Cells[0].Value.ToString());
adf.LabelTitle.Text = "MODIFICATION VERSEMENT";
adf.Model2Form(bus);
adf.ShowDialog();
}
}
}
else
{
MessageBox.Show("Vous n\'avez pas ce droit");
}
}
