void DeleteSubscriber(string publicKey) { try { using (var db = new SubscriberModel()) { var subtoremove = db.Subscribers.SingleOrDefault(x => x.PublicKey == publicKey); //returns a single item. if (subtoremove != null) { db.Subscribers.Remove(subtoremove); db.SaveChanges(); } } } catch (DbEntityValidationException ex) { foreach (var errors in ex.EntityValidationErrors) { foreach (var validationError in errors.ValidationErrors) { // get the error message string errorMessage = validationError.ErrorMessage; } } } }
void SaveData(string newname, string privateKey, string publicKey, string header, string message, string clientDomain, string endPoint) { try { using (var db = new SubscriberModel()) { var query = from st in db.Subscribers where st.PublicKey == publicKey select st; var sub = query.FirstOrDefault <Subscriber>(); if (sub == null) { var subData = new Subscriber { Name = newname.Trim(), PrivateKey = privateKey.Trim(), PublicKey = publicKey.Trim(), Header = header.Trim(), Message = message.Trim(), URL = clientDomain.Trim(), Endpoint = endPoint.Trim() }; db.Subscribers.Add(subData); db.SaveChanges(); // Display all } } } catch (DbEntityValidationException ex) { foreach (var errors in ex.EntityValidationErrors) { foreach (var validationError in errors.ValidationErrors) { // get the error message string errorMessage = validationError.ErrorMessage; } } } }