public static EmailTemplate GetEmailTemplate(string Name)
{
string name = Name;
EmailTemplate result = MemoryCache.Default.Get(key + name) as EmailTemplate;
if (result != null)
{
return(result);
}
BuildingEntities db = new BuildingEntities();
EmailTemplate et = db.EmailTemplates.FirstOrDefault(val => val.SysName == name);
if (et == null)
{
User user = db.CurrentUser;
et = new EmailTemplate();
et.SysName = Name;
et.Name = Name;
et.CreateDate = DateTime.Now;
et.Creator = user != null ? user.Login : "******";
db.EmailTemplates.AddObject(et);
db.SaveChanges();
}
MemoryCache.Default.Add(key + name, et, new CacheItemPolicy()
{
AbsoluteExpiration = DateTime.Now.AddMinutes(duration)
});
db.Dispose();
return(et);
}
public static string GetValue(string Name, string Default = "")
{
string result = MemoryCache.Default.Get(key + Name) as string;
if (result.IsNotNullOrEmpty())
{
return(result);
}
BuildingEntities db = new BuildingEntities();
SystemSetting ss = db.SystemSettings.FirstOrDefault(val => val.Name == Name);
if (ss == null)
{
ss = new SystemSetting();
ss.Name = Name;
ss.Value = Default;
ss.Date = DateTime.Now;
ss.Title = Name;
db.SystemSettings.AddObject(ss);
db.SaveChanges();
}
db.Dispose();
Default = ss.Value;
MemoryCache.Default.Add(key + Name, Default, new CacheItemPolicy()
{
AbsoluteExpiration = DateTime.Now.AddMinutes(duration)
});
return(Default);
}
public static string SystemSetting(this HtmlHelper htmlHelper, string Name)
{
BuildingEntities db = new BuildingEntities();
SystemSetting setting = db.SystemSettings.FirstOrDefault(val => val.Name.ToLower() == Name.ToLower());
db.Dispose();
return(setting != null ? setting.Value : null);
}
public static string UserSetting(this HtmlHelper htmlHelper, string Name)
{
int UserID = HttpContext.Current.Request.RequestContext.HttpContext.CurrentUser().ID;
BuildingEntities db = new BuildingEntities();
UserSetting setting = db.UserSettings.FirstOrDefault(val => val.Name.ToLower() == Name.ToLower() && val.UserID == UserID);
db.Dispose();
return(setting != null ? setting.Value : null);
}
public static void SetValue(string Name, string Value)
{
BuildingEntities db = new BuildingEntities();
SystemSetting ss = db.SystemSettings.FirstOrDefault(val => val.Name == Name);
if (ss == null)
{
ss = new SystemSetting();
ss.Name = Name;
ss.Value = Value;
ss.Date = DateTime.Now;
ss.Title = Name;
db.SystemSettings.AddObject(ss);
}
ss.Value = Value;
db.SaveChanges();
db.Dispose();
}
protected override void Dispose(bool disposing)
{
base.Dispose(disposing);
db.Dispose();
}
