public void CloseStedReg(RegistrData obj) { var f = (from R in ugtu_db.Resume where R.idStud == obj.idStud && R.idStatus == 1 // 1 = cтатус резюме что она открыта select R).First(); f.idStatus = obj.idStatus; f.UstroenCZS = obj.bitCZS; f.DataZakritiya = obj.Data; 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(); }
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(); }