public ActionResult ViborGruppi()
{
try
{
var contextDB = new Models.dbBRSEntities();
int Facultet_ID = int.Parse(Request.QueryString.Get(0));
var Grupps =
from gruppa in contextDB.tableGrupp
where gruppa.IDFacultet == Facultet_ID
orderby gruppa.Name
select gruppa;
ViewBag.Gruppi = Grupps;
string FacultetName;
FacultetName = (from t in contextDB.tableFacultet where t.ID == Facultet_ID select t.Name).First().ToString();
ViewBag.FacultetName = FacultetName;
return(View());
}
catch
{
return(View("Error"));
}
}
public ActionResult ViborDisciplini()
{
try
{
var contextDB = new Models.dbBRSEntities();
int Facultet_ID = int.Parse(Request.QueryString.Get(0));
int Grupp_ID = int.Parse(Request.QueryString.Get(1));
var Disciplins =
from disciplinaID in contextDB.tablePrinadlegnistDisciplin
where disciplinaID.ID_Facultet == Facultet_ID && disciplinaID.ID_Gruppi == Grupp_ID && disciplinaID.ID_Disciplini == disciplinaID.tableDisciplin.ID
orderby disciplinaID.ID_Disciplini
select disciplinaID.tableDisciplin;
ViewBag.Disciplini = Disciplins;
string[] Dannie = new string[3];
Dannie[0] = (from t in contextDB.tableFacultet where t.ID == Facultet_ID select t.Name).First().ToString();
Dannie[1] = (from t in contextDB.tableGrupp where t.ID == Grupp_ID select t.Name).First().ToString();
ViewBag.Dannie = Dannie;
return(View());
}
catch
{
return(View("Error"));
}
}
public ActionResult ViborFaculteta()
{
var contextDB = new Models.dbBRSEntities();
var facults =
from f in contextDB.tableFacultet
orderby f.Name
select f;
ViewBag.Faculteti = facults;
return(View());
}
public ActionResult BalliPoVsemPredmetam(string Facultet, string Gruppa)
{
try
{
var contextDB = new Models.dbBRSEntities();
int Facultet_ID = int.Parse(Facultet);
int Grupp_ID = int.Parse(Gruppa);
var Disciplins =
from disciplinaID in contextDB.tablePrinadlegnistDisciplin
where disciplinaID.ID_Facultet == Facultet_ID && disciplinaID.ID_Gruppi == Grupp_ID && disciplinaID.ID_Disciplini == disciplinaID.tableDisciplin.ID
orderby disciplinaID.tableDisciplin.Name
select disciplinaID.tableDisciplin;
var students =
from stud in contextDB.tableStudents
where stud.ID_Gruppi == Grupp_ID
orderby stud.Name
select stud;
var itogi =
from i in contextDB.tableBalli
from s in students
where s.ID == i.ID_Studenta
select new SvodnayaVedomost {
Student_ID = s.ID, Student = s.Name, Disciplina_ID = i.ID_Disciplini, Itog = i.Itog
};
ViewBag.Faculteti = contextDB.tableFacultet;
ViewBag.Disciplini = Disciplins;
ViewBag.Students = students;
ViewBag.Itogi = itogi;
return(View());
}
catch
{
return(View("Error"));
}
}
public ActionResult PokazatVedomost()
{
try
{
var contextDB = new Models.dbBRSEntities();
int Facultet_ID = int.Parse(Request.QueryString.Get(0));
int Grupp_ID = int.Parse(Request.QueryString.Get(1));
int Disciplina_ID = int.Parse(Request.QueryString.Get(2));
int vidOt =
(from v in contextDB.tablePrinadlegnistDisciplin
where v.ID_Facultet == Facultet_ID && v.ID_Gruppi == Grupp_ID && v.ID_Disciplini == Disciplina_ID
select v.Otchetnost).First();
string vidOtchetnosti = "";
if (vidOt == 1)
{
vidOtchetnosti = "Экзамен";
}
else
{
vidOtchetnosti = "Зачет";
}
var BalliStudnets =
from balli in contextDB.tableBalli
where balli.ID_Gruppi == Grupp_ID && balli.ID_Disciplini == Disciplina_ID
join s in contextDB.tableStudents on balli.ID_Studenta equals s.ID
orderby s.Name
select new Vedomost {
StudentName = s.Name, Pos1 = balli.Pos1, Tek1 = balli.Tek1, Rub1 = balli.Rub1, Pos2 = balli.Pos2, Tek2 = balli.Tek2, Rub2 = balli.Rub2, Samost = balli.Samost, Dosdacha = balli.Dosdacha, Premial = balli.Premial, Itog = balli.Itog
};
ViewBag.Vedomost = BalliStudnets;
string[] Dannie = new string[3];
Dannie[0] = (from t in contextDB.tableFacultet where t.ID == Facultet_ID select t.Name).First().ToString();
Dannie[1] = (from t in contextDB.tableGrupp where t.ID == Grupp_ID select t.Name).First().ToString();
Dannie[2] = (from t in contextDB.tableDisciplin where t.ID == Disciplina_ID select t.Name).First().ToString();
ViewBag.Dannie = Dannie;
//журнал
var students =
from s in contextDB.tableStudents
where Grupp_ID == s.ID_Gruppi
orderby s.Name
select s;
ViewBag.Students = students;
var сhisloZanyatiy =
from d in contextDB.tableZanyatiy
select d;
ViewBag.ChisloZanyatiy = сhisloZanyatiy;
string GruppaName =
(from g in contextDB.tableGrupp
where g.ID == Grupp_ID
select g.Name).First();
ViewBag.GruppaName = GruppaName;
string SubjectName =
(from s in contextDB.tableDisciplin
where s.ID == Disciplina_ID
select s.Name).First();
ViewBag.SubjectName = SubjectName;
ViewBag.VidOtchetnosti = vidOtchetnosti;
ViewBag.DiscipliniVM = DiscipliniVM;
return(View());
}
catch
{
return(View("Error"));
}
}