private void RemovePlayer(DatabaseEntities entities, int playerId, bool saveChanges = true) { // Reassign duties foreach (var dutyData in entities.GameDutyDatas.Where(x => x.PlayerId == playerId)) { dutyData.PlayerId = null; } // Remove availabilities foreach (var abData in entities.AvailabilityDatas.Where(x => x.PlayerId == playerId)) { entities.DeleteObject(abData); } entities.DeleteObject(entities.PlayerDatas.Single(x => x.Id == playerId)); if (saveChanges) { entities.SaveChanges(); } }
public ActionResult Delete(int Item) { // TODO: Move all items under this category to parent category using (var database = new DatabaseEntities()) { var category = database.CategoryById(Item); if (category != null) { database.DeleteObject(category); database.SaveChanges(); } } return(RedirectToAction("Index")); }
private void RemoveGame(DatabaseEntities entities, int gameId, bool saveChanges = true) { // Remove availabilities foreach (var data in entities.AvailabilityDatas.Where(x => x.EventId == gameId)) { entities.DeleteObject(data); } // Remove duties foreach (var data in entities.GameDutyDatas.Where(x => x.GameId == gameId)) { entities.DeleteObject(data); } entities.SaveChanges(); entities.GameLocationDatas.DeleteObject(entities.GameLocationDatas.Single(x => x.GameId == gameId)); entities.GameDatas.DeleteObject(entities.GameDatas.Single(x => x.Id == gameId)); if (saveChanges) { entities.SaveChanges(); } }
public ActionResult EntityUpdate() { var db = new DatabaseEntities(); db.Employee.Where(z => z.Id == 1).First().FirstName = "ДЖИМ"; db.DeleteObject(db.Employee.Where(z => z.Id == 5).First()); db.Employee.AddObject(new Employee { Id = 100, FirstName = "ПИТЕР", LastName = "АДАМС", Salary = 100000 }); db.SaveChanges(); return(RedirectToAction("ConnectedRead")); }
/// <summary> /// /// </summary> /// <param name="galleryName"></param> /// <param name="imageName"></param> /// <param name="user"></param> /// <param name="removeVote"></param> /// <exception cref="HttpException">If something went wrong</exception> /// <returns></returns> public GalleryItem Vote(string galleryName, string imageName, IPrincipal user, bool?removeVote = null) { var galleryDirectory = GetGalleryDirectory(galleryName); FileInfo galleryFile; try { galleryFile = galleryDirectory.GetFiles(imageName).First(); } catch (Exception) { throw new HttpException(512, "The image '" + imageName + "' is not in this gallery"); } try { bool?voteStatus = null; var entities = new DatabaseEntities(); var setting = (from set in entities.Settings where set.Gallery == galleryName select set).SingleOrDefault(); if (setting == null || !setting.VotingEnabled) { throw new HttpException(511, "Voting is disabled for this gallery"); } var ownedByUser = entities.Uploads.Any(upload => upload.Gallery == galleryName && upload.User == user.Identity.Name && upload.Image == imageName); if (ownedByUser) { throw new HttpException(513, "You cannot vote your own picture"); } // gets all votes for this image var votes = from vote in entities.Votes where vote.Gallery == galleryName && vote.Image == imageName select vote; // ... and filter by user var userVote = votes.Where(vote => vote.User == user.Identity.Name).SingleOrDefault(); if (userVote != null && removeVote != false) { // Set last change SetLastChange(galleryDirectory); // remove vote entities.DeleteObject(userVote); // commit entities.SaveChanges(); // removed voteStatus = false; } else if (userVote == null) { // Set last change SetLastChange(galleryDirectory); // add new vote entities.Votes.AddObject(new Vote { Gallery = galleryDirectory.Name, Image = galleryFile.Name, User = user.Identity.Name, LastUpdate = DateTime.Now, }); // commit entities.SaveChanges(); // added voteStatus = true; } return(new GalleryItem { FullPath = galleryFile.FullName, Name = galleryFile.Name, UserVote = voteStatus != false, // null or true TotalVotes = setting.StatsEnabled ? votes.Count() : 0, User = user.Identity.Name, Gallery = galleryName }); } catch (HttpException) { throw; } catch (Exception ex) { throw new HttpException(520, "Unable to save changes. " + ex.Message); } }
void RemoveCallbackCore(Item item) { Entities.DeleteObject(item); Entities.BeginSaveChanges(AsyncSaveCallback, null); }
public string Clear() { var db = new DatabaseEntities(); foreach (var p in db.Project) { foreach (var e in p.Employees.ToArray()) { p.Employees.Remove(e); } } db.SaveChanges(); foreach (var p in db.Project) { db.DeleteObject(p); } db.SaveChanges(); foreach (var e in db.Employee) { e.Department = null; } db.SaveChanges(); foreach (var d in db.Department) { db.DeleteObject(d); } db.SaveChanges(); foreach (var e in db.Employee) { db.DeleteObject(e); } db.SaveChanges(0); Employee smith, williams, taylor, stewart; db = new DatabaseEntities(); db.Employee.AddObject(smith = new Employee { Id = 1, FirstName = "Джон", LastName = "Смит", Salary = 30000, }); db.Employee.AddObject(williams = new Employee { Id = 2, FirstName = "Джейн", LastName = "Виллиамс", Salary = 35000, }); db.Employee.AddObject(taylor = new Employee { Id = 3, FirstName = "Алекс", LastName = "Тэйлор", Salary = 40000, }); db.Employee.AddObject(stewart = new Employee { Id = 4, FirstName = "Алиса", LastName = "Стюарт", Salary = 25000 }); db.Employee.AddObject(new Employee { Id = 5, FirstName = "Стивен", LastName = "Кинг", Salary = 10000 }); db.SaveChanges(); db.Department.AddObject(new Department { Id = 1, Name = "Дирекция", Director = smith }); db.Department.AddObject(new Department { Id = 2, Name = "Продажи", Director = williams }); db.SaveChanges(); smith.DepartmentId = 1; williams.DepartmentId = 1; taylor.DepartmentId = 2; stewart.DepartmentId = 2; db.SaveChanges(); var yearReport = new Project { Id = 1, DueDate = new DateTime(2010, 10, 10), Name = "Квартальный отчет", }; yearReport.Employees.Add(smith); yearReport.Employees.Add(williams); var salesReport = new Project { Id = 2, DueDate = new DateTime(2010, 7, 7), Name = "Отчет по продажам" }; salesReport.Employees.Add(taylor); salesReport.Employees.Add(stewart); db.Project.AddObject(yearReport); db.Project.AddObject(salesReport); db.SaveChanges(); return("База данных успешно обнулена"); }