public ProfileEntity GetProfile(ProfileQueryEntity queryEntity)
{
CPDataContext ctx = new CPDataContext(OperationType.Action);
var query = from profile in ctx.ProfileEntities
where profile.ApplicationId2 == queryEntity.ApplicationId &&
profile.InUser == queryEntity.InUser &&
profile.ProfileType == queryEntity.ProfileType
select profile;
ProfileEntity result = query.FirstOrDefault();
return(result);
}
public List <ProfileEntity> GetProfiles(ProfileQueryEntity queryEntity)
{
CPDataContext ctx = new CPDataContext(OperationType.Query);
var query = from profile in ctx.ProfileEntities
where profile.ApplicationId2 == queryEntity.ApplicationId &&
profile.InUser == queryEntity.InUser &&
profile.ProfileType == queryEntity.ProfileType
select profile;
List <ProfileEntity> result = query.ToList();
return(result);
}
public List <ControlPanelLocalizedMenuEntity> GetLocalizedMenuItems(ControlPanelLocalizedMenuQueryEntity queryEntity)
{
CPDataContext ctx = new CPDataContext(OperationType.Query);
var query = from menu in ctx.FN_ControlPanelMenuWithLocalizedRes(queryEntity.LanguageCode ?? String.Empty)
where (queryEntity.ApplicationIds.Length > 0 ? queryEntity.ApplicationIds.Contains(menu.ApplicationId2) : true) &&
(queryEntity.StatusCode != null ? (menu.StatusCode == queryEntity.StatusCode) : true)
orderby menu.SortIndex descending, menu.MenuId ascending
select menu;
List <ControlPanelLocalizedMenuEntity> result = query.ToList();
return(result);
}
public List <ConfigKeyValueMsg> GetApplicationConfig()
{
#if TRACE
System.Diagnostics.Stopwatch stopwatch = System.Diagnostics.Stopwatch.StartNew();
#endif
if (string.IsNullOrEmpty(applicationID))
{
throw new ArgumentNullException("applicationID");
}
List <ConfigKeyValueMsg> list = new List <ConfigKeyValueMsg>();
CPDataContext ctx = new CPDataContext(OperationType.Query);
var result = from item in ctx.ConfigurationEntities
where item.ApplicationId == applicationID
orderby item.DomainName ascending
select item;
foreach (ConfigurationEntity item in result)
{
list.Add(new ConfigKeyValueMsg()
{
Domain = item.DomainName,
Key = item.ConfigKey,
Value = item.ConfigValue,
ConfigID = item.ConfigId,
Description = item.ConfigDescription,
EditDate = item.EditDate,
EditUser = item.EditUser,
InDate = item.InDate,
InUser = item.InUser
});
}
#if TRACE
stopwatch.Stop();
System.Diagnostics.Trace.WriteLine(String.Format("Newegg.Oversea.Silverlight.ControlPanel.Service.GetApplicationConfig() -> Elapsed time: {0} ms", stopwatch.ElapsedMilliseconds));
#endif
return(list);
}
