public MembershipUser GetUserByEmail(string email)
{
email = StringUtils.SafePlainText(email);
var cacheKey = string.Concat(CacheKeys.Member.StartsWith, "GetUserByEmail-", email);
return(_cacheService.CachePerRequest(cacheKey, () =>
{
using (var Cmd = _context.CreateCommand())
{
Cmd.CommandText = "SELECT * FROM [MembershipUser] WHERE Email = @Email";
Cmd.AddParameters("Email", email);
return Cmd.FindFirst <MembershipUser>();
}
}));
}
public List <SelectListItem> GetBaseSelectListCategories(List <Category> allowedCategories)
{
var cacheKey = string.Concat(CacheKeys.Category.StartsWith, "GetBaseSelectListCategories", "-", allowedCategories.GetHashCode());
return(_cacheService.CachePerRequest(cacheKey, () =>
{
var cats = new List <SelectListItem> {
new SelectListItem {
Text = "----", Value = ""
}
};
foreach (var cat in allowedCategories)
{
var catName = string.Concat(LevelDashes(cat.Level), cat.Level > 1 ? " " : "", cat.Name);
cats.Add(new SelectListItem {
Text = catName, Value = cat.Id.ToString()
});
}
return cats;
}));
}
public List <SelectListItem> GetBaseSelectListLanguages(List <Language> allowedLanguages)
{
var cacheKey = string.Concat(CacheKeys.Localization.StartsWith, "GetBaseSelectListLanguages", "-", allowedLanguages.GetHashCode());
return(_cacheService.CachePerRequest(cacheKey, () =>
{
var cats = new List <SelectListItem> {
new SelectListItem {
Text = "", Value = ""
}
};
foreach (var cat in allowedLanguages)
{
cats.Add(new SelectListItem {
Text = cat.Name, Value = cat.Id.ToString()
});
}
return cats;
}));
}
public List <SelectListItem> GetBaseSelectListEmployeesRole(List <EmployeesRole> allowedCategories)
{
var cacheKey = string.Concat(CacheKeys.EmployeesRole.StartsWith, "GetBaseSelectListEmployeesRole", "-", allowedCategories.GetHashCode());
return(_cacheService.CachePerRequest(cacheKey, () =>
{
var cats = new List <SelectListItem> {
new SelectListItem {
Text = "", Value = ""
}
};
foreach (var cat in allowedCategories)
{
cats.Add(new SelectListItem {
Text = cat.Name, Value = cat.Id.ToString()
});
}
return cats;
}));
}
public List <SelectListItem> GetBaseSelectListTypeRooms(List <TypeRoom> allowedTypeRoom)
{
var cacheKey = string.Concat(CacheKeys.TypeRoom.StartsWith, "GetBaseSelectListTypeRooms", "-", allowedTypeRoom.GetHashCode());
return(_cacheService.CachePerRequest(cacheKey, () =>
{
var cats = new List <SelectListItem> {
new SelectListItem {
Text = "", Value = ""
}
};
foreach (var cat in allowedTypeRoom)
{
cats.Add(new SelectListItem {
Text = cat.Name, Value = cat.Id.ToString()
});
}
return cats;
}));
}
