/**** * IEnumerable<apan_CommunityMap> communityMaps = (from m in context.apan_CommunityMap * where m.GroupId == groupId * select m).ToList(); * * int totalCount = communityMaps.Count(); * switch (sortBy) * { * case SortBy.Title: * if (sortOrder == SortOrder.Descending) * communityMaps = communityMaps.OrderByDescending(m => m.Title).Skip(pageIndex * pageSize).Take(pageSize); * else * communityMaps = communityMaps.OrderBy(m => m.Title).Skip(pageIndex * pageSize).Take(pageSize); * break; * case SortBy.CreatedDateTimeUtc: * if (sortOrder == SortOrder.Descending) * communityMaps = communityMaps.OrderByDescending(m => m.CreatedDateTimeUtc).Skip(pageIndex * pageSize).Take(pageSize); * else * communityMaps = communityMaps.OrderBy(m => m.CreatedDateTimeUtc).Skip(pageIndex * pageSize).Take(pageSize); * break; * case SortBy.ModifiedDateTimeUtc: * default: * if (sortOrder == SortOrder.Descending) * communityMaps = communityMaps.OrderByDescending(m => m.ModifiedDateTimeUtc).Skip(pageIndex * pageSize).Take(pageSize); * else * communityMaps = communityMaps.OrderBy(m => m.ModifiedDateTimeUtc).Skip(pageIndex * pageSize).Take(pageSize); * break; * } * * return new PagedList<Map>( * communityMaps.Select(n => new Map { Id = n.Id, Title = n.Title, Description = n.Description, GroupId = n.GroupId, CreatedByUserId = n.CreatedByUserId, CreatedDateTimeUtc = n.CreatedDateTimeUtc, ModifiedByUserId = n.ModifiedByUserId, ModifiedDateTimeUtc = n.ModifiedDateTimeUtc }), * pageSize, * pageIndex, * totalCount); */ internal static CoriaMapBook GetCoriaMapBookByGroupId_MapBookName(int groupId, string mapBookName) { Func <MapBook, CoriaMapBook> toCoriaMapBook = (MapBook fromMapBook) => ToCoriaMapBook(fromMapBook, new CoriaMapBook()); MapBook mapbook = GetMapBookByGroupId_MapBookName(groupId, mapBookName); return(toCoriaMapBook(mapbook)); }
internal static Map CreateMap(Map map) { MapBook mapbook = GetMapBook(map.MapTypeId); if (mapbook != null) { //if(map.MapBook.ApplicationId != null) try { using (KhartaDataModel dbcontext = new KhartaDataModel()) { map = dbcontext.Maps.Add(map); dbcontext.SaveChanges(); return(map); } } catch (Exception ex) { string error = ex.InnerException.Message; InternalApi.Utility.CoriaException csEx = new Utility.CoriaException(CSExceptionType.LoggableException, ex.InnerException.Message, null); csEx.Log(); return(map); } } else { return(map); } }
internal static void DeleteCoriaMapBookApplication(Guid id) { using (KhartaDataModel dbcontext = new KhartaDataModel()) { var result = (from m in dbcontext.MapBooks where m.ApplicationId.Equals(id) select m).FirstOrDefault(); MapBook mapbook = result; dbcontext.MapBooks.Remove(mapbook); dbcontext.SaveChanges(); } }
private static MapBook GetMapBookByGroupId_MapBookName(int groupId, string mapBookName) { using (KhartaDataModel dbcontext = new KhartaDataModel()) { MapBook mapbook = (from m in dbcontext.MapBooks where m.GroupId.Equals(groupId) && m.SafeName.Equals(mapBookName) select m).FirstOrDefault(); return(mapbook); } }
internal static PagedList <CoriaMap> CoriaMapPagedList(MapBook mapbook, int pageIndex, int pageSize, string sortBy, string sortOrder) { if (mapbook == null) { return(null); } // Func<Map, CoriaMap> toCoriaMap = (Map fromMap) => ToCoriaMap(fromMap, new CoriaMap()); //PagedList<CoriaMap > coriaMapList = new PagedList<CoriaMap>(); PagedList <Map> MapList = MapPagedList(mapbook, pageIndex, pageSize, sortBy, sortOrder); int totalCount = MapList.Count(); return(new PagedList <CoriaMap>( MapList.Select(n => new CoriaMap(n)), pageSize, pageIndex, totalCount)); }
internal static PagedList <Map> MapPagedList(MapBook mapbook, int pageIndex, int pageSize, string sortBy, string sortOrder) { if (mapbook == null) { return(null); } using (KhartaDataModel dbcontext = new KhartaDataModel()) { int skip = pageIndex * pageSize; // PagedList<Map> mapList = new PagedList<Map>(); IList <Map> mapList = new List <Map>(); mapList = (from m in dbcontext.Maps where m.MapTypeId.Equals(mapbook.ApplicationId) orderby m.SafeName ascending select m).Skip(skip).Take(pageSize).ToList(); int totalCount = mapList.Count(); return(new PagedList <Map>(mapList, pageSize, pageIndex, totalCount));; } }
internal static CoriaMapBook CreateNewMapBookApplication(CoriaMapBook coriaMapBook) { Func <CoriaMapBook, MapBook> toMapBook = (CoriaMapBook fromCoriaMapBook) => ToMapBook(fromCoriaMapBook, new MapBook()); Func <MapBook, CoriaMapBook> toCoriaMapBook = (MapBook fromMapBook) => ToCoriaMapBook(fromMapBook, new CoriaMapBook()); try { using (KhartaDataModel dbcontext = new KhartaDataModel()) { MapBook mapbook = dbcontext.MapBooks.Add(toMapBook(coriaMapBook)); dbcontext.SaveChanges(); return(toCoriaMapBook(mapbook)); } } catch (Exception ex) { //TODO: log exception var exception = ex; throw; } }
internal static MapBook ToMapBook(CoriaMapBook fromCoriaMapBook, MapBook toMapBook) { return((MapBook)ConvertFromPropertiesTo(fromCoriaMapBook, toMapBook)); }
internal static CoriaMapBook ToCoriaMapBook(MapBook fromMapBook, CoriaMapBook toCoriaMapBook) { return((CoriaMapBook)ConvertFromPropertiesTo(fromMapBook, toCoriaMapBook)); }