public JavaScriptResult DeleteDay(string Facultet_ID, string Gruppa_ID, string Disciplina_ID, string PrepodID, string IDZanyatiya) { try { int idZanyatiya = int.Parse(IDZanyatiya); var otmetki = from o in contextDB.tablePoseshenie where o.ID_Zanyatiya == idZanyatiya select o; foreach (var o in otmetki) { contextDB.tablePoseshenie.Remove(o); } var zanyatie = (from z in contextDB.tableZanyatiy where z.ID == idZanyatiya select z).First(); contextDB.tableZanyatiy.Remove(zanyatie); contextDB.SaveChanges(); int GruppaID = int.Parse(Gruppa_ID); int DisciplinaID = int.Parse(Disciplina_ID); int Prepod_ID = int.Parse(PrepodID); var students = from s in contextDB.tableStudents where GruppaID == s.ID_Gruppi orderby s.Name select s; balliZaPoseshenie(GruppaID, DisciplinaID, Prepod_ID, students); var script = "$('input').removeAttr('disabled'); $('#center_loader').hide();" + "window.location ='" + Url.Action("JournalForSubjectofGrupp", "Journal", new { Facultet = Facultet_ID, Gruppa = Gruppa_ID, Predmet = Disciplina_ID, Prepodvatel = PrepodID }) + "' ;"; return(JavaScript(script)); } catch { return(JavaScript("createInfoBlock(4, false, 'Возникла ошибка! Дата не может быть удалена, обратитесь к администратору.');$('input').removeAttr('disabled'); $('#center_loader').hide();")); } }
public ActionResult AddTeacher(string teacherFio) { try { tablePrepods prepodObj = new tablePrepods(); prepodObj.Name = teacherFio; contextDB.tablePrepods.Add(prepodObj); contextDB.SaveChanges(); BRSGSTOU.Translit trans = new Translit(); int prepodID = prepodObj.ID; string Login = trans.TranslitFileName(teacherFio); string Parol = trans.GenPassword(teacherFio).Substring(trans.GenPassword(teacherFio).Length / 2); if (Login.Length > 16) { Login = Login.Substring(0, 16); } if (Parol.Length > 8) { Parol = Parol.Substring(0, 8); } int Rol = 2; contextDB.teachersAccounts.Add(new teachersAccounts { Role_ID = Rol, ID_Prepoda = prepodID, Login = Login, Password = Parol }); contextDB.SaveChanges(); ViewBag.Message = "ok"; return(isAdminMetod()); } catch { return(View("Error")); } }
public JavaScriptResult UpdateStudValue() { int rol = 0; try { rol = (from r in contextDB.teachersAccounts where r.Login == User.Identity.Name select r.Role_ID).First(); } catch { return(JavaScript("createInfoBlock(1, false, 'Возникла ошибка! Баллы не могут быть сохранены, обратитесь к администратору.');")); } if (rol == 2) { try { int Facultet_ID = int.Parse(Request.Params.Get("Facultet_ID")); int Gruppa_ID = int.Parse(Request.Params.Get("Gruppa_ID")); int Disciplina_ID = int.Parse(Request.Params.Get("Disciplina_ID")); string vidBallov = Request.Params.Get("vidBallov"); int Student_ID = int.Parse(Request.Params.Get("student")); int value = int.Parse(Request.Params.Get("value")); string Disciplina = (from t in contextDB.tableDisciplin where t.ID == Disciplina_ID select t.Name).First().ToString(); int Prepod_ID = //2 раза (from t in contextDB.teachersAccounts where t.Login == User.Identity.Name from p in contextDB.tablePrepods where t.ID_Prepoda == p.ID select p.ID).First(); var StudentsPoint = (from sp in contextDB.tableBalli where sp.ID_Gruppi == Gruppa_ID && sp.ID_Disciplini == Disciplina_ID && sp.ID_prepoda == Prepod_ID && sp.ID_Studenta == Student_ID select sp).First(); int tek = 15, rub = 20; if (DiscipliniVM.Contains(Disciplina)) { tek = 10; rub = 25; } if (System.IO.File.Exists(Server.MapPath(Url.Content("/Models/AT.cs")))) { switch (vidBallov) { case "Tek1": value = value > tek ? tek : value; StudentsPoint.Tek1 = value; break; case "Rub1": value = value > rub ? rub : value; StudentsPoint.Rub1 = value; break; } StudentsPoint.Itog = StudentsPoint.Pos1 + StudentsPoint.Tek1 + StudentsPoint.Rub1 + StudentsPoint.Pos2 + StudentsPoint.Tek2 + StudentsPoint.Rub2 + StudentsPoint.Samost + StudentsPoint.Dosdacha + StudentsPoint.Premial; contextDB.SaveChanges(); return(JavaScript("createInfoBlock(1, false, 'Данные сохранены');$('input').removeAttr('disabled'); $('#center_loader').hide();")); } else if (System.IO.File.Exists(Server.MapPath(Url.Content("/Models/ATT.cs")))) { switch (vidBallov) { case "Tek2": value = value > tek ? tek : value; StudentsPoint.Tek2 = value; break; case "Rub2": value = value > rub ? rub : value; StudentsPoint.Rub2 = value; break; case "Samost": value = value > 15 ? 15 : value; StudentsPoint.Samost = value; break; case "Dosdacha": value = value > 20 ? 20 : value; StudentsPoint.Dosdacha = value; break; case "Premial": value = value > 20 ? 20 : value; StudentsPoint.Premial = value; break; } StudentsPoint.Itog = StudentsPoint.Pos1 + StudentsPoint.Tek1 + StudentsPoint.Rub1 + StudentsPoint.Pos2 + StudentsPoint.Tek2 + StudentsPoint.Rub2 + StudentsPoint.Samost + StudentsPoint.Dosdacha + StudentsPoint.Premial; contextDB.SaveChanges(); return(JavaScript("createInfoBlock(1, false, 'Данные сохранены');$('input').removeAttr('disabled'); $('#center_loader').hide();")); } else { return(JavaScript("")); } } catch { return(JavaScript("createInfoBlock(1, false, 'Возникла ошибка! Баллы не могут быть сохранены, обратитесь к администратору.');")); } } else { return(JavaScript("createInfoBlock(1, false, 'Возникла ошибка! Баллы не могут быть сохранены, обратитесь к администратору.');")); } }
public ActionResult SpisokStudentov(string Facultet_ID, string Grupp_ID) { try { int GruppID = int.Parse(Grupp_ID); ViewBag.GruppID = GruppID; ViewBag.Facultet_ID = Facultet_ID; string GruppName = (from gn in contextDB.tableGrupp where gn.ID == GruppID select gn.Name).First(); ViewBag.GruppName = GruppName; int k = 1; foreach (var s in Request.Form.AllKeys) { if (k <= Request.Form.AllKeys.Length - 2) { int idStud = 0; byte otmetka = 0; if (int.TryParse(s, out idStud)) { idStud = int.Parse(s); if (Request.Form.Get(s) == "false") { otmetka = 0; } else { otmetka = 1; } var stud = (from st in contextDB.tableStudents where st.ID == idStud select st).First(); stud.DopuskKSessii = otmetka; } } else { break; } k++; } contextDB.SaveChanges(); var Students = from s in contextDB.tableStudents where s.ID_Gruppi == GruppID select s; ViewBag.Students = Students; ViewBag.Message = "ok"; return(isAdminMetod()); } catch { return(View("Error")); } }