public ActionResult AddTrudoustrReady(DateTime? DataObzvon, int idStud, DateTime? DataNachTrudoustr, int Dolzhnost, int ZarPlata, int Predpr, bool? RabPoSpec, DateTime? DataOkonTrudoustr) { Trudoustr res = new Trudoustr() { DataBegin = DataNachTrudoustr, DataObzvon = DataObzvon, DataEnd = DataOkonTrudoustr, IDDolznost = Dolzhnost, IDPredpriyatie = Predpr, RabotaPoSpec = RabPoSpec, ZarPlata = ZarPlata, IDStudent = idStud }; ugtu_db.Trudoustr.InsertOnSubmit(res); ugtu_db.SubmitChanges(); return RedirectToAction("StudentKaryera", new { id = idStud }); }
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 ZakrRegTr(int idVakans, int idRes) { int idStud = (int)(ugtu_db.Resume.Where(arg => arg.idResume == idRes).Select(resume => resume.idStud).ToList().First()); var qv = ugtu_db.Resume.Where(resume => resume.idResume == idRes); foreach (var resume in qv) { resume.idVakans = idVakans; } ugtu_db.SubmitChanges(); var idDol = (ugtu_db.Vakans.Where(vakans => vakans.idVakans == idVakans).Select(vakans => vakans.idDolznost).First()); var idPred = (ugtu_db.Vakans.Where(vakans => vakans.idVakans == idVakans).Select(vakans => vakans.idPredpr).First()); Trudoustr Tr = new Trudoustr() { IDVakans = idVakans, IDDolznost = idDol, IDStudent = idStud, IDResume = idRes, IDPredpriyatie = idPred }; ugtu_db.Trudoustr.InsertOnSubmit(Tr); ugtu_db.SubmitChanges(); return RedirectToAction("StudentResume", new { id = idStud }); }
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"); } } }
private void detach_Trudoustr(Trudoustr entity) { this.SendPropertyChanging(); entity.Predpriyatie = null; }
private void detach_Trudoustr(Trudoustr entity) { this.SendPropertyChanging(); entity.Dolznost = null; }
private void attach_Trudoustr(Trudoustr entity) { this.SendPropertyChanging(); entity.Student = this; }
partial void DeleteTrudoustr(Trudoustr instance);
partial void UpdateTrudoustr(Trudoustr instance);
partial void InsertTrudoustr(Trudoustr instance);
private void detach_Trudoustr(Trudoustr entity) { this.SendPropertyChanging(); entity.discpln = null; }
//закрыттие регистрации при нахождении работы самим обратившимся используется в связке с SaveVipusknikCloseRegisration_OtkazOtCZS в JS , нужен tru catch!!! public int SaveVipusknikCloseRegisration_WithOutCZS_AddTrud(TrudoustrModel Trud) { using (var ugtu_db = new UGTU_DBDataContext()) { Trudoustr Tr = new Trudoustr() { IDStudent = ugtu_db.Resume.Where(m => m.idResume == Trud.idRes).Select(m => m.idStud).SingleOrDefault(), IDDolznost = AddDolgnost(Trud.NameDolzhnost), IDPredpriyatie = GetIdPredpr(Trud.NamePred), IDResume = Trud.idRes, Otdel=Trud.Otdel, RabotaPoSpec = Trud.RabPoSpec, DataObzvon = Trud.DataObzvon, DataBegin = Trud.DataNachTrudoustr, DataEnd = Trud.DataOkonTrudoustr, ZarPlata = Trud.ZarPlata, DopInfo=Trud.DopInfo }; ugtu_db.Trudoustr.InsertOnSubmit(Tr); ugtu_db.SubmitChanges(); return 1; } }
//закрыттие регистрации при нахождении работы в ЦЗС с добавление трудоустрройства с привязкой вакансии и закрытием резюме и вакансии, нужен tru catch!!! public int SaveVipusknikCloseRegisration_WithCZS_AddTrud(ResumeModel M) { using (var ugtu_db = new UGTU_DBDataContext()) { Param_Resume PR = new Param_Resume() { idParam = ConstRep.IDPARAM_ReasonEndRegistration, idResume = M.idResume, idResumeZnachParam = M.idReasonEndRegistration }; ugtu_db.Param_Resume.InsertOnSubmit(PR); ugtu_db.SubmitChanges(); var resume = ugtu_db.Resume.Where(n => n.idResume == M.idResume); foreach (var r in resume) { r.idStatus = ConstRep.StatusResumeClose; r.UstroenCZS = true; r.DataZakritiya = M.DataZakritiya; r.idVakans = M.idVakans; } ugtu_db.SubmitChanges(); if (M.idVakans != 0) { Trudoustr Tr = new Trudoustr() { IDStudent = ugtu_db.Resume.Where(m => m.idResume == M.idResume).Select(m => m.idStud).SingleOrDefault(), IDDolznost = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.idDolznost).SingleOrDefault(), IDPredpriyatie = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.idPredpr).SingleOrDefault(), IDResume = M.idResume, Otdel = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.OtdelName).SingleOrDefault(), DataObzvon = M.DataZakritiya, DataBegin = M.DataZakritiya, RabotaPoSpec = false, IDVakans = M.idVakans }; ugtu_db.Trudoustr.InsertOnSubmit(Tr); ugtu_db.SubmitChanges(); var vakans = ugtu_db.Vakans.Where(n => n.idVakans == M.idVakans); foreach (var r in vakans) { r.idStatus = ConstRep.StatusVakansClose; r.DataObzvon = M.DataZakritiya; } ugtu_db.SubmitChanges(); } return 1; } }
public string AddFactZanAndTrudoustrSave(FactZanTrud obj) { var PZcount = ugtu_db.PlanZanyat_Student.Where(m => m.DataObzvona == obj.Data && m.idStud == obj.idStud).Count(); if (PZcount == 0) { try { Trudoustr res = new Trudoustr() { DataBegin = obj.DataNachTrudoustr, DataObzvon = obj.Data, DataEnd = obj.DataOkonTrudoustr, IDDolznost = AddDolgnost(obj.NameDolzhnost), IDPredpriyatie = GetIdPredpr(obj.NamePred), RabotaPoSpec = obj.RabPoSpec, RabotaVRegion = obj.RabVReg, ZarPlata = obj.ZarPlata, IDStudent = obj.idStud, Otdel=obj.Otdel, DopInfo=obj.DopInfo, Spravka = obj.BitSpravka }; ugtu_db.Trudoustr.InsertOnSubmit(res); ugtu_db.SubmitChanges(); int id = ugtu_db.Trudoustr.Select(m => m.IDTrudoustr).Max(); PlanZanyat_Student res2 = new PlanZanyat_Student() { DataObzvona = obj.Data, idPlanZanyat = obj.idPlanZan, idStud = obj.idStud, idTrudoustr = id }; ugtu_db.PlanZanyat_Student.InsertOnSubmit(res2); var person = ugtu_db.Person.Where(m => m.nCode == obj.idStud).First(); person.cEmail = obj.Email; person.cSotTel = obj.Tel; ugtu_db.SubmitChanges(); return "1"; } catch (Exception) { return "Ошибка добавления трудоустройства"; } } else { return "Фактическая занятось с такой датой обзвона уже существует"; } }