public ActionResult EditProject(Models.TeacherModels.TeacherProfile prof)
{
_teaProfile.Stages = new List <Models.TeacherModels.StageContext>();
using (var entity = new Data.TestEntities())
{
var project = entity.projekty.Where(x => x.id_proj == prof.Project.id_proj).FirstOrDefault();
project.nazwa_proj = prof.Project.nazwa_proj;
project.termin_wyk = prof.Project.termin_wyk;
entity.SaveChanges();
var stages = entity.etapy.Where(x => x.id_proj == _idProjInt);
foreach (var item in stages)
{
_teaProfile.Stages.Add(new Models.TeacherModels.StageContext {
Stage = item
});
}
}
return(View(_teaProfile));
}
public ActionResult UpdateStageNote(Models.TeacherModels.TeacherProfile prof)
{
using (var entity = new Data.TestEntities())
{
Data.oceny_etapow stageNote = new Data.oceny_etapow()
{
id_prow = _teaProfile.LoginModel.Teacher.id_prow,
wartosc = prof.Note,
id_student = prof.Student.id_student,
id_etap = prof.Stage.id_etap
};
var query =
"BEGIN "
+ "IF NOT EXISTS(SELECT * FROM oceny_etapow "
+ $"WHERE id_student = {prof.Student.id_student} "
+ $"AND id_etap = {prof.Stage.id_etap} "
+ $"AND id_prow = {_teaProfile.LoginModel.Teacher.id_prow}) "
+ "BEGIN "
+ $"INSERT INTO dbo.oceny_etapow (id_prow, id_student,id_etap, wartosc) VALUES({_teaProfile.LoginModel.Teacher.id_prow},{prof.Student.id_student},{prof.Stage.id_etap},'{prof.Note}')"
+ " END"
+ " ELSE"
+ " BEGIN"
+ $" UPDATE oceny_etapow SET wartosc = {prof.Note} WHERE id_student = {prof.Student.id_student} AND id_etap = {prof.Stage.id_etap} AND id_prow = {_teaProfile.LoginModel.Teacher.id_prow}"
+ " END"
+ " END";
entity.Database.ExecuteSqlCommand(query);
}
return(RedirectToAction("StudentsInProject", _teaProfile));
}
public ActionResult AddStudentToProject(Models.TeacherModels.TeacherProfile prof)
{
using (var entity = new Data.TestEntities())
{
entity.projekty.Where(x => x.id_proj == prof.Project.id_proj).FirstOrDefault().studenci.Add(entity.studenci.Where(a => a.id_student == prof.Student.id_student).FirstOrDefault());
entity.SaveChanges();
entity.Database.ExecuteSqlCommand($"DELETE FROM dbo.zgloszenia WHERE id_proj ={prof.Project.id_proj} and id_student = {prof.Student.id_student}");
}
return(RedirectToAction("StudentsInProject", _teaProfile));
}
public ActionResult CreateStage(Models.TeacherModels.TeacherProfile prof)
{
using (var entity = new Data.TestEntities())
{
Data.etapy stage = new Data.etapy()
{
id_proj = _idProjInt,
nazwa_etapu = prof.Stage.nazwa_etapu,
termin_etapu = prof.Stage.termin_etapu
};
entity.etapy.Add(stage);
entity.SaveChanges();
}
return(RedirectToAction("EditProject", _teaProfile));
}
public ActionResult CreateProject(Models.TeacherModels.TeacherProfile prof)
{
using (var entity = new Data.TestEntities())
{
Data.projekty project = new Data.projekty()
{
nazwa_proj = prof.Project.nazwa_proj,
termin_wyk = Convert.ToDateTime(prof.Project.termin_wyk),
id_zajec = prof.Classe.id_zajec,
id_prow = _teaProfile.LoginModel.Teacher.id_prow
};
entity.projekty.Add(project);
entity.SaveChanges();
}
return(RedirectToAction("TeaProjects", _teaProfile));
}
public RedirectResult _initTeacher(string id)
{
int idInt = Convert.ToInt32(id);
_teaProfile = new Models.TeacherModels.TeacherProfile();
using (var entity = new Data.TestEntities())
{
_teaProfile.LoginModel = new Models.LoginUser()
{
Teacher = entity.prowadzacy.Where(x => x.id_prow == idInt).FirstOrDefault()
};
_teaProfile.Subjects = new List <Data.przedmioty>();
}
return(Redirect("~/Teacher/Index"));
}
public ActionResult AddSubjectNote(Models.TeacherModels.TeacherProfile prof)
{
using (var entity = new Data.TestEntities())
{
var query =
"BEGIN "
+ "IF NOT EXISTS(SELECT * FROM oceny_przedmiotow "
+ $"WHERE id_student = {prof.Student.id_student} "
+ $"AND id_przed = {_idSubInt} "
+ $"AND id_prow = {_teaProfile.LoginModel.Teacher.id_prow}) "
+ "BEGIN "
+ $"INSERT INTO oceny_przedmiotow (id_student, id_przed, id_prow, wartosc_pceny_przedmiot) VALUES ('{prof.Student.id_student}', '{_idSubInt}', '{_teaProfile.LoginModel.Teacher.id_prow}', '{prof.Note}')"
+ " END"
+ " ELSE"
+ " BEGIN"
+ $" UPDATE oceny_przedmiotow SET wartosc_pceny_przedmiot = {prof.Note} WHERE id_student = {prof.Student.id_student} AND id_prow = {_teaProfile.LoginModel.Teacher.id_prow} AND id_przed = {_idSubInt}"
+ " END"
+ " END";
entity.Database.ExecuteSqlCommand(query);
}
return(RedirectToAction("StudentsInSubject", _teaProfile));
}
