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(); }
private Guid CreateNewUser(string openIdUrl) { TadmapDb db = new TadmapDb(Database.TadmapConnection); User newUser = new User(); newUser.Id = Guid.NewGuid(); newUser.Name = string.Empty; UserRole newUserRole = new UserRole(); newUserRole.UserId = newUser.Id; newUserRole.Role = TadmapRoles.Collector; UserOpenId newOpenId = new UserOpenId(); newOpenId.UserId = newUser.Id; newOpenId.OpenIdUrl = openIdUrl; db.Users.InsertOnSubmit(newUser); db.UserRoles.InsertOnSubmit(newUserRole); db.UserOpenIds.InsertOnSubmit(newOpenId); db.SubmitChanges(); return newUser.Id; }