//public IEnumerable<ErrorDto> ListForTenant(int tenantId, int skip, int take, out int totalCount) //{ // using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) // { // totalCount = (from error in ctx.ObjectContext.Error // where error.TenantId == tenantId // select error).ToList().Count(); // var result = (from error in ctx.ObjectContext.Error // where error.TenantId == tenantId // orderby error.UtcTime, error.Sequence // select new ErrorDto // { // Id = error.Id, // Host = error.Host, // Type = error.Type, // Source = error.Source, // Message = error.Message, // User = error.User, // StatusCode = error.StatusCode, // //TODO: figure out how to convert the time to the client's local time // UtcTime = error.UtcTime // }); // return result.Skip(skip).Take(take).ToList(); // } //} public IEnumerable <ErrorDto> ListForApplication(string application, int skip, int take, out int totalCount) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { totalCount = (from error in ctx.ObjectContext.Error where error.Application == application select error).ToList().Count(); var result = (from error in ctx.ObjectContext.Error where error.Application == application orderby error.UtcTime, error.Sequence select new ErrorDto { Id = error.Id, TenantId = error.TenantId, Application = error.Application, Host = error.Host, Type = error.Type, Source = error.Source, Message = error.Message, User = error.User, StatusCode = error.StatusCode, //TODO: figure out how to convert the time to the client's local time UtcTime = error.UtcTime }); return(result.Skip(skip).Take(take).ToList()); } }
public CategoryDto Fetch(Guid Id, int localeId) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { var result = (from category in ctx.ObjectContext.Category join categoryLocale in ctx.ObjectContext.CategoryLocale on category.Id equals categoryLocale.CategoryId join page in ctx.ObjectContext.Page on category.Id equals page.ContentId join pageLocale in ctx.ObjectContext.PageLocale on page.Id equals pageLocale.PageId where category.Id == Id where categoryLocale.LocaleId == localeId where pageLocale.LocaleId == localeId where page.ContentType == 2 //category type select new CategoryDto { Id = category.Id, Title = pageLocale.Title, Description = categoryLocale.Description, MetaKeywords = pageLocale.MetaKeywords, MetaDescription = pageLocale.MetaDescription }).FirstOrDefault(); if (result == null) { throw new DataNotFoundException("Category"); } return(result); } }
public IEnumerable <AssemblyTypeLocaleDto> List(int tenantId, int localeId, int hashCode, string typeName) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { var result = (from assemblyTypeText in ctx.ObjectContext.AssemblyTypeText join assemblyType in ctx.ObjectContext.AssemblyType on assemblyTypeText.AssemblyTypeId equals assemblyType.Id join assemblyTypeTextLocale in ctx.ObjectContext.AssemblyTypeTextLocale on assemblyTypeText.Id equals assemblyTypeTextLocale.AssemblyTypeTextId join tenant in ctx.ObjectContext.Tenant on assemblyType.TenantId equals tenant.Id where assemblyType.TenantId == tenantId where assemblyType.TypeNameHashCode == hashCode && assemblyType.TypeName == typeName where assemblyTypeTextLocale.LocaleId == localeId || assemblyTypeTextLocale.LocaleId == tenant.DefaultLocaleId select new AssemblyTypeLocaleDto { TextName = assemblyTypeText.TextName, Value = assemblyTypeTextLocale.Value, LocaleId = assemblyTypeTextLocale.LocaleId }); return(result.ToList()); } }
public IList <ParentUrlPageDto> ListForParentUrl(int tenantId) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { var result = (from pageLocale in ctx.ObjectContext.PageLocale join page in ctx.ObjectContext.Page on pageLocale.PageId equals page.Id where page.TenantId == tenantId select new ParentUrlPageDto { Id = page.Id, ParentId = page.ParentId == null ? Guid.Empty : (Guid)page.ParentId, TenantId = tenantId, LocaleId = pageLocale.LocaleId, ContentType = page.ContentType, ContentId = page.ContentId, Url = pageLocale.Url, IsUrlAbsolute = pageLocale.IsUrlAbsolute }); return(result.ToList()); } }
public IList <CategoryProductDto> ListForCategory(Guid categoryId, int localeId) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { var result = (from categoryXProduct in ctx.ObjectContext.CategoryXProduct join product in ctx.ObjectContext.Product on categoryXProduct.ProductId equals product.Id join productXTenantXlocale in ctx.ObjectContext.ProductXTenantXLocale on product.Id equals productXTenantXlocale.ProductId where categoryXProduct.CategoryId == categoryId where productXTenantXlocale.LocaleId == localeId select new CategoryProductDto { CategoryXProductId = categoryXProduct.Id, Name = productXTenantXlocale.Name, SKU = product.SKU, ImageUrl = product.ImageUrl, Price = product.Price }); return(result.ToList()); } }
public TenantDto Fetch(string host) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { var tenant = (from t in ctx.ObjectContext.Tenant where t.Host == host select t).FirstOrDefault(); var result = Mapper.Map <Tenant, TenantDto>(tenant); //if (result == null) // throw new DataNotFoundException("Store"); return(result); } }
public IEnumerable <ViewLocaleDto> List(int tenantId, int localeId, int hashCode, string virtualPath) { using (var ctx = ((IEntityFrameworkObjectContext)contextFactory.GetContext()).ContextManager) { //var result = (from view in ctx.ObjectContext.View // join tenant in ctx.ObjectContext.Tenant // on view.TenantId equals tenant.Id // // Left Join // join viewLocale in ctx.ObjectContext.ViewLocale // on view.Id equals viewLocale.ViewId into x // from locale in x.DefaultIfEmpty() // // Left Join // join defaultViewLocale in ctx.ObjectContext.ViewLocale // on view.Id equals defaultViewLocale.ViewId into y // from defaultLocale in y.DefaultIfEmpty() // where view.TenantId == tenantId // where locale.LocaleId == localeId // where defaultLocale != null ? defaultLocale.LocaleId == tenant.DefaultLocaleId : true // select new ViewLocaleDto // { // TextName = view.TextName, // Value = locale == null ? viewLocale.Value : // }); //var result = (from viewLocale in ctx.ObjectContext.ViewLocale // join view in ctx.ObjectContext.View // on viewLocale.ViewId equals view.Id // join tenant in ctx.ObjectContext.Tenant // on view.TenantId equals tenant.Id // where view.TenantId == tenantId // where view.HashCode == hashCode && view.VirtualPath == virtualPath // where viewLocale.LocaleId == localeId || viewLocale.LocaleId == tenant.DefaultLocaleId // select new ViewLocaleDto // { // TextName = view.TextName, // Value = viewLocale.Value, // LocaleId = viewLocale.LocaleId // }); //return result.ToList(); var result = (from viewText in ctx.ObjectContext.ViewText join view in ctx.ObjectContext.View on viewText.ViewId equals view.Id join viewTextLocale in ctx.ObjectContext.ViewTextLocale on viewText.Id equals viewTextLocale.ViewTextId join tenant in ctx.ObjectContext.Tenant on view.TenantId equals tenant.Id where view.TenantId == tenantId where view.VirtualPathHashCode == hashCode && view.VirtualPath == virtualPath where viewTextLocale.LocaleId == localeId || viewTextLocale.LocaleId == tenant.DefaultLocaleId select new ViewLocaleDto { TextName = viewText.TextName, Value = viewTextLocale.Value, LocaleId = viewTextLocale.LocaleId }); return(result.ToList()); } }