partial void DeleteResume_Vakans(Resume_Vakans instance);
partial void UpdateResume_Vakans(Resume_Vakans instance);
partial void InsertResume_Vakans(Resume_Vakans instance);
private void detach_Resume_Vakans(Resume_Vakans entity)
{
this.SendPropertyChanging();
entity.Vakans = null;
}
private void attach_Resume_Vakans(Resume_Vakans entity)
{
this.SendPropertyChanging();
entity.Vakans = this;
}
//public ActionResult PoiskResumePoVakans_Podobrannie(int id)
//{
// var result = (from V in ugtu_db.Vakans
// join RV in ugtu_db.Resume_Vakans on V.idVakans equals RV.idVakans
// join Res in ugtu_db.Resume on RV.idResume equals Res.idResume
// join Pers in ugtu_db.Person on Res.idStud equals Pers.nCode
// join Za in ugtu_db.Zach on Pers.nCode equals Za.nCode
// join SG in ugtu_db.StudGrup on Za.Ik_zach equals SG.Ik_zach
// join Gr in ugtu_db.Grup on SG.Ik_grup equals Gr.Ik_grup
// where RV.idVakans == id
// select new
// {
// id = Res.idResume,
// grup = Gr.Cname_grup,
// FIO = Pers.PersonFullName,
// val = RV.idResume_Vakans
// }).ToList();
// return Json(result, JsonRequestBehavior.AllowGet);
//}
//public int PodborResumeSave(int[] arrayResumeId, int idVakans)
//{
// var ForDelete = ugtu_db.Resume_Vakans.Where(m => m.idVakans == idVakans).ToList();
// if (ForDelete.Count() > 0)
// {
// foreach (var del in ForDelete)
// {
// ugtu_db.Resume_Vakans.DeleteOnSubmit(del);
// }
// ugtu_db.SubmitChanges();
// }
// if (arrayResumeId != null)
// {
// foreach (var resume in arrayResumeId)
// {
// Resume_Vakans RV = new Resume_Vakans()
// {
// DataOtpr = DateTime.Now,
// idVakans = idVakans,
// idResume = resume
// };
// ugtu_db.Resume_Vakans.InsertOnSubmit(RV);
// }
// ugtu_db.SubmitChanges();
// }
// return 1;
//}
public int PodborResumeSave(int[] myArrayForDelete, int[] myArrayForAdd, int idVakans)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
try
{
if (myArrayForDelete != null)
{
foreach (var del in myArrayForDelete)
{
ugtu_db.Resume_Vakans.DeleteOnSubmit(
ugtu_db.Resume_Vakans.SingleOrDefault(rv => rv.idResume_Vakans == del));
}
ugtu_db.SubmitChanges();
}
if (myArrayForAdd != null)
{
foreach (var res in myArrayForAdd)
{
Resume_Vakans RV = new Resume_Vakans()
{
DataOtpr = DateTime.Now,
idVakans = idVakans,
idResume = res
};
ugtu_db.Resume_Vakans.InsertOnSubmit(RV);
}
ugtu_db.SubmitChanges();
}
}
catch (Exception)
{
return -1;
}
return 0;
}
}
