// Метод записи в БД
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;
}
}
// todo: send to svc
public static IEnumerable<NavigationDTO> GetNavigationData()
{
using (var db = new UGTU_DBDataContext())
{
return (from Gr in db.Grup
join RSF in db.Relation_spec_fac on Gr.ik_spec_fac equals RSF.ik_spec_fac
join FE in db.Form_ed on RSF.Ik_form_ed equals FE.Ik_form_ed
join S in db.Spec_stud on RSF.ik_spec equals S.ik_spec
join F in db.Fac on RSF.ik_fac equals F.Ik_fac
join StGr in db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup
select new NavigationDTO
{
yearDateExitGrup = Gr.DateExit.Value.Year,
idGrup = Gr.Ik_grup,
NameGrup = Gr.Cname_grup,
idSpec = S.ik_spec,
NameSpec = S.FullName,
idFac = F.Ik_fac,
NameFac = F.Cname_fac,
idPrichOtch = StGr.ik_pricOtch,
idFormEd = FE.Ik_form_ed,
idDirection = S.ik_direction
}).ToList();
}
}
//добавление
public int AddRabProfSave(string name)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
RabProf Rp = new RabProf()
{
nameRabProf = name
};
ugtu_db.RabProf.InsertOnSubmit(Rp);
ugtu_db.SubmitChanges();
return Rp.idRabProf;
}
}
//добавление
public int AddDolgnostSave(string name)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
Dolznost Dol = new Dolznost()
{
NameDolznost = name
};
ugtu_db.Dolznost.InsertOnSubmit(Dol);
ugtu_db.SubmitChanges();
return Dol.IDDolznost;
}
}
public PodobrVakansReport(int idRes)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
PodborList = new List<Podbor>();
PodborList = (from Pr in ugtu_db.Predpriyatie
join V in ugtu_db.Vakans on Pr.IDPredpriyatie equals V.idPredpr
join D in ugtu_db.Dolznost on V.idDolznost equals D.IDDolznost
join PV in ugtu_db.Param_Vakans on V.idVakans equals PV.idVakans
join ZP in ugtu_db.ZnachParam on PV.idParamZnachVakans equals ZP.idZnachParam
join S in ugtu_db.Status on V.idStatus equals S.idStatus
join RV in ugtu_db.Resume_Vakans on V.idVakans equals RV.idVakans
into g
from RV in g.DefaultIfEmpty()
join R in ugtu_db.Resume on RV.idResume equals R.idResume
join Pers in ugtu_db.Person on R.idStud equals Pers.nCode
join KL_N in ugtu_db.KontaktLico_NaznachKontaktLico on Pr.IDPredpriyatie equals KL_N.IDPredpriyatie
into g1
from KL_N in g1.DefaultIfEmpty()
join naznKL in ugtu_db.NaznachKontaktLico on KL_N.IDNaznachKontaktL equals naznKL.IDNaznachKontaktL
into g2
from naznKL in g2.DefaultIfEmpty()
join KL in ugtu_db.KontaktLico on KL_N.IDKontaktL equals KL.IDKontaktL
into g3
from KL in g3.DefaultIfEmpty()
join KL_S in ugtu_db.KontaktLico_Svyaz on KL.IDKontaktL equals KL_S.IDKontaktL
into g4
from KL_S in g4.DefaultIfEmpty()
join TS in ugtu_db.TipSvyazi on KL_S.IDTSvyazi equals TS.IDTSvyazi
into g5
from TS in g5.DefaultIfEmpty()
where (TS.IDTSvyazi == ConstRep.TSvyaziTel || TS.IDTSvyazi == null)//телефон
&& (KL_N.IDNaznachKontaktL == ConstRep.NaznachKLTrud || KL_N.IDNaznachKontaktL == null) //по трудоустройтсву
&& RV.idResume == idRes
select new Podbor()
{
FIO = Pers.PersonFullName,
NamePred = Pr.Name,
Dolznost = D.NameDolznost,
FIOKontaktLico = KL.FIOKontaktLico,
Tel = KL_S.Znach
}).ToList();
}
}
public TrudoustrModel InfoTrudoustr(int idTrud)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var InfoTrud = (from Tr in ugtu_db.Trudoustr
join D in ugtu_db.Dolznost on Tr.IDDolznost equals D.IDDolznost
//into Dol from D in Dol.DefaultIfEmpty()
join P in ugtu_db.Predpriyatie on Tr.IDPredpriyatie equals P.IDPredpriyatie
join R in ugtu_db.Resume on Tr.IDResume equals R.idResume
into Res
from R in Res.DefaultIfEmpty()
join V in ugtu_db.Vakans on Tr.IDVakans equals V.idVakans
into Vak
from V in Vak.DefaultIfEmpty()
join F in ugtu_db.File on Tr.IDFile equals F.idFile
into f
from F in f.DefaultIfEmpty()
where Tr.IDTrudoustr == idTrud
select new TrudoustrModel()
{
BitSpravka = Tr.Spravka,
isFile=(Tr.IDFile!=null)?true:false,
DataNachTrudoustr = Tr.DataBegin,
DataObzvon = Tr.DataObzvon,
DataOkonTrudoustr = Tr.DataEnd,
idDolzhnost = Tr.IDDolznost,
NameDolzhnost=D.NameDolznost,
idPredpr = Tr.IDPredpriyatie,
Otdel=Tr.Otdel,
DopInfo=Tr.DopInfo,
NamePred=P.Name,
RabPoSpec = Tr.RabotaPoSpec,
ZarPlata = Tr.ZarPlata,
idRes = R.idResume,
NameVak = D.NameDolznost,
idVak = V.idVakans,
idTrud=Tr.IDTrudoustr,
idStud=Convert.ToInt32(Tr.IDStudent)
}).SingleOrDefault();
return InfoTrud;
}
}
public ActionResult EditTrudoustr(int idTrud, string Path)
{
TrudoustrModel InfoTrud = new TrudoustrModel();
InfoTrud = Rep.InfoTrudoustr(idTrud);
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.ToList(), "IDPredpriyatie", "Name",
ugtu_db.Trudoustr.Where(trudoustr => trudoustr.IDTrudoustr == idTrud)
.Select(trudoustr => trudoustr.IDPredpriyatie)
.SingleOrDefault());
//ViewBag.Dolzhnost = new SelectList(ugtu_db.Dolznost.ToList(), "IDDolznost", "NameDolznost",
// ugtu_db.Trudoustr.Where(trudoustr => trudoustr.IDTrudoustr == idTrud)
// .Select(trudoustr => trudoustr.IDDolznost)
// .SingleOrDefault());
var SpravkaVipusknik = (from Pers in ugtu_db.Person
join Za in ugtu_db.Zach on Pers.nCode equals Za.nCode
join StGr in ugtu_db.StudGrup on Za.Ik_zach equals StGr.Ik_zach
join Gr in ugtu_db.Grup on StGr.Ik_grup equals Gr.Ik_grup
join Tr in ugtu_db.Trudoustr on Pers.nCode equals Tr.IDStudent
where Pers.nCode == InfoTrud.idStud
select new
{
spravka = Tr.Spravka
}).ToList();
ViewBag.bitSpravkaAll = false;
foreach (var c in SpravkaVipusknik)
{
if (c.spravka == true)
{
ViewBag.bitSpravkaAll = true;
}
}
}
ViewBag.idStud = InfoTrud.idStud;
ViewBag.Path = Path;
return PartialView("PartialEditTrudoustr", InfoTrud);
}
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 AddResume(int idStud, string Path)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
SelectList SelectListTipZan = null;
if (Path == "Student")
{
SelectListTipZan = new SelectList(ugtu_db.ZnachParam.Where(param => param.idParam == ConstRep.idParamTipZan).OrderBy(n => n.ZnachParamName).ToList(), "idZnachParam", "ZnachParamName", ConstRep.idZnachParamVrem);
}
if (Path == "Vipusknik")
{
SelectListTipZan = new SelectList(ugtu_db.ZnachParam.Where(param => param.idParam == ConstRep.idParamTipZan).OrderBy(n => n.ZnachParamName).ToList(), "idZnachParam", "ZnachParamName", ConstRep.idZnachParamPost);
}
ViewBag.idTipZan = SelectListTipZan;
ViewBag.Method = "Add";
ViewBag.Path = Path;
var mail = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cEmail).FirstOrDefault();
var Tel = ugtu_db.Person.Where(m => m.nCode == idStud).Select(m => m.cSotTel).FirstOrDefault();
var fileres = ugtu_db.Resume.Where(m => m.idStud == idStud && m.idFile != null).Select(m => m.idResume).FirstOrDefault();
ViewBag.idResumeFile = fileres;
return PartialView("PartialAddResume", new ResumeModel() { mail = mail, Tel = Tel, SelectListTipZan = SelectListTipZan });
}
}
public ActionResult NavigationStudent()
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var NavList = Navigation.NavigationForStudent();
List<Names> listFac = Rep.Navigation(NavList);
return PartialView("PartialNavStudent", listFac);
}
}
public ActionResult InfoPraktik(int idPrakt = 0)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.ToList(), "IDPredpriyatie", "Name");
ViewBag.Praktiki = new SelectList(ugtu_db.discpln.Where(m => m.ik_type_disc == 2).ToList(), "iK_disc", "cName_disc"); //2-УЧЕБНЫЕ ПРАКТИКИ!!!
//ViewBag.idStud = idStud;
var Tr = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == idPrakt).SingleOrDefault();
PraktikModel PM = new PraktikModel();
PM.idTrud = Tr.IDTrudoustr;
PM.idStud = (int)Tr.IDStudent;
PM.idPredpr = Tr.IDPredpriyatie;
PM.NamePred = ugtu_db.Predpriyatie.Where(m => m.IDPredpriyatie == Tr.IDPredpriyatie).Select(m => m.Name).SingleOrDefault();
PM.idVidPraktiki = Tr.IDVidPraktiki;
PM.VidPraktiki = ugtu_db.discpln.Where(m => m.iK_disc == Tr.IDVidPraktiki).Select(m => m.cName_disc).SingleOrDefault();
PM.Otdel = Tr.Otdel;
PM.DataNachTrudoustr = Tr.DataBegin;
PM.DataOkonTrudoustr = Tr.DataEnd;
PM.DataObzvon = Tr.DataObzvon;
PM.DopInfo = Tr.DopInfo;
return PartialView("PartialPraktikStudentInfo",PM);
}
}
public ActionResult EditPraktikSave(PraktikModel Trud, string Path)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var Tr = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == Trud.idTrud).SingleOrDefault();
Tr.IDStudent = Trud.idStud;
Tr.IDVidPraktiki = Trud.idVidPraktiki;
Tr.Otdel = Trud.Otdel;
Tr.IDPredpriyatie = GetIdPredpr(Trud.NamePred);
Tr.DataBegin = Trud.DataNachTrudoustr;
Tr.DataEnd = Trud.DataOkonTrudoustr;
Tr.DataObzvon = Trud.DataObzvon;
Tr.DopInfo = Trud.DopInfo;
ugtu_db.SubmitChanges();
return RedirectToAction("PraktikStudentInfo", new { idPrakt = Tr.IDTrudoustr });
}
}
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");
}
}
}
//удаление
public int DeleteSferaSave(int id)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var Sf = ugtu_db.Sfera.Where(m => m.IDSfera == id).SingleOrDefault();
ugtu_db.Sfera.DeleteOnSubmit(Sf);
ugtu_db.SubmitChanges();
return 1;
}
}
public ActionResult StudentGrup(int? page, int? size, int id = 0)
{
int pageNumber = page ?? 1;//номер страницы
//int pageSize = KolPage;
ViewBag.strlink = "StudentGrup";
ViewBag.Poisk = "";
ViewBag.isGrup = true;
HttpCookie myCookie = new HttpCookie("Stud");
myCookie["strlink"] = "StudentGrup/";
myCookie["idPod"] = id.ToString();
myCookie["pageNumber"] = pageNumber.ToString();
Response.Cookies.Add(myCookie);
//HttpContext.Response.Cookies["strlink_Stud"].Value = "StudentGrup/";
//HttpContext.Response.Cookies["idPod_Stud"].Value = id.ToString();
//HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString();
//HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes != null) ? OpenRes.Value.ToString() : "";
using (var _ugtuDb = new UGTU_DBDataContext())
{
var findStud = Rep.QueryAllStudent().Where(s => s.idGrup == id).ToList();
ViewBag.idgrup = id;
ViewBag.Name = "Группа: " + ugtu_db.Grup.Select(Grup => new { Name = Grup.Cname_grup, IdGrup = Grup.Ik_grup }).Where(s => s.IdGrup == id).First().Name;
var KolPage = PageSize(findStud, size);
return PartialView("Student", findStud.ToPagedList(pageNumber, KolPage));
}
}
public ActionResult StudentSpec(int? page, int? size, int id = 0)
{
int pageNumber = page ?? 1;//номер страницы
//int pageSize = KolPage;
ViewBag.strlink = "StudentSpec";
ViewBag.Poisk = "";
HttpCookie myCookie = new HttpCookie("Stud");
myCookie["strlink"] = "StudentSpec/";
myCookie["idPod"] = id.ToString();
myCookie["pageNumber"] = pageNumber.ToString();
Response.Cookies.Add(myCookie);
// HttpContext.Response.Cookies["strlink_Stud"].Value = "StudentSpec/";
// HttpContext.Response.Cookies["idPod_Stud"].Value = id.ToString();
// HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString();
//HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes != null) ? OpenRes.Value.ToString() : "";
using (var _ugtuDb = new UGTU_DBDataContext())
{
var findStud = Rep.QueryAllStudent().Where(s => s.idSpec == id).ToList();
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.idgrup = id;
ViewBag.Name = "Специальность: " + ugtu_db.Spec_stud.Select(spec => new { Name = spec.FullName, IdSpec = spec.ik_spec }).Where(s => s.IdSpec == id).First().Name;
}
var KolPage = PageSize(findStud, size);
return PartialView("Student", findStud.ToPagedList(pageNumber, KolPage));
}
}
public ActionResult StudentResumeClose(int id = 0)
{
ViewBag.Path = "Student";
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.idStud = ugtu_db.Resume.Where(n => n.idResume == id).Select(n => n.idStud).First();
ViewBag.idRes = id;
return PartialView("StudentResumeClose");
}
}
//редактирование
public int EditRabProfSave(int id, string name)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
if (name.Trim() != "")
{
var Rp = ugtu_db.RabProf.Where(m => m.idRabProf == id).SingleOrDefault();
if (Rp != null)
{
Rp.nameRabProf = name;
}
ugtu_db.SubmitChanges();
return 1;
}
return 0;
}
}
//главная вьюха частичная
public ActionResult EditRabProf()
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.DataRabProf = ugtu_db.RabProf
.OrderBy(m => m.nameRabProf)
.ToList();
return View("PartialEditRabProf");
}
}
//редактирование
public int EditDolgnostSave(int id, string name)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
if (name.Trim()!="")
{
var Dol = ugtu_db.Dolznost.Where(dol => dol.IDDolznost == id).SingleOrDefault();
if (Dol != null)
{
Dol.NameDolznost = name;
}
ugtu_db.SubmitChanges();
return 1;
}
return 0;
}
}
//главная вьюха частичная
public ActionResult EditDolgnost()
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.DataDolgnost = ugtu_db.Dolznost
.OrderBy(m => m.NameDolznost)
.ToList();
return View("PartialEditDolgnost");
}
}
public ActionResult PraktikList(int idStud)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var ListPraktik = (from Pers in ugtu_db.Person
join Tr in ugtu_db.Trudoustr on Pers.nCode equals Tr.IDStudent
join Pr in ugtu_db.Predpriyatie on Tr.IDPredpriyatie equals Pr.IDPredpriyatie
join VP in ugtu_db.discpln on Tr.IDVidPraktiki equals VP.iK_disc
where Pers.nCode == idStud
select new PraktikList
{
nCode = Pers.nCode,
DataObzvon = Tr.DataObzvon,
DataNach = Tr.DataBegin,
DataOkonch = Tr.DataEnd,
NamePredpr = Pr.Name,
Otdel = Tr.Otdel,
idTrud = Tr.IDTrudoustr,
VidPraktik=VP.cName_disc
}).OrderByDescending(m=>m.DataNach).ToList();
ViewBag.idStud = idStud;
return PartialView("PraktikList", ListPraktik);
}
}
public ActionResult StudentAjax(int? page, string StrPoisk, int?size, bool? OpenRes)
{
//OpenRes = (Request.Params["amp;OpenRes"] == "True") ? true : OpenRes; //толку нет, js не передает// исправлено, костыль на стороне JS!
int pageNumber = page ?? 1;//номер страницы
//int pageSize = KolPage;
HttpCookie myCookie = new HttpCookie("Stud");
myCookie["StrPoisk"] = Server.UrlEncode(StrPoisk);
myCookie["strlink"] = "Student/";
myCookie["pageNumber"] = pageNumber.ToString();
myCookie["OpenRes"] = (OpenRes != null) ? OpenRes.Value.ToString() : "";
Response.Cookies.Add(myCookie);
//HttpContext.Response.Cookies["StrPoisk_Stud"].Value = Server.UrlEncode(StrPoisk);
//HttpContext.Response.Cookies["strlink_Stud"].Value = "Student/";
//HttpContext.Response.Cookies["idPod_Stud"].Value = "";
//HttpContext.Response.Cookies["pageNumber_Stud"].Value = pageNumber.ToString();
//HttpContext.Response.Cookies["OpenRes"].Value = (OpenRes!=null)?OpenRes.Value.ToString():"";
ViewBag.strlink = "Student";
ViewBag.OpenRes = OpenRes;
using (var _ugtuDb = new UGTU_DBDataContext())
{
var findStud = Rep.QueryAllStudent();//все студенты
if (OpenRes == true) findStud = findStud.Where(Stud => Stud.idResume != null).OrderByDescending(f => f.DateResume);
if (StrPoisk != null)
{
findStud = findStud.Where(f => f.FIO.ToLower().Contains(StrPoisk.ToLower()));
ViewBag.Poisk = StrPoisk;
}
else ViewBag.Poisk = "";
//if (pageSize == 0) pageSize = 1;
var KolPage = PageSize(findStud, size);
return PartialView("PartialStudentList", findStud.ToPagedList(pageNumber, KolPage));
}
}
//удаление
public int DeleteDolgnostSave(int id)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var Dol = ugtu_db.Dolznost.Where(m => m.IDDolznost == id).SingleOrDefault();
ugtu_db.Dolznost.DeleteOnSubmit(Dol);
ugtu_db.SubmitChanges();
return 1;
}
}
public ActionResult StudentResume(int id)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var ResumeStud = (from Gr in ugtu_db.Grup
join StGr in ugtu_db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup
join Za in ugtu_db.Zach on StGr.Ik_zach equals Za.Ik_zach
join stud in ugtu_db.Student on Za.nCode equals stud.nCode
join Pers in ugtu_db.Person on stud.nCode equals Pers.nCode
//join R in ugtu_db.Resume on stud.nCode equals R.idStud
//into Res
//from R in Res.DefaultIfEmpty()
where Pers.nCode == id && StGr.ik_pricOtch == null
select new InfoStudent
{
FIO = Pers.PersonFullName,
name_grup = Gr.Cname_grup,
d_birth = Pers.Dd_birth,
n_zach = Za.Nn_zach,
nCode = Pers.nCode,
Tel = Pers.cSotTel,
Email = Pers.cEmail,
}).FirstOrDefault();
//лишний код?!?!?!?!?!? ниже ==================================================================================
// var AdresStud = (from PA in ugtu_db.PersonAddress
// join AT in ugtu_db.AddressType on PA.ik_AddressType equals AT.ik_AddressType
// join A in ugtu_db.Address on PA.ik_address equals A.ik_address
// join S in ugtu_db.Street on A.Ik_street equals S.Ik_street
// join TS in ugtu_db.Type_street on S.Ik_type_street equals TS.Ik_type_street
// join G in ugtu_db.Gorod on S.ik_gorod equals G.Ik_gorod
// join TG in ugtu_db.type_gorod on G.ik_type_gorod equals TG.ik_type_gorod
// join R in ugtu_db.Raion on G.Ik_raion equals R.Ik_raion
// join Reg in ugtu_db.Region on R.Ik_region equals Reg.Ik_region
// join St in ugtu_db.Strana on Reg.Ik_strana equals St.Ik_strana
// where PA.nCode == id
// select new
// {
// adresType = AT.ik_AddressType,
// adres = St.Cstrana + ", " + R.Craion + ", " + TG.cshort_type_gorod + ", " + G.Cgorod + ", " + TS.cshort_type_street + ", " + S.CStreet + ", " + A.BuildingNumber + "-" + A.FlatNumber
// }).ToList();
// ResumeStud.adres = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressType).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressType).FirstOrDefault().adres : null;
// ResumeStud.adresFact = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeFact).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeFact).FirstOrDefault().adres : null;
// ResumeStud.adresVr = (AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeVr).FirstOrDefault() != null) ? AdresStud.Where(adres => adres.adresType == ConstRep.AdressTypeVr).FirstOrDefault().adres : null;
//ResumeStud.lang = new List<string>();
// foreach (var lang in ugtu_db.Lang_stud.Where(l => l.nCode == id))
// {
// if (ugtu_db.Lang.Where(l => l.Ik_lang == lang.Ik_lang).Select(l => l.Cname_lang).FirstOrDefault() != null)
// ResumeStud.lang.Add(ugtu_db.Lang.Where(l => l.Ik_lang == lang.Ik_lang).Select(l => l.Cname_lang).FirstOrDefault());
// }
//лишний код?!?!?!?!?!? выше ==================================================================================
var ResumeList = (from Res in ugtu_db.Resume
join St in ugtu_db.Status on Res.idStatus equals St.idStatus
where Res.idStud == id
select new ResumeModel
{
DataPrinytiya = Res.DataPrinytiya,
UstroenCZS = Res.UstroenCZS,
DataZakritiya = Res.DataZakritiya,
idStatus = Res.idStatus,
StatusName = St.StatusName,
idResume = Res.idResume,
idStud = Res.idStud
}).OrderByDescending(m=>m.DataPrinytiya).ToList();
foreach (var list in ResumeList)
{
if (list.idStatus == StatusResumeClose)
{
var idResumeZnachParam = ugtu_db.Param_Resume.Where(idParam => idParam.idResume == list.idResume && idParam.idParam == IDPARAM_ReasonEndRegistration).Select(idParam => idParam.idResumeZnachParam).First();
list.Pricina = ugtu_db.ZnachParam.Where(idZnach => idZnach.idParam == IDPARAM_ReasonEndRegistration && idZnach.idZnachParam == idResumeZnachParam).Select(idZnach => idZnach.ZnachParamName).First();
}
}
//проверка на то, что у студента нет открытых резюме
if (ResumeList.Where(m => m.idStatus == StatusResumeOpen).Count() > 0) ViewBag.flOpenRes = true;
else ViewBag.flOpenRes = false;
ViewBag.ResumeList = ResumeList;
ViewBag.Path = "Student";
return PartialView("StudentResume", ResumeStud);
}
}
//удаление
public int DeleteRabProfSave(int id)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var Rp = ugtu_db.RabProf.Where(m => m.idRabProf == id).SingleOrDefault();
ugtu_db.RabProf.DeleteOnSubmit(Rp);
ugtu_db.SubmitChanges();
return 1;
}
}
public ActionResult StudentResumeInfo(int id = 0)
{
ViewBag.Path = "Student";
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.idRes = id;
ViewBag.idStud = ugtu_db.Resume.Where(m => m.idResume == id).Select(m => m.idStud).FirstOrDefault();
return PartialView("StudentResumeInfo");
}
}
//главная вьюха частичная
public ActionResult EditSfera()
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.DataSfera = ugtu_db.Sfera
.OrderBy(m => m.NameSfera)
.ToList();
return View("PartialEditSfera");
}
}
public ActionResult AddPraktik(int idStud = 0)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.OrderBy(Pr=>Pr.Name).ToList(), "IDPredpriyatie", "Name");
ViewBag.Praktiki = new SelectList(ugtu_db.discpln.Where(m => m.ik_type_disc == 2).OrderBy(D => D.cName_disc).ToList(), "iK_disc", "cName_disc"); //2-УЧЕБНЫЕ ПРАКТИКИ!!!
ViewBag.idStud = idStud;
return PartialView("PartialPraktikStudentAdd");
}
}
//редактирование
public int EditSferaSave(int id, string name)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
if (name.Trim() != "")
{
var Sf = ugtu_db.Sfera.Where(m => m.IDSfera == id).SingleOrDefault();
if (Sf != null)
{
Sf.NameSfera = name;
}
ugtu_db.SubmitChanges();
return 1;
}
return 0;
}
}
