Example #1
0
      public void Save(TadmapImage image)
      {
         bool isNew = false;

         TadmapDb db = new TadmapDb();
         UserImage dbImage = db.UserImages.SingleOrDefault(i => i.Id == image.Id);

         if (dbImage == null)
         {
            dbImage = new UserImage();

            // can't change date added, id or owner
            dbImage.DateAdded = DateTime.Now;
            dbImage.UserId = image.UserId;
            dbImage.Id = image.Id;

            isNew = true;
         }
         else
         {
            isNew = false;
         }

         dbImage.Title = image.Title;
         dbImage.Description = image.Description;
         dbImage.Key = image.Key;
         dbImage.OffensiveCount = image.IsOffensive ? (byte)1 : (byte)0;
         dbImage.Privacy = image.IsPublic ? (byte)1 : (byte)0;

         if (isNew)
            db.UserImages.InsertOnSubmit(dbImage);

         db.SubmitChanges();
      }
Example #2
0
      public void Save(Model.User.User user)
      {
         bool isNew = false;

         TadmapDb db = new TadmapDb(ConnectionString);
         User dbUser = db.Users.SingleOrDefault(i => i.Id == user.Id);

         if (dbUser == null)
         {
            dbUser = new User();

            dbUser.Name = user.Name;

            var roles = user.Roles.Select(r => new UserRole { Role = r });
            dbUser.UserRoles.AddRange(roles);

            var openIds = user.OpenIds.Select(id => new OpenId { OpenIdUrl = id });
            dbUser.OpenIds.AddRange(openIds);

            isNew = true;
         }
         else
         {
            isNew = false;
         }

         if (isNew)
            db.Users.InsertOnSubmit(dbUser);

         db.SubmitChanges();
      }
Example #3
0
      public IQueryable<Model.User.User> GetAllUsers()
      {
         TadmapDb db = new TadmapDb(ConnectionString);

         return from i in db.Users
                select new Model.User.User
                {
                   Id = i.Id,
                   OpenIds = i.OpenIds.Select(id => id.OpenIdUrl).ToList(),
                   Roles = i.UserRoles.Select(role => role.Role).ToList()
                };
      }
Example #4
0
      public IQueryable<TadmapImage> GetAllImages(IBinaryRepository binaryRepository)
      {
         TadmapDb db = new TadmapDb();

         return from i in db.UserImages
                select new TadmapImage(binaryRepository)
                {
                   Id = i.Id,
                   Title = i.Title,
                   Description = i.Description,
                   Key = i.Key,
                   IsPublic = i.Privacy == 1,
                   IsOffensive = i.OffensiveCount > 0,
                   OwnerName = i.User.UserOpenIds.Single().OpenIdUrl,
                   ImageSet = new ImageSet1(i.Key)
                };
      }
Example #5
0
      public IQueryable<TadmapImage> GetAllImages()
      {
         var db = new TadmapDb(ConnectionString);

         return from i in db.Images
                select new TadmapImage
                {
                   Id = i.Id,
                   Title = i.Title,
                   Description = i.Description,
                   Key = i.Key,
                   IsPublic = i.Privacy == 1,
                   IsOffensive = i.OffensiveCount > 0,
                   OwnerName = i.User.OpenIds.Single().OpenIdUrl,
                   ImageSet = new ImageSet1(i.Key),
                   UserId = i.User.Id,
                   HasIcon = i.ThumbnailAvailable,
                   ZoomLevel = i.ZoomLevels ?? 0,
                   TileSize = i.TileSize ?? 0
                };
      }
Example #6
0
      public void Save(TadmapImage image)
      {
         bool isNew = false;

         TadmapDb db = new TadmapDb(ConnectionString);
         Image dbImage = db.Images.SingleOrDefault(i => i.Id == image.Id);

         if (dbImage == null)
         {
            dbImage = new Image();

            // can't change date added, id or owner
            dbImage.DateAdded = DateTime.Now;
            dbImage.UserId = image.UserId;

            isNew = true;
         }
         else
         {
            isNew = false;
         }

         dbImage.Title = image.Title;
         dbImage.Description = image.Description;
         dbImage.Key = image.Key;
         dbImage.OffensiveCount = image.IsOffensive ? (byte)1 : (byte)0;
         dbImage.Privacy = image.IsPublic ? (byte)1 : (byte)0;
         dbImage.TileSize = image.TileSize;
         dbImage.ZoomLevels = image.ZoomLevel > 0 ? new int?(image.ZoomLevel) : null;
         dbImage.ThumbnailAvailable = image.HasIcon;

         if (isNew)
            db.Images.InsertOnSubmit(dbImage);

         db.SubmitChanges();
      }