public void AddStudReg(RegistrData obj) { Resume res = new Resume() { DataPrinytiya = obj.Data, idStatus = obj.idStatus, idStud = obj.idStud }; Console.Write(obj.Data); Console.Write(obj.idStatus); ugtu_db.Resume.InsertOnSubmit(res); ugtu_db.SubmitChanges(); }
private void detach_Resume(Resume entity) { this.SendPropertyChanging(); entity.Status = null; }
partial void DeleteResume(Resume instance);
private void attach_Resume(Resume entity) { this.SendPropertyChanging(); entity.Status = this; }
partial void UpdateResume(Resume instance);
partial void InsertResume(Resume instance);
// Метод записи в БД 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 void AddVipusknikReg(RegistrData obj) { var Res = ugtu_db.Resume.Where(tr => tr.idStud == obj.idStud).ToList(); if (Res.Count() == 0) { Resume res = new Resume() { DataPrinytiya = obj.Data, idStatus = StatusRegistrVipusknika, idStud = obj.idStud }; ugtu_db.Resume.InsertOnSubmit(res); } else { foreach (var R in Res) { R.DataPrinytiya = obj.Data; R.idStatus = StatusRegistrVipusknika; } } var Pers = ugtu_db.Person.Where(tr => tr.nCode == obj.idStud).ToList(); foreach (var P in Pers) { P.cSotTel = obj.Tel; P.cEmail = obj.Email; } if (ugtu_db.PlanZanyat_Student.Join(ugtu_db.PlanZanyat, PZS => PZS.idPlanZanyat, PZ => PZ.IDPlanZanyat, (PZS, PZ) => new { PZS, PZ }).Where(@t => @t.PZS.idStud == obj.idStud && t.PZ.IDTypeZan == PlanTypeZan).Select(arg => arg.PZS.DataObzvona).Count() == 0)//ugtu_db.PlanZanyat_Student.Where(student => student.idStud == obj.idStud).Count() == 0 { PlanZanyat_Student PZS = new PlanZanyat_Student() { DataObzvona = obj.Data, idPlanZanyat = obj.idPlanZan, idStud = obj.idStud }; ugtu_db.PlanZanyat_Student.InsertOnSubmit(PZS); } else { var f = (from PZS in ugtu_db.PlanZanyat_Student where PZS.idStud == obj.idStud && PZS.idPlanZanyat_Student == obj.idPlanZanStud select PZS).First(); f.DataObzvona = obj.Data; f.idPlanZanyat = obj.idPlanZan; f.idStud = obj.idStud; } ugtu_db.SubmitChanges(); //var lang=(ugtu_db.Lang_stud.Where(l=>l.nCode==obj.idStud).Select(l=>l.Ik_lang)).ToList(); // if (obj.Check.Count() > 0) //{ // foreach(var c in obj.Check){ // if (ugtu_db.Lang_stud.Where(l => l.nCode == obj.idStud && l.Ik_lang == c).Count() == 0) // { // Lang_stud LS = new Lang_stud() // { // nCode = obj.idStud, // Ik_lang = c // }; // ugtu_db.Lang_stud.InsertOnSubmit(LS); // } // } //} //if (ugtu_db.Lang_stud.Where(l => l.nCode == obj.idStud && l.Ik_lang == c).Count() > 0) //{ // var f = (from langSt in ugtu_db.Lang_stud // where langSt.nCode == obj.idStud && langSt.Ik_lang==c // select langSt); // //f.Ik_lang = c; // //f.nCode = obj.idStud; // foreach (var detail in f) // { // ugtu_db.Lang_stud.DeleteOnSubmit(detail); // }; //} ugtu_db.SubmitChanges(); }
public void AddStudReg(RegistrData obj) { Resume res = new Resume() { DataPrinytiya = obj.Data, idStatus =obj.idStatus, idStud = obj.idStud }; Console.Write(obj.Data); Console.Write(obj.idStatus); ugtu_db.Resume.InsertOnSubmit(res); ugtu_db.SubmitChanges(); int idres=ugtu_db.Resume.Select(resume => resume.idResume).Max(); Dolznost_Resume DR = new Dolznost_Resume() { idDolznost = obj.IDDolznost, idResume = idres }; ugtu_db.Dolznost_Resume.InsertOnSubmit(DR); ugtu_db.SubmitChanges(); }