// Метод записи в БД
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 AddResumeSave(ResumeModel rm, string Path, int idTipZan)
{
try
{
int idRes = AddResumeSaveBD(rm, idTipZan);
return RedirectToAction(Path + "ResumeInfo", Path, new { id = idRes });
}
catch (Exception e)
{
ViewBag.Message = e.Message;
return View("Error");
}
}
//закрыттие регистрации при нахождении работы в ЦЗС с добавление трудоустрройства с привязкой вакансии и закрытием резюме и вакансии, нужен 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 ActionResult InfoResume(int idRes, string Path)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.Path = Path;
ViewBag.CloseResume = false;
var idStatus = (ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idStatus).First();
if ((ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idStatus == 3).First()) { ViewBag.CloseResume = true; }//StatusResumeClose
ViewBag.id = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idResume).First();
var idStud = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idStud).First();
ViewBag.idStud = idStud;
if (ViewBag.CloseResume == true)
{
if (ugtu_db.Trudoustr.Where(m => m.IDResume == idRes).Select(m => m.IDTrudoustr).Count() > 0)
{
ViewBag.idTrud = ugtu_db.Trudoustr.Where(m => m.IDResume == idRes).Select(m => m.IDTrudoustr).First();
ViewBag.idVak = ugtu_db.Trudoustr.Where(m => m.IDResume == idRes).Select(m => m.IDVakans).First();
}
}
ResumeModel RM = new ResumeModel()
{
TipZanName = ugtu_db.ZnachParam.Where(m1 => m1.idZnachParam == ugtu_db.Param_Resume.Where(m => m.idParam == ConstRep.idParamTipZan && m.idResume == idRes).Select(m => m.idResumeZnachParam).First()).Select(m1 => m1.ZnachParamName).First(),
DopInfo = (ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.DopInfo).First(),
idResume = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idResume).First(),
idStud = (int)(ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idStud).First(),
DataPrinytiya = DateTime.Parse((ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.DataPrinytiya).First().ToShortDateString()),
StatusName = ugtu_db.Status.Where(n => n.idStatus == idStatus).Select(n => n.StatusName).First(),
Tel = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cSotTel).FirstOrDefault(),
mail = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cEmail).FirstOrDefault(),
Otmetki = (ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.Otmetki).First()
};
if (ugtu_db.Resume.Where(resume => resume.idResume == idRes).First().idFile != null) ViewBag.IsFile = true;
else ViewBag.IsFile = false;
return PartialView("PartialInfoResume", RM);
}
}
// Метод генерации частичного представления
public ActionResult EditResume(int idRes, string Path)
{
using (var ugtu_db1 = new UGTU_DBDataContext())
{
SelectList SelectListTipZan = new SelectList(ugtu_db1.ZnachParam.Where(param => param.idParam == ConstRep.idParamTipZan).OrderBy(n => n.ZnachParamName).ToList(), "idZnachParam", "ZnachParamName",
ugtu_db1.Param_Resume.Where(m => m.idParam == ConstRep.idParamTipZan && m.idResume == idRes).Select(m => m.idResumeZnachParam).Single());
ViewBag.idTipZan = SelectListTipZan;
ViewBag.Method = "Edit";
var c = (ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Single();
var idStud = c.idStud;
ViewBag.idStud = idStud;
ViewBag.id = c.idResume;
ViewBag.Path = Path;
//ViewBag.DopInfo = (ugtu_db.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.DopInfo).First();
//ViewBag.EditRes = true;
// ViewBag.IsFile = (c.idFile != null) ? true : false;
if(c.idFile!=null){
ViewBag.idResumeFile=c.idResume;
}else {
ViewBag.idResumeFile = 0;
}
ResumeModel RM = new ResumeModel();
RM.SelectListTipZan = SelectListTipZan;
RM.DopInfo = (ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.DopInfo).First();
RM.idResume = (int)(ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idResume).First();
RM.idStud = (int)(ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.idStud).First();
RM.DataPrinytiya = (ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.DataPrinytiya).First();
RM.Tel = ugtu_db1.Person.Where(m => m.nCode == idStud).Select(m => m.cSotTel).FirstOrDefault();
RM.mail = ugtu_db1.Person.Where(m => m.nCode == idStud).Select(m => m.cEmail).FirstOrDefault();
RM.Otmetki = (ugtu_db1.Resume.Where(resume => resume.idResume == idRes)).Select(resume => resume.Otmetki).First();
return PartialView("PartialAddResume", RM);
}
}
