private void attach_Param_Resume(Param_Resume entity)
{
this.SendPropertyChanging();
entity.ZnachParam = this;
}
private void detach_Param_Resume(Param_Resume entity)
{
this.SendPropertyChanging();
entity.Parametr = null;
}
partial void UpdateParam_Resume(Param_Resume instance);
partial void DeleteParam_Resume(Param_Resume instance);
partial void InsertParam_Resume(Param_Resume instance);
//закрыттие регистрации при нахождении работы в ЦЗС с добавление трудоустрройства с привязкой вакансии и закрытием резюме и вакансии, нужен tru catch!!!
public int SaveVipusknikCloseRegisration_WithCZS_AddTrud(ResumeModel M)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
Param_Resume PR = new Param_Resume()
{
idParam = ConstRep.IDPARAM_ReasonEndRegistration,
idResume = M.idResume,
idResumeZnachParam = M.idReasonEndRegistration
};
ugtu_db.Param_Resume.InsertOnSubmit(PR);
ugtu_db.SubmitChanges();
var resume = ugtu_db.Resume.Where(n => n.idResume == M.idResume);
foreach (var r in resume)
{
r.idStatus = ConstRep.StatusResumeClose;
r.UstroenCZS = true;
r.DataZakritiya = M.DataZakritiya;
r.idVakans = M.idVakans;
}
ugtu_db.SubmitChanges();
if (M.idVakans != 0)
{
Trudoustr Tr = new Trudoustr()
{
IDStudent = ugtu_db.Resume.Where(m => m.idResume == M.idResume).Select(m => m.idStud).SingleOrDefault(),
IDDolznost = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.idDolznost).SingleOrDefault(),
IDPredpriyatie = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.idPredpr).SingleOrDefault(),
IDResume = M.idResume,
Otdel = ugtu_db.Vakans.Where(m => m.idVakans == M.idVakans).Select(m => m.OtdelName).SingleOrDefault(),
DataObzvon = M.DataZakritiya,
DataBegin = M.DataZakritiya,
RabotaPoSpec = false,
IDVakans = M.idVakans
};
ugtu_db.Trudoustr.InsertOnSubmit(Tr);
ugtu_db.SubmitChanges();
var vakans = ugtu_db.Vakans.Where(n => n.idVakans == M.idVakans);
foreach (var r in vakans)
{
r.idStatus = ConstRep.StatusVakansClose;
r.DataObzvon = M.DataZakritiya;
}
ugtu_db.SubmitChanges();
}
return 1;
}
}
//закрыттие регистрации при отказе от услуг цзс, нужен tru catch!!!
public int SaveVipusknikCloseRegisration_OtkazOtCZS(ResumeModel M)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
Param_Resume PR = new Param_Resume()
{
idParam = ConstRep.IDPARAM_ReasonEndRegistration,
idResume = M.idResume,
idResumeZnachParam = M.idReasonEndRegistration
};
ugtu_db.Param_Resume.InsertOnSubmit(PR);
ugtu_db.SubmitChanges();
var resume = ugtu_db.Resume.Where(n => n.idResume == M.idResume);
foreach (var r in resume)
{
r.idStatus = ConstRep.StatusResumeClose;
r.UstroenCZS = false;
r.DataZakritiya = M.DataZakritiya;
}
ugtu_db.SubmitChanges();
return 1;
}
}
// Метод записи в БД
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 ActionResult AddResume(int idRes, int[] KatPravList)
{
int idStud = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes).Select(resume => resume.idStud).First());
if (KatPravList!=null)
{
foreach (var V in KatPravList)
{
Param_Resume PR = new Param_Resume()
{
idResume = idRes,
idResumeZnachParam = V,
idParam = (int)(ugtu_db.ZnachParam.Where(param => param.idZnachParam==V).Select(param => param.idParam).First())
};
ugtu_db.Param_Resume.InsertOnSubmit(PR);
ugtu_db.SubmitChanges();
}
}
return RedirectToAction("StudentResume", new { id = idStud });
}
