public void Insert(T entity) { if (entity == null) { throw new ArgumentNullException("entity"); } entities.Add(entity); context.SaveChanges(); }
public ActionResult Create([Bind(Include = "ID,WorkRole,CompanyName,StartDate,EndDate,Description")] Experience experience) { if (ModelState.IsValid) { db.Experiences.Add(experience); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(experience)); }
public ActionResult Create([Bind(Include = "ID,Name,Address,City,ZipCode,PhoneNumber,Email")] Person person) { if (ModelState.IsValid) { db.People.Add(person); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(person)); }
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Age")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "RoomId,Name")] Room room) { if (ModelState.IsValid) { db.Rooms.Add(room); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(room)); }
public ActionResult Create([Bind(Include = "ID,Description")] Skills skills) { if (ModelState.IsValid) { db.Skills.Add(skills); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(skills)); }
public ActionResult Create([Bind(Include = "Id,Nome,Telefone,CPF")] Cliente cliente) { if (ModelState.IsValid) { db.Clientes.Add(cliente); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cliente)); }
public ActionResult Create([Bind(Include = "ID,Name,School,StartDate,EndDate")] Education education) { if (ModelState.IsValid) { db.Educations.Add(education); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(education)); }
public bool AddOrUpdate(PhotoDataModel photo) { try { using (var ctx = new MVCContext()) { var photoToUpdate = ctx.Photos.Where(p => p.ID == photo.ID) .Include(p => p.User) .Include(p => p.Comments) .Include(p => p.Album) .FirstOrDefault(); if (photoToUpdate != null) { photoToUpdate.Name = photo.Name; photoToUpdate.AlbumID = photo.AlbumID; photoToUpdate.Path = photo.Path; photoToUpdate.publik = photo.publik; photoToUpdate.Description = photo.Description; photoToUpdate.Datecreated = photo.Dateupdated; ctx.SaveChanges(); return(true); } else { var newPhoto = new PhotoDataModel(); newPhoto.User = photo.User; newPhoto.Album = photo.Album; newPhoto.Name = photo.Name; newPhoto.AlbumID = photo.AlbumID; newPhoto.Path = photo.Path; newPhoto.publik = photo.publik; newPhoto.Description = photo.Description; newPhoto.Datecreated = photo.Datecreated; newPhoto.Dateupdated = photo.Dateupdated; newPhoto.UserID = photo.UserID; ctx.Photos.Add(newPhoto); ctx.SaveChanges(); return(true); } } } catch (Exception e) { //Handle exceptions } return(false); }
public bool AddOrUpdate(CommentsDataModel comment) { try { using (var ctx = new MVCContext()) { var commentToUpdate = ctx.Comments.Where(c => c.ID == comment.ID) .Include(c => c.User) .Include(c => c.Photo) .FirstOrDefault(); if (commentToUpdate != null) //EDIT { commentToUpdate.User = comment.User; commentToUpdate.Photo = comment.Photo; commentToUpdate.UserID = comment.UserID; commentToUpdate.PhotoID = comment.PhotoID; commentToUpdate.Comment = comment.Comment; commentToUpdate.Title = comment.Title; commentToUpdate.Dateupdated = comment.Dateupdated; ctx.SaveChanges(); return(true); } else { var newComment = new CommentsDataModel(); newComment.User = comment.User; newComment.Photo = comment.Photo; newComment.Comment = comment.Comment; newComment.Title = comment.Title; newComment.Datecreated = comment.Datecreated; newComment.Dateupdated = comment.Dateupdated; newComment.UserID = comment.UserID; newComment.PhotoID = comment.PhotoID; ctx.Comments.Add(newComment); ctx.SaveChanges(); return(true); } } } catch (Exception e) { //Handle exceptions } return(false); }
public bool Delete(int ID) { using (var ctx = new MVCContext()) { var album = ctx.Albums.Where(g => g.ID == ID) .Include(g => g.photos) .Include(g => g.User) . FirstOrDefault(); if (album != null) { foreach (var phot in album.photos) { ctx.Comments.RemoveRange(phot.Comments); } ctx.Photos.RemoveRange(album.photos); ctx.Albums.Remove(album); ctx.SaveChanges(); return(true); } } return(false); }
public bool AddOrUpdate(UserDataModel user) { try { using (var ctx = new MVCContext()) { var userToUpdate = ctx.Users.Where(u => u.ID == user.ID) .Include(u => u.Albums) .Include(u => u.Comments) .Include(u => u.Photos) .FirstOrDefault(); if (userToUpdate != null) { userToUpdate.FirstName = user.FirstName; userToUpdate.LastName = user.LastName; userToUpdate.email = user.email; userToUpdate.Idguid = user.Idguid; ctx.SaveChanges(); return(true); } else { var newUser = new UserDataModel(); newUser.FirstName = user.FirstName; newUser.LastName = user.LastName; newUser.email = user.email; newUser.Idguid = user.Idguid; ctx.Users.Add(newUser); ctx.SaveChanges(); return(true); } } } catch (Exception e) { //Handle exceptions } return(false); }
public bool AddOrUpdate(AlbumDataModel album) { try { using (var ctx = new MVCContext()) { var albumToUpdate = ctx.Albums.Where(g => g.ID == album.ID) .Include(g => g.photos) .Include(g => g.User) .FirstOrDefault(); if (albumToUpdate != null) { albumToUpdate.Name = album.Name; albumToUpdate.Description = album.Description; ctx.SaveChanges(); return(true); } else { var newAlbum = new AlbumDataModel(); newAlbum.UserID = album.UserID; newAlbum.User = album.User; newAlbum.Name = album.Name; newAlbum.Description = album.Description; newAlbum.DateCreated = DateTime.Now; ctx.Albums.Add(newAlbum); ctx.SaveChanges(); return(true); } } } catch (Exception e) { // handle exceptions } return(false); }
public ActionResult Edit(Student std) { var db = new MVCContext(); if (ModelState.IsValid) { db.Entry(std).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(std)); }
public ActionResult Index() { var context = new MVCContext(); context.Student.Add(new Student { Name = "lusi" }); context.SaveChanges(); var student = context.Student.FirstOrDefault(); ViewBag.Name = student.Name; return(View()); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MVCContext(serviceProvider.GetRequiredService <DbContextOptions <MVCContext> >())) { if (context.Movie.Any()) { return; // DB has been seeded } context.Movie.AddRange( new Movie { Title = "When Harry Met Sally", ReleaseDate = DateTime.Parse("1989-2-12"), Genre = "Romantic Comedy", Price = 7.99M }, new Movie { Title = "Ghostbusters ", ReleaseDate = DateTime.Parse("1984-3-13"), Genre = "Comedy", Price = 8.99M }, new Movie { Title = "Ghostbusters 2", ReleaseDate = DateTime.Parse("1986-2-23"), Genre = "Comedy", Price = 9.99M }, new Movie { Title = "Rio Bravo", ReleaseDate = DateTime.Parse("1959-4-15"), Genre = "Western", Price = 3.99M } ); context.SaveChanges(); } }
public bool Delete(int id) { using (var ctx = new MVCContext()) { var comment = ctx.Comments.Where(c => c.ID == id) .Include(c => c.User) .Include(c => c.Photo) .FirstOrDefault(); if (comment != null) { ctx.Comments.Remove(comment); ctx.SaveChanges(); return(true); } } return(false); }
public bool Delete(int id) { using (var ctx = new MVCContext()) { var photo = ctx.Photos.Where(p => p.ID == id) .Include(p => p.User) .Include(p => p.Comments) .Include(p => p.Album) .FirstOrDefault(); if (photo != null) { ctx.Comments.RemoveRange(photo.Comments); ctx.Photos.Remove(photo); ctx.SaveChanges(); return(true); } else { return(false); } } }
public bool Delete(int id) { using (var ctx = new MVCContext()) { var user = ctx.Users.Where(u => u.ID == id) .Include(u => u.Albums) .Include(u => u.Comments) .Include(u => u.Photos) .FirstOrDefault(); if (user != null) { //ta bort allt relaterat till user ctx.Photos.RemoveRange(user.Photos); ctx.Comments.RemoveRange(user.Comments); ctx.Albums.RemoveRange(user.Albums); ctx.Users.Remove(user); ctx.SaveChanges(); return(true); } } return(false); }