public void Delete(Guid id)
{
using (var DB = new MainContext())
{
DB.Entry(GetProfessorById(id)).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
public bool Add(ProfessorModel data)
{
using (var DB = new MainContext())
{
DB.Professors.Add(data);
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(SpaceModel data)
{
using (var DB = new MainContext())
{
DB.Spaces.Add(data);
DB.SaveChanges();
return true;
}
return false;
}
public bool Edit(ProfessorModel data)
{
using (var DB = new MainContext())
{
DB.Professors.Attach(data);
DB.Entry(data).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(SubjectModel model)
{
using (var DB = new MainContext())
{
DB.Subjects.Add(model);
DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged;
DB.SaveChanges();
return true;
}
return false;
}
public bool ChangeRating(Guid TestId, int Rating)
{
using (var DB = new MainContext())
{
var test = DB.Tests.Where(x => x.Id == TestId).FirstOrDefault();
test.Rating += Rating;
DB.Entry(test).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(StatModel model)
{
using (var DB = new MainContext())
{
model.TestModel.Questions = null;
DB.Stats.Add(model);
DB.Entry(model.TestModel).State = System.Data.Entity.EntityState.Unchanged;
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(TestModel model)
{
model.Creator = new UserProfile()
{
UserId = WebMatrix.WebData.WebSecurity.CurrentUserId,
UserName = WebMatrix.WebData.WebSecurity.CurrentUserName
};
using (var DB = new MainContext())
{
var context = new ValidationContext(model.Infos.First(), serviceProvider: null, items: null);
var validationResults = new List<ValidationResult>();
bool isValid = Validator.TryValidateObject(model.Infos.First(), context, validationResults, true);
if (isValid)
{
DB.Infos.Add(model.Infos.First());
DB.SaveChanges();
}
else
model.Infos.Remove(model.Infos.First());
DB.Tests.Add(model);
DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged;
DB.Entry(model.Subject).State = System.Data.Entity.EntityState.Unchanged;
DB.Entry(model.Creator).State = System.Data.Entity.EntityState.Unchanged;
if (model.Infos != null)
{
foreach (var infoModel in model.Infos)
{
DB.Entry(infoModel).State = System.Data.Entity.EntityState.Unchanged;
}
}
DB.SaveChanges();
return true;
}
return false;
}