public static ApplicationReferenceViewModel ToViewModel(ApplicationReferences entity) { return(new ApplicationReferenceViewModel { Id = entity.Id, Alias = entity.Alias, Key = entity.Key, ParentId = entity.ParentId, Name = entity.Name, Value = entity.Value, IsParent = entity.IsParent, IsDelete = entity.IsDelete, IsActive = entity.IsActive, }); }
private static void ReferencesInit(AppContext context) { var newsTags = new ApplicationReferences { Alias = AppConstants._NewsTags, Name = AppConstants._NewsTags, IsParent = true, Value = AppConstants._NewsTags, Key = AppConstants._NewsTags, IsActive = true }; context.ApplicationReferences.Add(newsTags); context.SaveChanges(); }
public IEnumerable <Article> Get(string tagAlias) { IEnumerable <Article> news = null; try { var ctx = unitOfWork.CityLifeDbContext; if (string.IsNullOrEmpty(tagAlias)) { news = ctx.Set <Article>() .Include(x => x.Tags) .Include(x => x.PreviewPictures) .Include(x => x.Owner) .ToList(); } else { ApplicationReferences tag = ctx .Set <ApplicationReferences>() .FirstOrDefault(x => x.Alias.ToLower() == tagAlias); if (tag == null) { return(null); } news = ctx.Set <Article>() .Include(x => x.Tags) .Include(x => x.PreviewPictures) .Include(x => x.Owner) .Where(x => x.Tags.Any(y => y.Id == tag.Id)) .ToList(); } return(news); } catch (Exception ex) { ExceptionService.WriteException(ex, section, SysConstants.AppException_CityNews); throw new Exception(ex.Message); } }
public ApplicationReferences Edit(ApplicationReferences entity) { try { var editEntity = new ApplicationReferences(); if (entity != null) { var ctx = unitOfWork .CityLifeDbContext; DbSet <ApplicationReferences> set = ctx.Set <ApplicationReferences>(); if (entity.Id == 0) { repository.Add(editEntity); } else { editEntity = set.FirstOrDefault(x => x.Id == editEntity.Id); } editEntity.IsParent = entity.IsParent; editEntity.ParentId = entity.ParentId; editEntity.Name = entity.Name; editEntity.Alias = entity.Name.ToAlias(); editEntity.IsActive = entity.IsActive; editEntity.Key = entity.Key; editEntity.Value = entity.Value; ctx.SaveChanges(); } return(editEntity); } catch (Exception ex) { ExceptionService.WriteException(ex, section, SysConstants.AppException_References); throw new Exception(ex.Message); } }
public ApplicationReferences GetById(int id) { try { ApplicationReferences entity = null; if (id != 0) { var ctx = unitOfWork.CityLifeDbContext; entity = ctx.Set <ApplicationReferences>() .FirstOrDefault(x => x.Id == id); return(entity); } return(entity); } catch (Exception ex) { ExceptionService.WriteException(ex, section, SysConstants.AppException_References); throw new Exception(ex.Message); } }
public Article Edit(Article entry, int[] tagIdentifiers) { try { Article entity = new Article(); using (var ctx = unitOfWork.CityLifeDbContext) { var artSet = ctx.Set <Article>(); if (entry.Id > 0) { entity = artSet .Include(x => x.Tags) .Include(x => x.PreviewPictures) .Include(x => x.Owner) .FirstOrDefault(x => x.Id == entry.Id); } else { artSet.Add(entry); } entity.MetaKeywords = entry.MetaKeywords; entity.MetaDescription = entry.MetaDescription; entity.Name = entry.Name; entity.Alias = entry.Name.ToAlias(); entry.DateUpdate = DateTime.Now; entity.Content = entry.Content; entity.ShortDescription = entry.ShortDescription; entity.OwnerId = entity.OwnerId; entity.IsActive = entry.IsActive; entity.IsDelete = entry.IsDelete; entity.PathPreviewPic = entry.PathPreviewPic; entity.PathTitlePic = entry.PathTitlePic; entity.Tags.Clear(); foreach (int tagId in tagIdentifiers) { ApplicationReferences tag = ctx.Set <ApplicationReferences>() .FirstOrDefault(x => x.Id == tagId); entity.Tags.Add(tag); } ctx.SaveChanges(); } return(entity); } catch (Exception ex) { ExceptionService.WriteException(ex, section, SysConstants.AppException_CityNews); throw new Exception(ex.Message); } }