public void Delete(int id, int iduser) { ParticipantRepository service = new ParticipantRepository(); Command cmd = new Command("DELETE FROM Event WHERE IdEvent = @Id and Admin = @Iduser"); cmd.AddParameter("@Id", id); cmd.AddParameter("@Iduser", iduser); service.DeleteAuto(id); _Connection.ExecuteNonQuery(cmd); }
public int Create(Event entity) { ParticipantRepository service = new ParticipantRepository(); Command cmd = new Command("AddEvent", true); cmd.AddParameter("@Name", entity.Name); cmd.AddParameter("@Time", entity.Time); cmd.AddParameter("@Admin", entity.Admin); cmd.AddParameter("IdCountry", entity.IdCountry); cmd.AddParameter("IdCityPostalCode", entity.IdCityPostalCode); cmd.AddParameter("IdLoisir", entity.IdLoisir); int id = (int)_Connection.ExecuteScalar(cmd); service.CreatePartiAuto(id, entity.Admin); return(id); }