public ActionResult AddTrudoustrReady(DateTime? DataObzvon, int idStud, DateTime? DataNachTrudoustr,
int Dolzhnost, int ZarPlata, int Predpr, bool? RabPoSpec, DateTime? DataOkonTrudoustr)
{
Trudoustr res = new Trudoustr()
{
DataBegin = DataNachTrudoustr,
DataObzvon = DataObzvon,
DataEnd = DataOkonTrudoustr,
IDDolznost = Dolzhnost,
IDPredpriyatie = Predpr,
RabotaPoSpec = RabPoSpec,
ZarPlata = ZarPlata,
IDStudent = idStud
};
ugtu_db.Trudoustr.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
return RedirectToAction("StudentKaryera", new { id = idStud });
}
public int AddTrudoustrSave(TrudoustrModel Trud)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
Models.ugtuRealTest.File F = null;
if (Trud.upload != null)
{
F = new Models.ugtuRealTest.File();
F.ExtensionFile = Path.GetExtension(Trud.upload.FileName);
byte[] byteFile = null;
// считываем переданный файл в массив байтов
using (var binaryReader = new BinaryReader(Trud.upload.InputStream))
{
byteFile = binaryReader.ReadBytes(Trud.upload.ContentLength);
}
F.bFile = byteFile;
ugtu_db.File.InsertOnSubmit(F);
ugtu_db.SubmitChanges();
}
Trudoustr Tr = new Trudoustr()
{
DataBegin = Trud.DataNachTrudoustr,
DataObzvon = Trud.DataObzvon,
DataEnd = Trud.DataOkonTrudoustr,
IDDolznost = Trud.idDolzhnost,
IDPredpriyatie = Trud.idPredpr,
RabotaPoSpec = Trud.RabPoSpec,
ZarPlata = Trud.ZarPlata,
IDStudent = Trud.idStud,
Spravka = Trud.BitSpravka,
Otdel=Trud.Otdel,
DopInfo=Trud.DopInfo
};
if (F != null) Tr.IDFile = F.idFile;
ugtu_db.Trudoustr.InsertOnSubmit(Tr);
ugtu_db.SubmitChanges();
return Tr.IDTrudoustr;
}
}
public ActionResult ZakrRegTr(int idVakans, int idRes)
{
int idStud = (int)(ugtu_db.Resume.Where(arg => arg.idResume == idRes).Select(resume => resume.idStud).ToList().First());
var qv = ugtu_db.Resume.Where(resume => resume.idResume == idRes);
foreach (var resume in qv)
{
resume.idVakans = idVakans;
}
ugtu_db.SubmitChanges();
var idDol = (ugtu_db.Vakans.Where(vakans => vakans.idVakans == idVakans).Select(vakans => vakans.idDolznost).First());
var idPred = (ugtu_db.Vakans.Where(vakans => vakans.idVakans == idVakans).Select(vakans => vakans.idPredpr).First());
Trudoustr Tr = new Trudoustr()
{
IDVakans = idVakans,
IDDolznost = idDol,
IDStudent = idStud,
IDResume = idRes,
IDPredpriyatie = idPred
};
ugtu_db.Trudoustr.InsertOnSubmit(Tr);
ugtu_db.SubmitChanges();
return RedirectToAction("StudentResume", new { id = idStud });
}
public ActionResult AddPraktikSave(PraktikModel Trud, string Path)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
try
{
Trudoustr Tr = new Trudoustr()
{
DataBegin = Trud.DataNachTrudoustr,
DataObzvon = Trud.DataObzvon,
DataEnd = Trud.DataOkonTrudoustr,
IDPredpriyatie = GetIdPredpr(Trud.NamePred),
IDStudent = Trud.idStud,
Otdel = Trud.Otdel,
DopInfo = Trud.DopInfo,
IDVidPraktiki = Trud.idVidPraktiki
};
ugtu_db.Trudoustr.InsertOnSubmit(Tr);
ugtu_db.SubmitChanges();
return RedirectToAction("PraktikStudentInfo", new { idPrakt = Tr.IDTrudoustr });
}
catch (Exception e)
{
//ViewBag.Message = e.Message;
return View("Error");
}
}
}
private void detach_Trudoustr(Trudoustr entity)
{
this.SendPropertyChanging();
entity.Predpriyatie = null;
}
private void detach_Trudoustr(Trudoustr entity)
{
this.SendPropertyChanging();
entity.Dolznost = null;
}
private void attach_Trudoustr(Trudoustr entity)
{
this.SendPropertyChanging();
entity.Student = this;
}
partial void DeleteTrudoustr(Trudoustr instance);
partial void UpdateTrudoustr(Trudoustr instance);
partial void InsertTrudoustr(Trudoustr instance);
private void detach_Trudoustr(Trudoustr entity)
{
this.SendPropertyChanging();
entity.discpln = null;
}
//закрыттие регистрации при нахождении работы самим обратившимся используется в связке с SaveVipusknikCloseRegisration_OtkazOtCZS в JS , нужен tru catch!!!
public int SaveVipusknikCloseRegisration_WithOutCZS_AddTrud(TrudoustrModel Trud)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
Trudoustr Tr = new Trudoustr()
{
IDStudent = ugtu_db.Resume.Where(m => m.idResume == Trud.idRes).Select(m => m.idStud).SingleOrDefault(),
IDDolznost = AddDolgnost(Trud.NameDolzhnost),
IDPredpriyatie = GetIdPredpr(Trud.NamePred),
IDResume = Trud.idRes,
Otdel=Trud.Otdel,
RabotaPoSpec = Trud.RabPoSpec,
DataObzvon = Trud.DataObzvon,
DataBegin = Trud.DataNachTrudoustr,
DataEnd = Trud.DataOkonTrudoustr,
ZarPlata = Trud.ZarPlata,
DopInfo=Trud.DopInfo
};
ugtu_db.Trudoustr.InsertOnSubmit(Tr);
ugtu_db.SubmitChanges();
return 1;
}
}
//закрыттие регистрации при нахождении работы в ЦЗС с добавление трудоустрройства с привязкой вакансии и закрытием резюме и вакансии, нужен 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;
}
}
public string AddFactZanAndTrudoustrSave(FactZanTrud obj)
{
var PZcount = ugtu_db.PlanZanyat_Student.Where(m => m.DataObzvona == obj.Data && m.idStud == obj.idStud).Count();
if (PZcount == 0)
{
try
{
Trudoustr res = new Trudoustr()
{
DataBegin = obj.DataNachTrudoustr,
DataObzvon = obj.Data,
DataEnd = obj.DataOkonTrudoustr,
IDDolznost = AddDolgnost(obj.NameDolzhnost),
IDPredpriyatie = GetIdPredpr(obj.NamePred),
RabotaPoSpec = obj.RabPoSpec,
RabotaVRegion = obj.RabVReg,
ZarPlata = obj.ZarPlata,
IDStudent = obj.idStud,
Otdel=obj.Otdel,
DopInfo=obj.DopInfo,
Spravka = obj.BitSpravka
};
ugtu_db.Trudoustr.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
int id = ugtu_db.Trudoustr.Select(m => m.IDTrudoustr).Max();
PlanZanyat_Student res2 = new PlanZanyat_Student()
{
DataObzvona = obj.Data,
idPlanZanyat = obj.idPlanZan,
idStud = obj.idStud,
idTrudoustr = id
};
ugtu_db.PlanZanyat_Student.InsertOnSubmit(res2);
var person = ugtu_db.Person.Where(m => m.nCode == obj.idStud).First();
person.cEmail = obj.Email;
person.cSotTel = obj.Tel;
ugtu_db.SubmitChanges();
return "1";
}
catch (Exception)
{
return "Ошибка добавления трудоустройства";
}
}
else
{
return "Фактическая занятось с такой датой обзвона уже существует";
}
}
