Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }