/// <summary> /// insère une ligne de la classe Participer dans la BDD /// </summary> /// <param name="uneParticipation">objet Participer</param> /// <returns>booléen 1 si bien inséré, 0 sinon</returns> public static int assignerInventoriste(Participer uneParticipation) { int insertCdeOK; int idInventoriste = uneParticipation.getIdinventoriste(); int idInventaire = uneParticipation.getIdInventaire(); string refProd = uneParticipation.getReferenceProduit(); string req = "INSERT INTO PARTICIPER VALUES( " + idInventaire + "," + idInventoriste + ",'" + refProd + "')"; ClassReq reqAssignerInventoriste = new ClassReq(req); insertCdeOK = reqAssignerInventoriste.ExecuteIUD(); return(insertCdeOK); }
private void delete(Participer p) { using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) { cnx.Open(); using (MySqlCommand cmd = new MySqlCommand("delete from Participer where idCourse=@idC and idLapin=@idL", cnx)) { cmd.Parameters.Add(new MySqlParameter("@idC", MySqlDbType.Int32)); cmd.Parameters["@idC"].Value = p.IdCourse; cmd.Parameters.Add(new MySqlParameter("@idL", MySqlDbType.Int32)); cmd.Parameters["@idL"].Value = p.IdLapin; cmd.ExecuteNonQuery(); } } }
private void update(Participer p) { using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) { cnx.Open(); using (MySqlCommand cmd = new MySqlCommand("update Participer set gagnant=1 where idCourse=@idCourse and idLapin=@idLapin", cnx)) { cmd.Parameters.Add(new MySqlParameter("@idCourse", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@idLapin", MySqlDbType.Int32)); cmd.Parameters["@idCourse"].Value = p.IdCourse; cmd.Parameters["@idLapin"].Value = p.IdLapin; cmd.ExecuteNonQuery(); } } p.State1 = state.unChanged; }
private void insert(Participer p) { using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) { cnx.Open(); using (MySqlCommand cmd = new MySqlCommand("insert into Participer(idCourse,Gagnant,idLapin) values(@idCourse,@Gagnant,@idLapin)", cnx)) { cmd.Parameters.Add(new MySqlParameter("@idCourse", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@idLapin", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@Gagnant", MySqlDbType.Int32)); cmd.Parameters["@idCourse"].Value = p.IdCourse; cmd.Parameters["@idLapin"].Value = p.IdLapin; cmd.Parameters["@Gagnant"].Value = p.Gagnant; cmd.ExecuteNonQuery(); } } p.State1 = (state.unChanged); }
public void SaveChanges(List <Participer> part) { for (int i = 0; i < part.Count; i++) { Participer p = part[i]; switch (p.State1) { case state.added: this.insert(p); break; case state.modified: this.update(p); break; case state.deleted: this.delete(p); break; } } }