public ActionResult AddVakansiya1(string DolgnObyaz, int KolChel, string InfoGrafikRab, string Lgoty, string DopInfo, string VakansName, DateTime DataPostVakans, int Predpr, int Dolzhnost, int TipZan) { DateTime DataObzvon = DataPostVakans; int Status = 1;//открыта Vakans res = new Vakans() { VakansName = VakansName, idPredpr = Predpr, DolgnostnObyazan = DolgnObyaz, InfoGrafikRab = InfoGrafikRab, Lgoty = Lgoty, DopInfo = DopInfo, DataPostVakans = DataPostVakans, DataObzvon = DataObzvon, idDolznost = Dolzhnost, idStatus = Status, KolChel = KolChel }; ugtu_db.Vakans.InsertOnSubmit(res); ugtu_db.SubmitChanges(); var lastid = ugtu_db.Vakans.Select(vakans => vakans.idVakans).Max(); Param_Vakans PV = new Param_Vakans() { idParamZnachVakans = TipZan, idParam = ugtu_db.ZnachParam.Where(param => param.idZnachParam == TipZan) .Select(param => param.idParam) .First(), idVakans = lastid }; ugtu_db.Param_Vakans.InsertOnSubmit(PV); ugtu_db.SubmitChanges(); return RedirectToAction("Vakansiya");// }
private void detach_Param_Vakans(Param_Vakans entity) { this.SendPropertyChanging(); entity.Parametr = null; }
private void attach_Param_Vakans(Param_Vakans entity) { this.SendPropertyChanging(); entity.ZnachParam = this; }
partial void DeleteParam_Vakans(Param_Vakans instance);
partial void UpdateParam_Vakans(Param_Vakans instance);
partial void InsertParam_Vakans(Param_Vakans instance);
public ActionResult AddVakansiyaSave(VakansiyaModel VM, int KolChel) { if (ModelState.IsValid) { //DateTime DataObzvon = VM.DataPostVakans; int Status = 1;//открыта int? lastid = null; Vakans res = new Vakans() { // VakansName = VM.VakansName, idPredpr = GetIdPredpr(VM.NamePred), DolgnostnObyazan = VM.DolgnObyaz, InfoGrafikRab = VM.InfoGrafikRab, Lgoty = VM.Lgoty, DopInfo = VM.DopInfo, DataPostVakans = VM.DataPostVakans, DataObzvon = VM.DataPostVakans,// костыль idDolznost = (int)AddDolgnost(VM.Dolgnost), idStatus = Status, KolChel = KolChel, TrebKandidat = VM.TrebKandidat, ZarPlata = VM.Zarplata, OtdelName = VM.OtdelName }; ugtu_db.Vakans.InsertOnSubmit(res); ugtu_db.SubmitChanges(); lastid = res.idVakans; Param_Vakans PV = new Param_Vakans() { idParamZnachVakans = VM.idTipZan, idParam = ugtu_db.ZnachParam.Where(param => param.idZnachParam == VM.idTipZan) .Select(param => param.idParam) .First(), idVakans = (int)lastid }; ugtu_db.Param_Vakans.InsertOnSubmit(PV); ugtu_db.SubmitChanges(); for (int i = 0; i < VM.specs.Count(); i++) { if (VM.specs[i].ValSpec) { Vakans_Specs VS = new Vakans_Specs() { idSpecs = VM.specs[i].idSpec, idVakans = (int)lastid }; ugtu_db.Vakans_Specs.InsertOnSubmit(VS); ugtu_db.SubmitChanges(); } } return RedirectToAction("VakansiyaInfo", new { id = res.idVakans }); } else { return RedirectToAction("AddVakansiya"); } }