private void attach_Param_Resume(Param_Resume entity) { this.SendPropertyChanging(); entity.ZnachParam = this; }
private void detach_Param_Resume(Param_Resume entity) { this.SendPropertyChanging(); entity.Parametr = null; }
partial void UpdateParam_Resume(Param_Resume instance);
partial void DeleteParam_Resume(Param_Resume instance);
partial void InsertParam_Resume(Param_Resume instance);
//закрыттие регистрации при нахождении работы в ЦЗС с добавление трудоустрройства с привязкой вакансии и закрытием резюме и вакансии, нужен 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; } }
//закрыттие регистрации при отказе от услуг цзс, нужен tru catch!!! public int SaveVipusknikCloseRegisration_OtkazOtCZS(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 = false; r.DataZakritiya = M.DataZakritiya; } ugtu_db.SubmitChanges(); return 1; } }
// Метод записи в БД 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; } }
public ActionResult AddResume(int idRes, int[] KatPravList) { int idStud = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes).Select(resume => resume.idStud).First()); if (KatPravList!=null) { foreach (var V in KatPravList) { Param_Resume PR = new Param_Resume() { idResume = idRes, idResumeZnachParam = V, idParam = (int)(ugtu_db.ZnachParam.Where(param => param.idZnachParam==V).Select(param => param.idParam).First()) }; ugtu_db.Param_Resume.InsertOnSubmit(PR); ugtu_db.SubmitChanges(); } } return RedirectToAction("StudentResume", new { id = idStud }); }