public ActionResult EditVakansiyaSave(VakansiyaModel VM, int KolChel)
{
if (ModelState.IsValid)
{
var Vak = ugtu_db.Vakans.Where(vakans => vakans.idVakans == VM.ID).Single();
// V.VakansName = VM.VakansName;
Vak.idDolznost = (int)AddDolgnost(VM.Dolgnost);
Vak.idPredpr = GetIdPredpr(VM.NamePred);
Vak.DataPostVakans = VM.DataPostVakans;
Vak.KolChel = KolChel;
Vak.DolgnostnObyazan = VM.DolgnObyaz;
Vak.InfoGrafikRab = VM.InfoGrafikRab;
Vak.DopInfo = VM.DopInfo;
Vak.Lgoty = VM.Lgoty;
Vak.idStatus = VM.idStatus;
Vak.DataObzvon = VM.DataObzvon;
Vak.TrebKandidat = VM.TrebKandidat;
Vak.ZarPlata = VM.Zarplata;
Vak.OtdelName = VM.OtdelName;
var ParVakans = ugtu_db.Param_Vakans.Where(vakans => vakans.idVakans == VM.ID && vakans.idParam == idParamTipZan);
foreach (var PV in ParVakans)
{
PV.idParamZnachVakans = VM.idTipZan;
}
var SpecsVakans = ugtu_db.Vakans_Specs.Where(vakans => vakans.idVakans == VM.ID).ToList();
foreach (var c in SpecsVakans)
{
ugtu_db.Vakans_Specs.DeleteOnSubmit(c);
}
ugtu_db.SubmitChanges();
for (int j = 0; j < VM.specs.Count(); j++)
{
if (VM.specs[j].ValSpec)
{
Vakans_Specs VS = new Vakans_Specs()
{
idSpecs = VM.specs[j].idSpec,
idVakans = VM.ID
};
ugtu_db.Vakans_Specs.InsertOnSubmit(VS);
}
}
ugtu_db.SubmitChanges();
//if (VM.Specs.Count() == SpecsVakans.Count())
//{
// int i = 0;
// foreach(var c in SpecsVakans)
// {
// c.idSpecs = VM.Specs[i];
// c.idVakans = VM.ID;
// i++;
// }
//}
//if (VM.Specs.Count() > SpecsVakans.Count())
//{
// int i = 0;
// foreach (var c in SpecsVakans)
// {
// c.idSpecs = VM.Specs[i];
// c.idVakans = VM.ID;
// i++;
// }
// for (int j = 0; j < VM.Specs.Count() - SpecsVakans.Count(); j++)
// {
// Vakans_Specs VS = new Vakans_Specs()
// {
// idSpecs = VM.Specs[j+i],
// idVakans = VM.ID
// };
// ugtu_db.Vakans_Specs.InsertOnSubmit(VS);
// }
//}
//if (VM.Specs.Count() < SpecsVakans.Count())
//{
// for (int j = 0; j < SpecsVakans.Count()-VM.Specs.Count(); j++)
// {
// ugtu_db.Vakans_Specs.DeleteOnSubmit(SpecsVakans.ToList()[j]);
// }
// for (int j = 0; j < VM.Specs.Count(); j++)
// {
// SpecsVakans.ToList()[j].idSpecs = VM.Specs[j];
// SpecsVakans.ToList()[j].idVakans = VM.ID;
// }
//}
return RedirectToAction("VakansiyaInfo", new { id = VM.ID });
}
else { return RedirectToAction("VakansiyaEdit", new { id = VM.ID }); };
}
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"); }
}
partial void DeleteVakans_Specs(Vakans_Specs instance);
partial void UpdateVakans_Specs(Vakans_Specs instance);
partial void InsertVakans_Specs(Vakans_Specs instance);
private void detach_Vakans_Specs(Vakans_Specs entity)
{
this.SendPropertyChanging();
entity.Vakans = null;
}
private void attach_Vakans_Specs(Vakans_Specs entity)
{
this.SendPropertyChanging();
entity.Vakans = this;
}