// Метод записи в БД public int AddResumeSaveBD(ResumeModel resume, int idTipZan) { using (var ugtu_db = new UGTU_DBDataContext()) { Models.ugtuRealTest.File F = null; if (resume.upload != null) { F = new Models.ugtuRealTest.File(); F.ExtensionFile = Path.GetExtension(resume.upload.FileName); byte[] byteFile = null; // считываем переданный файл в массив байтов using (var binaryReader = new BinaryReader(resume.upload.InputStream)) { byteFile = binaryReader.ReadBytes(resume.upload.ContentLength); } F.bFile = byteFile; ugtu_db.File.InsertOnSubmit(F); ugtu_db.SubmitChanges(); } Resume res = new Resume() { DataPrinytiya = resume.DataPrinytiya, idStatus = 1,//StatusResumeOpen, idStud = resume.idStud, DopInfo = resume.DopInfo, Otmetki=resume.Otmetki }; if (F != null) { res.idFile = F.idFile; } else { var fileres = ugtu_db.Resume.Where(m => m.idStud == resume.idStud && m.idFile != null).Select(m => m.idFile).FirstOrDefault(); res.idFile = fileres; } ugtu_db.Resume.InsertOnSubmit(res); if (F != null) { foreach (var r in ugtu_db.Resume.Where(r => r.idStud == resume.idStud)) { if (ugtu_db.File.Where(m => m.idFile == r.idFile).Count() > 0) { ugtu_db.File.DeleteOnSubmit(ugtu_db.File.Where(m => m.idFile == r.idFile).First()); } r.idFile = F.idFile; } } var person = ugtu_db.Person.Where(m => m.nCode == resume.idStud).First(); person.cEmail = resume.mail; person.cSotTel = resume.Tel; ugtu_db.SubmitChanges(); Param_Resume PR = new Param_Resume() { idResumeZnachParam = idTipZan, idParam = ConstRep.idParamTipZan, idResume = res.idResume }; ugtu_db.Param_Resume.InsertOnSubmit(PR); ugtu_db.SubmitChanges(); return res.idResume; } }
// todo: send to svc public static IEnumerable<NavigationDTO> GetNavigationData() { using (var db = new UGTU_DBDataContext()) { return (from Gr in db.Grup join RSF in db.Relation_spec_fac on Gr.ik_spec_fac equals RSF.ik_spec_fac join FE in db.Form_ed on RSF.Ik_form_ed equals FE.Ik_form_ed join S in db.Spec_stud on RSF.ik_spec equals S.ik_spec join F in db.Fac on RSF.ik_fac equals F.Ik_fac join StGr in db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup select new NavigationDTO { yearDateExitGrup = Gr.DateExit.Value.Year, idGrup = Gr.Ik_grup, NameGrup = Gr.Cname_grup, idSpec = S.ik_spec, NameSpec = S.FullName, idFac = F.Ik_fac, NameFac = F.Cname_fac, idPrichOtch = StGr.ik_pricOtch, idFormEd = FE.Ik_form_ed, idDirection = S.ik_direction }).ToList(); } }
//добавление public int AddRabProfSave(string name) { using (var ugtu_db = new UGTU_DBDataContext()) { RabProf Rp = new RabProf() { nameRabProf = name }; ugtu_db.RabProf.InsertOnSubmit(Rp); ugtu_db.SubmitChanges(); return Rp.idRabProf; } }
//добавление public int AddDolgnostSave(string name) { using (var ugtu_db = new UGTU_DBDataContext()) { Dolznost Dol = new Dolznost() { NameDolznost = name }; ugtu_db.Dolznost.InsertOnSubmit(Dol); ugtu_db.SubmitChanges(); return Dol.IDDolznost; } }
public PodobrVakansReport(int idRes) { using (var ugtu_db = new UGTU_DBDataContext()) { PodborList = new List<Podbor>(); PodborList = (from Pr in ugtu_db.Predpriyatie join V in ugtu_db.Vakans on Pr.IDPredpriyatie equals V.idPredpr join D in ugtu_db.Dolznost on V.idDolznost equals D.IDDolznost join PV in ugtu_db.Param_Vakans on V.idVakans equals PV.idVakans join ZP in ugtu_db.ZnachParam on PV.idParamZnachVakans equals ZP.idZnachParam join S in ugtu_db.Status on V.idStatus equals S.idStatus join RV in ugtu_db.Resume_Vakans on V.idVakans equals RV.idVakans into g from RV in g.DefaultIfEmpty() join R in ugtu_db.Resume on RV.idResume equals R.idResume join Pers in ugtu_db.Person on R.idStud equals Pers.nCode join KL_N in ugtu_db.KontaktLico_NaznachKontaktLico on Pr.IDPredpriyatie equals KL_N.IDPredpriyatie into g1 from KL_N in g1.DefaultIfEmpty() join naznKL in ugtu_db.NaznachKontaktLico on KL_N.IDNaznachKontaktL equals naznKL.IDNaznachKontaktL into g2 from naznKL in g2.DefaultIfEmpty() join KL in ugtu_db.KontaktLico on KL_N.IDKontaktL equals KL.IDKontaktL into g3 from KL in g3.DefaultIfEmpty() join KL_S in ugtu_db.KontaktLico_Svyaz on KL.IDKontaktL equals KL_S.IDKontaktL into g4 from KL_S in g4.DefaultIfEmpty() join TS in ugtu_db.TipSvyazi on KL_S.IDTSvyazi equals TS.IDTSvyazi into g5 from TS in g5.DefaultIfEmpty() where (TS.IDTSvyazi == ConstRep.TSvyaziTel || TS.IDTSvyazi == null)//телефон && (KL_N.IDNaznachKontaktL == ConstRep.NaznachKLTrud || KL_N.IDNaznachKontaktL == null) //по трудоустройтсву && RV.idResume == idRes select new Podbor() { FIO = Pers.PersonFullName, NamePred = Pr.Name, Dolznost = D.NameDolznost, FIOKontaktLico = KL.FIOKontaktLico, Tel = KL_S.Znach }).ToList(); } }
public TrudoustrModel InfoTrudoustr(int idTrud) { using (var ugtu_db = new UGTU_DBDataContext()) { var InfoTrud = (from Tr in ugtu_db.Trudoustr join D in ugtu_db.Dolznost on Tr.IDDolznost equals D.IDDolznost //into Dol from D in Dol.DefaultIfEmpty() join P in ugtu_db.Predpriyatie on Tr.IDPredpriyatie equals P.IDPredpriyatie join R in ugtu_db.Resume on Tr.IDResume equals R.idResume into Res from R in Res.DefaultIfEmpty() join V in ugtu_db.Vakans on Tr.IDVakans equals V.idVakans into Vak from V in Vak.DefaultIfEmpty() join F in ugtu_db.File on Tr.IDFile equals F.idFile into f from F in f.DefaultIfEmpty() where Tr.IDTrudoustr == idTrud select new TrudoustrModel() { BitSpravka = Tr.Spravka, isFile=(Tr.IDFile!=null)?true:false, DataNachTrudoustr = Tr.DataBegin, DataObzvon = Tr.DataObzvon, DataOkonTrudoustr = Tr.DataEnd, idDolzhnost = Tr.IDDolznost, NameDolzhnost=D.NameDolznost, idPredpr = Tr.IDPredpriyatie, Otdel=Tr.Otdel, DopInfo=Tr.DopInfo, NamePred=P.Name, RabPoSpec = Tr.RabotaPoSpec, ZarPlata = Tr.ZarPlata, idRes = R.idResume, NameVak = D.NameDolznost, idVak = V.idVakans, idTrud=Tr.IDTrudoustr, idStud=Convert.ToInt32(Tr.IDStudent) }).SingleOrDefault(); return InfoTrud; } }
public ActionResult EditTrudoustr(int idTrud, string Path) { TrudoustrModel InfoTrud = new TrudoustrModel(); InfoTrud = Rep.InfoTrudoustr(idTrud); using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.ToList(), "IDPredpriyatie", "Name", ugtu_db.Trudoustr.Where(trudoustr => trudoustr.IDTrudoustr == idTrud) .Select(trudoustr => trudoustr.IDPredpriyatie) .SingleOrDefault()); //ViewBag.Dolzhnost = new SelectList(ugtu_db.Dolznost.ToList(), "IDDolznost", "NameDolznost", // ugtu_db.Trudoustr.Where(trudoustr => trudoustr.IDTrudoustr == idTrud) // .Select(trudoustr => trudoustr.IDDolznost) // .SingleOrDefault()); var SpravkaVipusknik = (from Pers in ugtu_db.Person join Za in ugtu_db.Zach on Pers.nCode equals Za.nCode join StGr in ugtu_db.StudGrup on Za.Ik_zach equals StGr.Ik_zach join Gr in ugtu_db.Grup on StGr.Ik_grup equals Gr.Ik_grup join Tr in ugtu_db.Trudoustr on Pers.nCode equals Tr.IDStudent where Pers.nCode == InfoTrud.idStud select new { spravka = Tr.Spravka }).ToList(); ViewBag.bitSpravkaAll = false; foreach (var c in SpravkaVipusknik) { if (c.spravka == true) { ViewBag.bitSpravkaAll = true; } } } ViewBag.idStud = InfoTrud.idStud; ViewBag.Path = Path; return PartialView("PartialEditTrudoustr", InfoTrud); }
public int AddTrudoustrSave(TrudoustrModel Trud) { using (var ugtu_db = new UGTU_DBDataContext()) { Models.ugtuRealTest.File F = null; if (Trud.upload != null) { F = new Models.ugtuRealTest.File(); F.ExtensionFile = Path.GetExtension(Trud.upload.FileName); byte[] byteFile = null; // считываем переданный файл в массив байтов using (var binaryReader = new BinaryReader(Trud.upload.InputStream)) { byteFile = binaryReader.ReadBytes(Trud.upload.ContentLength); } F.bFile = byteFile; ugtu_db.File.InsertOnSubmit(F); ugtu_db.SubmitChanges(); } Trudoustr Tr = new Trudoustr() { DataBegin = Trud.DataNachTrudoustr, DataObzvon = Trud.DataObzvon, DataEnd = Trud.DataOkonTrudoustr, IDDolznost = Trud.idDolzhnost, IDPredpriyatie = Trud.idPredpr, RabotaPoSpec = Trud.RabPoSpec, ZarPlata = Trud.ZarPlata, IDStudent = Trud.idStud, Spravka = Trud.BitSpravka, Otdel=Trud.Otdel, DopInfo=Trud.DopInfo }; if (F != null) Tr.IDFile = F.idFile; ugtu_db.Trudoustr.InsertOnSubmit(Tr); ugtu_db.SubmitChanges(); return Tr.IDTrudoustr; } }
// Метод генерации частичного представления public ActionResult AddResume(int idStud, string Path) { using (var ugtu_db = new UGTU_DBDataContext()) { SelectList SelectListTipZan = null; if (Path == "Student") { SelectListTipZan = new SelectList(ugtu_db.ZnachParam.Where(param => param.idParam == ConstRep.idParamTipZan).OrderBy(n => n.ZnachParamName).ToList(), "idZnachParam", "ZnachParamName", ConstRep.idZnachParamVrem); } if (Path == "Vipusknik") { SelectListTipZan = new SelectList(ugtu_db.ZnachParam.Where(param => param.idParam == ConstRep.idParamTipZan).OrderBy(n => n.ZnachParamName).ToList(), "idZnachParam", "ZnachParamName", ConstRep.idZnachParamPost); } ViewBag.idTipZan = SelectListTipZan; ViewBag.Method = "Add"; ViewBag.Path = Path; var mail = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cEmail).FirstOrDefault(); var Tel = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cSotTel).FirstOrDefault(); var fileres = ugtu_db.Resume.Where(m => m.idStud == idStud && m.idFile != null).Select(m => m.idResume).FirstOrDefault(); ViewBag.idResumeFile = fileres; return PartialView("PartialAddResume", new ResumeModel() { mail = mail, Tel = Tel, SelectListTipZan = SelectListTipZan }); } }
public ActionResult NavigationStudent() { using (var ugtu_db = new UGTU_DBDataContext()) { var NavList = Navigation.NavigationForStudent(); List<Names> listFac = Rep.Navigation(NavList); return PartialView("PartialNavStudent", listFac); } }
public ActionResult InfoPraktik(int idPrakt = 0) { using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.ToList(), "IDPredpriyatie", "Name"); ViewBag.Praktiki = new SelectList(ugtu_db.discpln.Where(m => m.ik_type_disc == 2).ToList(), "iK_disc", "cName_disc"); //2-УЧЕБНЫЕ ПРАКТИКИ!!! //ViewBag.idStud = idStud; var Tr = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == idPrakt).SingleOrDefault(); PraktikModel PM = new PraktikModel(); PM.idTrud = Tr.IDTrudoustr; PM.idStud = (int)Tr.IDStudent; PM.idPredpr = Tr.IDPredpriyatie; PM.NamePred = ugtu_db.Predpriyatie.Where(m => m.IDPredpriyatie == Tr.IDPredpriyatie).Select(m => m.Name).SingleOrDefault(); PM.idVidPraktiki = Tr.IDVidPraktiki; PM.VidPraktiki = ugtu_db.discpln.Where(m => m.iK_disc == Tr.IDVidPraktiki).Select(m => m.cName_disc).SingleOrDefault(); PM.Otdel = Tr.Otdel; PM.DataNachTrudoustr = Tr.DataBegin; PM.DataOkonTrudoustr = Tr.DataEnd; PM.DataObzvon = Tr.DataObzvon; PM.DopInfo = Tr.DopInfo; return PartialView("PartialPraktikStudentInfo",PM); } }
public ActionResult EditPraktikSave(PraktikModel Trud, string Path) { using (var ugtu_db = new UGTU_DBDataContext()) { var Tr = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == Trud.idTrud).SingleOrDefault(); Tr.IDStudent = Trud.idStud; Tr.IDVidPraktiki = Trud.idVidPraktiki; Tr.Otdel = Trud.Otdel; Tr.IDPredpriyatie = GetIdPredpr(Trud.NamePred); Tr.DataBegin = Trud.DataNachTrudoustr; Tr.DataEnd = Trud.DataOkonTrudoustr; Tr.DataObzvon = Trud.DataObzvon; Tr.DopInfo = Trud.DopInfo; ugtu_db.SubmitChanges(); return RedirectToAction("PraktikStudentInfo", new { idPrakt = Tr.IDTrudoustr }); } }
public ActionResult AddPraktikSave(PraktikModel Trud, string Path) { using (var ugtu_db = new UGTU_DBDataContext()) { try { Trudoustr Tr = new Trudoustr() { DataBegin = Trud.DataNachTrudoustr, DataObzvon = Trud.DataObzvon, DataEnd = Trud.DataOkonTrudoustr, IDPredpriyatie = GetIdPredpr(Trud.NamePred), IDStudent = Trud.idStud, Otdel = Trud.Otdel, DopInfo = Trud.DopInfo, IDVidPraktiki = Trud.idVidPraktiki }; ugtu_db.Trudoustr.InsertOnSubmit(Tr); ugtu_db.SubmitChanges(); return RedirectToAction("PraktikStudentInfo", new { idPrakt = Tr.IDTrudoustr }); } catch (Exception e) { //ViewBag.Message = e.Message; return View("Error"); } } }
//удаление public int DeleteSferaSave(int id) { using (var ugtu_db = new UGTU_DBDataContext()) { var Sf = ugtu_db.Sfera.Where(m => m.IDSfera == id).SingleOrDefault(); ugtu_db.Sfera.DeleteOnSubmit(Sf); ugtu_db.SubmitChanges(); return 1; } }
public ActionResult StudentGrup(int? page, int? size, int id = 0) { int pageNumber = page ?? 1;//номер страницы //int pageSize = KolPage; ViewBag.strlink = "StudentGrup"; ViewBag.Poisk = ""; ViewBag.isGrup = true; HttpCookie myCookie = new HttpCookie("Stud"); myCookie["strlink"] = "StudentGrup/"; myCookie["idPod"] = id.ToString(); myCookie["pageNumber"] = pageNumber.ToString(); Response.Cookies.Add(myCookie); //HttpContext.Response.Cookies["strlink_Stud"].Value = "StudentGrup/"; //HttpContext.Response.Cookies["idPod_Stud"].Value = id.ToString(); //HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString(); //HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes != null) ? OpenRes.Value.ToString() : ""; using (var _ugtuDb = new UGTU_DBDataContext()) { var findStud = Rep.QueryAllStudent().Where(s => s.idGrup == id).ToList(); ViewBag.idgrup = id; ViewBag.Name = "Группа: " + ugtu_db.Grup.Select(Grup => new { Name = Grup.Cname_grup, IdGrup = Grup.Ik_grup }).Where(s => s.IdGrup == id).First().Name; var KolPage = PageSize(findStud, size); return PartialView("Student", findStud.ToPagedList(pageNumber, KolPage)); } }
public ActionResult StudentSpec(int? page, int? size, int id = 0) { int pageNumber = page ?? 1;//номер страницы //int pageSize = KolPage; ViewBag.strlink = "StudentSpec"; ViewBag.Poisk = ""; HttpCookie myCookie = new HttpCookie("Stud"); myCookie["strlink"] = "StudentSpec/"; myCookie["idPod"] = id.ToString(); myCookie["pageNumber"] = pageNumber.ToString(); Response.Cookies.Add(myCookie); // HttpContext.Response.Cookies["strlink_Stud"].Value = "StudentSpec/"; // HttpContext.Response.Cookies["idPod_Stud"].Value = id.ToString(); // HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString(); //HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes != null) ? OpenRes.Value.ToString() : ""; using (var _ugtuDb = new UGTU_DBDataContext()) { var findStud = Rep.QueryAllStudent().Where(s => s.idSpec == id).ToList(); using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.idgrup = id; ViewBag.Name = "Специальность: " + ugtu_db.Spec_stud.Select(spec => new { Name = spec.FullName, IdSpec = spec.ik_spec }).Where(s => s.IdSpec == id).First().Name; } var KolPage = PageSize(findStud, size); return PartialView("Student", findStud.ToPagedList(pageNumber, KolPage)); } }
public ActionResult StudentResumeClose(int id = 0) { ViewBag.Path = "Student"; using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.idStud = ugtu_db.Resume.Where(n => n.idResume == id).Select(n => n.idStud).First(); ViewBag.idRes = id; return PartialView("StudentResumeClose"); } }
//редактирование public int EditRabProfSave(int id, string name) { using (var ugtu_db = new UGTU_DBDataContext()) { if (name.Trim() != "") { var Rp = ugtu_db.RabProf.Where(m => m.idRabProf == id).SingleOrDefault(); if (Rp != null) { Rp.nameRabProf = name; } ugtu_db.SubmitChanges(); return 1; } return 0; } }
//главная вьюха частичная public ActionResult EditRabProf() { using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.DataRabProf = ugtu_db.RabProf .OrderBy(m => m.nameRabProf) .ToList(); return View("PartialEditRabProf"); } }
//редактирование public int EditDolgnostSave(int id, string name) { using (var ugtu_db = new UGTU_DBDataContext()) { if (name.Trim()!="") { var Dol = ugtu_db.Dolznost.Where(dol => dol.IDDolznost == id).SingleOrDefault(); if (Dol != null) { Dol.NameDolznost = name; } ugtu_db.SubmitChanges(); return 1; } return 0; } }
//главная вьюха частичная public ActionResult EditDolgnost() { using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.DataDolgnost = ugtu_db.Dolznost .OrderBy(m => m.NameDolznost) .ToList(); return View("PartialEditDolgnost"); } }
public ActionResult PraktikList(int idStud) { using (var ugtu_db = new UGTU_DBDataContext()) { var ListPraktik = (from Pers in ugtu_db.Person join Tr in ugtu_db.Trudoustr on Pers.nCode equals Tr.IDStudent join Pr in ugtu_db.Predpriyatie on Tr.IDPredpriyatie equals Pr.IDPredpriyatie join VP in ugtu_db.discpln on Tr.IDVidPraktiki equals VP.iK_disc where Pers.nCode == idStud select new PraktikList { nCode = Pers.nCode, DataObzvon = Tr.DataObzvon, DataNach = Tr.DataBegin, DataOkonch = Tr.DataEnd, NamePredpr = Pr.Name, Otdel = Tr.Otdel, idTrud = Tr.IDTrudoustr, VidPraktik=VP.cName_disc }).OrderByDescending(m=>m.DataNach).ToList(); ViewBag.idStud = idStud; return PartialView("PraktikList", ListPraktik); } }
public ActionResult StudentAjax(int? page, string StrPoisk, int?size, bool? OpenRes) { //OpenRes = (Request.Params["amp;OpenRes"] == "True") ? true : OpenRes; //толку нет, js не передает// исправлено, костыль на стороне JS! int pageNumber = page ?? 1;//номер страницы //int pageSize = KolPage; HttpCookie myCookie = new HttpCookie("Stud"); myCookie["StrPoisk"] = Server.UrlEncode(StrPoisk); myCookie["strlink"] = "Student/"; myCookie["pageNumber"] = pageNumber.ToString(); myCookie["OpenRes"] = (OpenRes != null) ? OpenRes.Value.ToString() : ""; Response.Cookies.Add(myCookie); //HttpContext.Response.Cookies["StrPoisk_Stud"].Value = Server.UrlEncode(StrPoisk); //HttpContext.Response.Cookies["strlink_Stud"].Value = "Student/"; //HttpContext.Response.Cookies["idPod_Stud"].Value = ""; //HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString(); //HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes!=null)?OpenRes.Value.ToString():""; ViewBag.strlink = "Student"; ViewBag.OpenRes = OpenRes; using (var _ugtuDb = new UGTU_DBDataContext()) { var findStud = Rep.QueryAllStudent();//все студенты if (OpenRes == true) findStud = findStud.Where(Stud => Stud.idResume != null).OrderByDescending(f => f.DateResume); if (StrPoisk != null) { findStud = findStud.Where(f => f.FIO.ToLower().Contains(StrPoisk.ToLower())); ViewBag.Poisk = StrPoisk; } else ViewBag.Poisk = ""; //if (pageSize == 0) pageSize = 1; var KolPage = PageSize(findStud, size); return PartialView("PartialStudentList", findStud.ToPagedList(pageNumber, KolPage)); } }
//удаление public int DeleteDolgnostSave(int id) { using (var ugtu_db = new UGTU_DBDataContext()) { var Dol = ugtu_db.Dolznost.Where(m => m.IDDolznost == id).SingleOrDefault(); ugtu_db.Dolznost.DeleteOnSubmit(Dol); ugtu_db.SubmitChanges(); return 1; } }
public ActionResult StudentResume(int id) { using (var ugtu_db = new UGTU_DBDataContext()) { var ResumeStud = (from Gr in ugtu_db.Grup join StGr in ugtu_db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup join Za in ugtu_db.Zach on StGr.Ik_zach equals Za.Ik_zach join stud in ugtu_db.Student on Za.nCode equals stud.nCode join Pers in ugtu_db.Person on stud.nCode equals Pers.nCode //join R in ugtu_db.Resume on stud.nCode equals R.idStud //into Res //from R in Res.DefaultIfEmpty() where Pers.nCode == id && StGr.ik_pricOtch == null select new InfoStudent { FIO = Pers.PersonFullName, name_grup = Gr.Cname_grup, d_birth = Pers.Dd_birth, n_zach = Za.Nn_zach, nCode = Pers.nCode, Tel = Pers.cSotTel, Email = Pers.cEmail, }).FirstOrDefault(); //лишний код?!?!?!?!?!? ниже ================================================================================== // var AdresStud = (from PA in ugtu_db.PersonAddress // join AT in ugtu_db.AddressType on PA.ik_AddressType equals AT.ik_AddressType // join A in ugtu_db.Address on PA.ik_address equals A.ik_address // join S in ugtu_db.Street on A.Ik_street equals S.Ik_street // join TS in ugtu_db.Type_street on S.Ik_type_street equals TS.Ik_type_street // join G in ugtu_db.Gorod on S.ik_gorod equals G.Ik_gorod // join TG in ugtu_db.type_gorod on G.ik_type_gorod equals TG.ik_type_gorod // join R in ugtu_db.Raion on G.Ik_raion equals R.Ik_raion // join Reg in ugtu_db.Region on R.Ik_region equals Reg.Ik_region // join St in ugtu_db.Strana on Reg.Ik_strana equals St.Ik_strana // where PA.nCode == id // select new // { // adresType = AT.ik_AddressType, // adres = St.Cstrana + ", " + R.Craion + ", " + TG.cshort_type_gorod + ", " + G.Cgorod + ", " + TS.cshort_type_street + ", " + S.CStreet + ", " + A.BuildingNumber + "-" + A.FlatNumber // }).ToList(); // ResumeStud.adres = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressType).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressType).FirstOrDefault().adres : null; // ResumeStud.adresFact = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeFact).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeFact).FirstOrDefault().adres : null; // ResumeStud.adresVr = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeVr).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeVr).FirstOrDefault().adres : null; //ResumeStud.lang = new List<string>(); // foreach (var lang in ugtu_db.Lang_stud.Where(l => l.nCode == id)) // { // if (ugtu_db.Lang.Where(l => l.Ik_lang == lang.Ik_lang).Select(l => l.Cname_lang).FirstOrDefault() != null) // ResumeStud.lang.Add(ugtu_db.Lang.Where(l => l.Ik_lang == lang.Ik_lang).Select(l => l.Cname_lang).FirstOrDefault()); // } //лишний код?!?!?!?!?!? выше ================================================================================== var ResumeList = (from Res in ugtu_db.Resume join St in ugtu_db.Status on Res.idStatus equals St.idStatus where Res.idStud == id select new ResumeModel { DataPrinytiya = Res.DataPrinytiya, UstroenCZS = Res.UstroenCZS, DataZakritiya = Res.DataZakritiya, idStatus = Res.idStatus, StatusName = St.StatusName, idResume = Res.idResume, idStud = Res.idStud }).OrderByDescending(m=>m.DataPrinytiya).ToList(); foreach (var list in ResumeList) { if (list.idStatus == StatusResumeClose) { var idResumeZnachParam = ugtu_db.Param_Resume.Where(idParam => idParam.idResume == list.idResume && idParam.idParam == IDPARAM_ReasonEndRegistration).Select(idParam => idParam.idResumeZnachParam).First(); list.Pricina = ugtu_db.ZnachParam.Where(idZnach => idZnach.idParam == IDPARAM_ReasonEndRegistration && idZnach.idZnachParam == idResumeZnachParam).Select(idZnach => idZnach.ZnachParamName).First(); } } //проверка на то, что у студента нет открытых резюме if (ResumeList.Where(m => m.idStatus == StatusResumeOpen).Count() > 0) ViewBag.flOpenRes = true; else ViewBag.flOpenRes = false; ViewBag.ResumeList = ResumeList; ViewBag.Path = "Student"; return PartialView("StudentResume", ResumeStud); } }
//удаление public int DeleteRabProfSave(int id) { using (var ugtu_db = new UGTU_DBDataContext()) { var Rp = ugtu_db.RabProf.Where(m => m.idRabProf == id).SingleOrDefault(); ugtu_db.RabProf.DeleteOnSubmit(Rp); ugtu_db.SubmitChanges(); return 1; } }
public ActionResult StudentResumeInfo(int id = 0) { ViewBag.Path = "Student"; using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.idRes = id; ViewBag.idStud = ugtu_db.Resume.Where(m => m.idResume == id).Select(m => m.idStud).FirstOrDefault(); return PartialView("StudentResumeInfo"); } }
//главная вьюха частичная public ActionResult EditSfera() { using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.DataSfera = ugtu_db.Sfera .OrderBy(m => m.NameSfera) .ToList(); return View("PartialEditSfera"); } }
public ActionResult AddPraktik(int idStud = 0) { using (var ugtu_db = new UGTU_DBDataContext()) { ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.OrderBy(Pr=>Pr.Name).ToList(), "IDPredpriyatie", "Name"); ViewBag.Praktiki = new SelectList(ugtu_db.discpln.Where(m => m.ik_type_disc == 2).OrderBy(D => D.cName_disc).ToList(), "iK_disc", "cName_disc"); //2-УЧЕБНЫЕ ПРАКТИКИ!!! ViewBag.idStud = idStud; return PartialView("PartialPraktikStudentAdd"); } }
//редактирование public int EditSferaSave(int id, string name) { using (var ugtu_db = new UGTU_DBDataContext()) { if (name.Trim() != "") { var Sf = ugtu_db.Sfera.Where(m => m.IDSfera == id).SingleOrDefault(); if (Sf != null) { Sf.NameSfera = name; } ugtu_db.SubmitChanges(); return 1; } return 0; } }