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("База данных успешно обнулена");
}
