public static Bon_Cmd GetBonCmd(int PretID) { Bon_Cmd bon_cmd = new Bon_Cmd(); SqlConnection sqlConnection = new SqlConnection(constr); sqlConnection.Open(); String Command = "SELECT * FROM " + table + " WHERE pretsID = @id ;"; SqlCommand sqlCommand = new SqlCommand(Command, sqlConnection); using (sqlCommand) { sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.AddWithValue("@id", PretID); SqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { bon_cmd.setId((int)dataReader[0]); bon_cmd.setNum((int)dataReader[1]); bon_cmd.setDate((DateTime)dataReader[5]); int id = (int)dataReader[2]; bon_cmd.setFournisseur(ConnectionFournisseur.GetFournisseur(id)); bon_cmd.setProduit((String)dataReader[3]); bon_cmd.setPrix(Convert.ToDouble(dataReader[4])); bon_cmd.setdemand_id((int)dataReader[7]); bon_cmd.setprets_id((int)dataReader[6]); } dataReader.Close(); } sqlCommand.Dispose(); sqlConnection.Close(); return(bon_cmd); }
public static void DeleteBonCmd(Bon_Cmd facture) { SqlConnection sqlConnection = new SqlConnection(constr); sqlConnection.Open(); String command = "DELETE FROM " + table + " WHERE Id=@id ;"; SqlCommand sqlCommand = new SqlCommand(command, sqlConnection); using (sqlCommand) { sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.AddWithValue("@id", facture.getId()); sqlCommand.ExecuteNonQuery(); } sqlCommand.Dispose(); sqlConnection.Close(); }
public static void AddBonCmd(Bon_Cmd bon_Cmd) { SqlConnection sqlConnection = new SqlConnection(constr); sqlConnection.Open(); String command = "INSERT INTO " + table + " VALUES(@Id , @num ,@fournisseur " + ",@produit ,@prix,@date, @pretID" + ",@Demand);"; SqlCommand sqlCommand = new SqlCommand(command, sqlConnection); using (sqlCommand) { sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.AddWithValue("@Id", bon_Cmd.getId()); sqlCommand.Parameters.AddWithValue("@num", bon_Cmd.getNum()); sqlCommand.Parameters.AddWithValue("@date", bon_Cmd.getDate()); sqlCommand.Parameters.AddWithValue("@fournisseur", bon_Cmd.GetFournisseur().Id); if (bon_Cmd.getprets_id() != 0) { sqlCommand.Parameters.AddWithValue("@pretID", bon_Cmd.getprets_id()); } else { sqlCommand.Parameters.AddWithValue("pretID", DBNull.Value); } sqlCommand.Parameters.AddWithValue("@produit", bon_Cmd.getproduit()); if (bon_Cmd.getdemand_id() != 0) { sqlCommand.Parameters.AddWithValue("@Demand", bon_Cmd.getdemand_id()); } else { sqlCommand.Parameters.AddWithValue("@Demand", DBNull.Value); } sqlCommand.Parameters.AddWithValue("@prix", bon_Cmd.getPrix()); sqlCommand.ExecuteNonQuery(); } sqlCommand.Dispose(); sqlConnection.Close(); }
/*-------------------- * * * --------------------------**/ public void setBon_cmd(Bon_Cmd bon_Cmd) { this.BonCmd = bon_Cmd; }