public void addSpeaker(int speakerId, string speakerCode, string speakerName, decimal SpeakerRating, string speakerNationality, string speakerPicture)
        {
            var idx      = _electriccastleContext.DictionarySpeaker.Max(x => x.DictionarySpeakerId) + 1;
            var speakers = new DictionarySpeaker {
                DictionarySpeakerId = idx, SpeakerCode = speakerCode, DictionarySpeakerName = speakerName, Rating = SpeakerRating, Nationality = speakerNationality, Picture = speakerPicture
            };

            _electriccastleContext.DictionarySpeaker.Add(speakers);
            _electriccastleContext.SaveChanges();
        }
        public void editSpeaker(int speakerId, string speakerCode, string speakerName, decimal SpeakerRating, string speakerNationality, string speakerPicture)
        {
            DictionarySpeaker updatespeaker = _electriccastleContext.DictionarySpeaker.Where(x => x.DictionarySpeakerId == speakerId).FirstOrDefault();

            updatespeaker.SpeakerCode           = speakerCode;
            updatespeaker.DictionarySpeakerName = speakerName;
            updatespeaker.Rating      = SpeakerRating;
            updatespeaker.Nationality = speakerNationality;
            updatespeaker.Picture     = speakerPicture;

            _electriccastleContext.DictionarySpeaker.Update(updatespeaker);
            _electriccastleContext.SaveChanges();
        }