public IHttpActionResult PutPost(Guid id, Post post) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != post.Id) { return(BadRequest()); } db.Entry(post).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PostExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutProfile(Guid id, Profile profile) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != profile.Id) { return(BadRequest()); } _profileService.UpdateProfile(profile); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProfileExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void Create(User item) { //int id = this.GetAll().Max(u => u.Id); //item.Id = id; db.Users.Add(item); db.SaveChanges(); }
protected override void Seed(SocialNetworkContext context) { if (context.Roles.Any()) { return; } var user = context.Users.First(); var adminRole = new IdentityRole() { Name = "Admin" }; var moderatorRole = new IdentityRole() { Name = "Moderator" }; context.Roles.Add(adminRole); context.Roles.Add(moderatorRole); context.SaveChanges(); adminRole.Users.Add(new IdentityUserRole() { UserId = user.Id }); context.SaveChanges(); }
public ActionResult Create([Bind(Include = "ID,Name,Email")] User user) { try { User userFromDb = db.Users.Where(p => p.Email == user.Email).FirstOrDefault(); //if (ModelState.IsValid) //{ if (db.Users.Where(p => p.Email == user.Email).FirstOrDefault() == null) { // if (ModelState.IsValid) // { db.Users.Add(user); db.SaveChanges(); userFromDb = user; // } } // else // return RedirectToAction("Index", "home"); //} db.Asparaguses.Add(new Asparagus(userFromDb)); db.SaveChanges(); return(RedirectToAction("Index", "asparagus")); } catch { return(RedirectToAction("Index", "home")); } }
public ActionResult Create([Bind(Include = "ID,Date")] Asparagus asparagus) { if (ModelState.IsValid) { db.Asparaguses.Add(asparagus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(asparagus)); }
public ActionResult Create([Bind(Include = "Id,DateTimeSent,Content")] Message message) { if (ModelState.IsValid) { message.Id = Guid.NewGuid(); db.Messages.Add(message); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(message)); }
public bool Remove(Profile profile) { try { _dbSet.Remove(profile); _socialNetworkContext.SaveChanges(); return(true); } catch { return(false); } }
public bool Remove(Follow obj) { try { _dbSet.Remove(obj); _socialNetworkContext.SaveChanges(); return(true); } catch { return(false); } }
public ActionResult Create([Bind(Include = "Id,Title,Description,CreationDate")] PhotoAlbum photoAlbum) { if (ModelState.IsValid) { photoAlbum.Id = Guid.NewGuid(); photoAlbum.Profile = db.Profiles.Find(Guid.Parse(Session["profileId"].ToString())); db.PhotoAlbums.Add(photoAlbum); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(photoAlbum)); }
public bool Remove(CommentsFromPost obj) { try { _dbSet.Remove(obj); _socialNetworkContext.SaveChanges(); return(true); } catch { return(false); } }
private void AddTagsToAlbums(SocialNetworkContext db) { string[] sampleTags = new string[] { "#TestTag1", "#TestTag2", "#TestTag3", "#TestTag4", "#TestTag5" }; foreach (var tag in sampleTags) { if (!db.Tags.Any(t => t.Title == tag)) { db.Tags.Add(new Tag { Title = tag }); } db.SaveChanges(); } Random rnd = new Random(); var albums = db.Albums.Include(a => a.Tags).ToList(); var dbTagIds = db.Tags.Select(t => t.Id).ToList(); Console.WriteLine("Populating albums with tags..."); foreach (var alb in albums) { int tagCount = rnd.Next(1, dbTagIds.Count); while (alb.Tags.Count < tagCount) { var tagId = dbTagIds[rnd.Next(0, dbTagIds.Count)]; if (alb.Tags.Any(at => at.TagId == tagId)) { continue; } else { alb.Tags.Add(new AlbumTag { TagId = tagId }); } } } db.SaveChanges(); Console.WriteLine("Done."); }
public ActionResult Create([Bind(Include = "Id,Content")] Post post) { if (ModelState.IsValid) { post.Id = Guid.NewGuid(); post.Author = db.Profiles.ToList() .Where(p => p.Email == Session["UserEmail"].ToString()) .First(); db.Posts.Add(post); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(post)); }
public ActionResult Create([Bind(Include = "Id,Content")] Comment comment, Guid postId) { if (ModelState.IsValid) { comment.Id = Guid.NewGuid(); var profileId = Guid.Parse(Session["profileId"].ToString()); comment.Sender = db.Profiles.Find(profileId); comment.Post = db.Posts.Find(postId); db.Comments.Add(comment); db.SaveChanges(); } //return View(comment); return(RedirectToAction("Details", "Groups", new { id = Session["groupId"] })); }
public IHttpActionResult CreatePost([FromBody] Post post) { try { using (var ctx = new SocialNetworkContext()) { post.DateCreated = DateTime.Now; post.UserId = GetCurrentUser().Id; ctx.Posts.Add(post); ctx.SaveChanges(); return(Json(new { success = true })); } } catch (Exception ex) { return(Json(new { success = false, error = ex.Message })); } }
private static void RecieveTagsAndSaveThemToDb(SocialNetworkContext context) { Console.WriteLine("Enter tag:"); string tagAsString = Console.ReadLine(); string validTag = tagAsString.Transform(); List <Album> albums = context.Albums.ToList(); Random rnd = new Random(); Tag tag = new Tag() { Name = validTag }; for (int i = 0; i < 2; i++) { int next = rnd.Next(0, albums.Count); if (tag.Albums.All(a => a.AlbumId != next)) { tag.Albums.Add(new AlbumTags() { AlbumId = albums[next].Id }); } } context.Tags.Add(tag); context.SaveChanges(); Console.WriteLine($"{tag} was added to database"); }
public void Create(Notification notification) { var notificationContext = new SocialNetworkContext(); notificationContext.Notifications.Add(notification); notificationContext.SaveChanges(); }
public IHttpActionResult DeletePost(int id) { try { using (var ctx = new SocialNetworkContext()) { var post = ctx.Posts.Where(w => w.Id == id).SingleOrDefault(); if (post != null) { ctx.Posts.Remove(post); } ctx.SaveChanges(); return(Json(new { success = true })); } } catch (Exception ex) { return(Json(new { success = false, error = ex.Message })); } }
public IActionResult SignUp(User user) { Context.Entry(user).State = EntityState.Modified; Context.SaveChanges(); return(View()); }
public static void LikeUserPost(int userId, int userPostId) { var context = new SocialNetworkContext(); var user = context.Users.Find(userId); var post = context.Postings.Find(userPostId); var like = new Like() { Author = user, Posting = post }; context.Likes.Add(like); try { // Your code... // Could also be before try if you know the exception occurs in SaveChanges context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public void AddRange(IList <T> entities) { using (var context = new SocialNetworkContext()) { context.Set <T>().AddRange(entities); context.SaveChanges(); } }
public ActionResult Create([Bind(Include = "Id,Content")] Message message, Guid recipientId) { if (ModelState.IsValid) { message.Id = Guid.NewGuid(); message.Sender = db.Users.ToList() .Where(user => user.Email == Session["userEmail"].ToString()) .First(); message.Recipient = db.Users.Find(recipientId); message.DateTimeSent = DateTime.Now; db.Messages.Add(message); db.SaveChanges(); return(RedirectToAction("Index", new { userId = recipientId })); } return(View("Index", new { userId = recipientId })); }
public void DeleteEntity(T entity) { using (var context = new SocialNetworkContext()) { context.Set <T>().Remove(entity); context.SaveChanges(); } }
public ActionResult Create([Bind(Include = "Id,Email,Name,Age,Photo")] Profile profile, HttpPostedFileBase profilePhoto) { if (ModelState.IsValid) { profile.Id = Guid.NewGuid(); profile.Email = Session["UserEmail"].ToString(); //---- Upload da Foto ---- profile.Photo = StorageService.BlobService.GetInstance() .UploadFile("simplesocialnetwork", Guid.NewGuid().ToString(), profilePhoto.InputStream, profilePhoto.ContentType); //------------------------ db.Profiles.Add(profile); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(profile)); }
public void AddEntity(T entity) { using (var context = new SocialNetworkContext()) { context.Set <T>().Add(entity); context.SaveChanges(); } }
private static void CreateDb() { var ctx = new SocialNetworkContext(); var users = ctx.Users.ToList(); ctx.SaveChanges(); }
public ActionResult DeleteConfirmed(Guid id) { User user = db.Users.Find(id); db.Users.Remove(user); db.SaveChanges(); return(RedirectToAction("Index")); }
public bool Remove(int id) { try { var stories = new Story { Id = id }; _context.Stories.Attach(stories); _context.Stories.Remove(stories); _context.SaveChanges(); return(true); } catch (Exception ex) { throw; } }
public ActionResult DeleteConfirmed(Guid id) { Profile profile = db.Profiles.Find(id); db.Profiles.Remove(profile); db.SaveChanges(); return(RedirectToAction("Index")); }
public bool UpdatePhoto(Guid idProfile, string urlPhoto) { try { var posts = _dbSet.Where(p => p.IdProfile == idProfile).ToList(); for (var count = 0; count < posts.Count(); count++) { posts[count].UrlPhotoAutor = urlPhoto; _socialNetworkContext.Entry(posts[count]).State = EntityState.Modified; } _socialNetworkContext.SaveChanges(); return(true); } catch { return(false); } }