public void DBWrite(string authUsername, string key, string value)
{
using (var entities = new SIPSorceryEntities())
{
var existingEntry = entities.DialPlanData.Where(x => x.DataOwner == authUsername && x.DataKey == key).SingleOrDefault();
if (existingEntry != null)
{
existingEntry.DataValue = value;
}
else
{
var newEntry = new DialPlanDataEntry() { DataOwner = authUsername, DataKey = key, DataValue = value };
entities.AddToDialPlanData(newEntry);
}
entities.SaveChanges();
}
}