/// <summary>
/// Returns the first ConfigurationItem that matches the supplied ModuleName and Key.
/// If one does not exist, then a new one is returned that will need to be saved back to the database to get created.
/// </summary>
/// <param name="ModuleName"></param>
/// <param name="Key"></param>
/// <returns></returns>
public static Models.ConfigurationItem GetUniqueItem(string ModuleName, string Key)
{
try
{
using (var db = new Context.SqlContext())
{
db.Configuration.LazyLoadingEnabled = false;
Models.ConfigurationItem ci = db.ConfigurationItem.Where(i => i.Module == ModuleName && i.Key == Key).FirstOrDefault();
if (ci != null)
{
return(ci);
}
else
{
ci = new Models.ConfigurationItem();
ci.Module = ModuleName;
ci.Key = Key;
return(ci);
}
}
}
catch (Exception ex)
{
var msg = ex.Message;
return(null);
}
}
public static int Save(Models.ConfigurationItem configurationItem)
{
using (var db = new Context.SqlContext())
{
db.Entry(configurationItem).State = configurationItem.ConfigurationItemId.Equals(0) ? EntityState.Added : EntityState.Modified;
return(db.SaveChanges());
}
}
public static string GetValue(string ModuleName, string Key)
{
try
{
using (var db = new Context.SqlContext())
{
db.Configuration.LazyLoadingEnabled = false;
Models.ConfigurationItem ci = db.ConfigurationItem.Where(i => i.Module == ModuleName && i.Key == Key).FirstOrDefault();
if ((ci != null) && (ci.Value != null))
{
return(ci.Value);
}
}
}
catch (Exception ex)
{
var msg = ex.Message;
return("");
}
return("");
}
