public static void GetDevisPrestataire(Devis d)
{
String sql = "SELECT devisid, prestataireid, dp.prix, nom FROM DevisPrestataire dp inner join Prestataire p on dp.prestataireid = p.id WHERE devisId=@devisId ";
using (MySqlCommand command = new MySqlCommand(sql, connection))
{
command.Connection.Open();
command.Parameters.AddWithValue("@devisid", d.Id);
using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
int devisid = dbReader.GetInt32(0);
int prestataireid = dbReader.GetInt32(1);
int prix = dbReader.GetInt32(2);
string nom = dbReader.GetString(3);
DevisPrestataire dp = new DevisPrestataire(devisid, prestataireid, prix)
{
Nom = nom
};
d.DevisPrestataires.Add(dp);
}
}
command.Connection.Close();
}
}
public static bool UpdateDevisPrestataire(DevisPrestataire p)
{
string sql = "UPDATE DevisPrestataire SET DevisId=@devisid, PrestataireId=@prestataireid"
+ " Where Id=@id ";
using (MySqlCommand cmd = new MySqlCommand(sql, connection))
{
cmd.Connection.Open();
cmd.Parameters.AddWithValue("@devisid", p.DevisId);
cmd.Parameters.AddWithValue("@prestataireid", p.PrestataireId);
bool result = cmd.ExecuteNonQuery() == 1;
cmd.Connection.Close();
return(result);
}
}
public static bool InsertDevisPrestataire(DevisPrestataire p)
{
string sql = "INSERT INTO DevisPrestataire(Id, DevisId, PrestataireId) " +
"VALUE (@id, @devisid, @prestataireid)";
using (MySqlCommand cmd = new MySqlCommand(sql, connection))
{
cmd.Connection.Open();
cmd.Parameters.AddWithValue("@id", null);
cmd.Parameters.AddWithValue("@devisid", p.DevisId);
cmd.Parameters.AddWithValue("@prestataireid", p.PrestataireId);
bool result = cmd.ExecuteNonQuery() == 1;
cmd.Connection.Close();
return(result);
}
}
