public ActionResult EditRealisation(SubjectListViewModel model)
{
if (!model.SemestrID.HasValue)
{
return(RedirectToAction("Index"));
}
EditRealisationViewModel outModel = new EditRealisationViewModel();
outModel.SemestrID = model.SemestrID;
if (model.ERealisationID.HasValue)
{
outModel.RealisationID = model.ERealisationID;
Realisations r = storage.GetRealisation(outModel.RealisationID.Value);
if (r != null)
{
outModel.SemestrID = r.SemesterID;
outModel.SubjectID = r.SubjectID;
outModel.UserID = r.UserID;
outModel.Ver = r.Ver;
outModel.TimeStamp = r.TimeStamp;
}
}
outModel.Professors = storage.GetProfessors();
outModel.Subjects = storage.GetSubjects();
return(View(outModel));
}
public bool AddRealisation(string ver, int semestrID, int subjectID, int?userID)
{
Random rand = new Random();
int id = rand.Next(899999) + 100000;
using (var db = new StorageContext())
{
Semesters semestr = db.Semesters.Find(semestrID);
Subjects subject = db.Subjects.Find(subjectID);
Users user = null;
if (userID.HasValue)
{
user = db.Users.Find(userID.Value);
}
Realisations realisation = new Realisations()
{
RealisationID = id,
Semesters = semestr,
Subjects = subject,
Users = user,
Ver = ver
};
db.Realisations.Add(realisation);
try
{
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
}
public bool AddRegistration(int studentID, int realisationID)
{
Random rand = new Random();
int id = rand.Next(899999) + 100000;
using (var db = new StorageContext())
{
Students s = db.Students.Find(studentID);
Realisations r = db.Realisations.Find(realisationID);
Registrations reg = new Registrations();
reg.RegistrationID = id;
reg.Students = s;
reg.Realisations = r;
db.Registrations.Add(reg);
try
{
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
}
public bool AddGrade(string name, string maxValue, int realisationID)
{
Random rand = new Random();
int id = rand.Next(899999) + 100000;
using (var db = new StorageContext())
{
Realisations r = db.Realisations.Find(realisationID);
Grades grade = new Grades()
{
GradeID = id, Name = name, MaxValue = maxValue, Realisations = r
};
db.Grades.Add(grade);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException)
{
return(false);
}
return(true);
}
}
private Realisations createUniqueRealisation()
{
while (true)
{
Realisations r = g.createRealisation(createUniqueSubject().SubjectID, createUniqueSemester().SemesterID);
if (r != null)
{
realisations.Add(r);
return(r);
}
}
}
public bool SaveRealisation(int realisationID, string ver, int semestrID, int subjectID, int?userID, byte[] timeStamp)
{
using (var db = new StorageContext())
{
Realisations original = db.Realisations.Find(realisationID);
if (original != null)
{
if (!original.TimeStamp.SequenceEqual(timeStamp))
{
return(false);
}
Semesters semestr = db.Semesters.Find(semestrID);
Subjects subject = db.Subjects.Find(subjectID);
Users user = null;
if (userID.HasValue)
{
user = db.Users.Find(userID.Value);
original.Users = user;
}
else
{
original.UserID = null;
}
original.Ver = ver;
original.Semesters = semestr;
original.Subjects = subject;
db.Entry(original).State = System.Data.Entity.EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
return(false);
}
}
