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;
}
}
}
}