public ActionResult AddTrudoustrSave(TrudoustrModel Trud, string Path)
{
int idTrud = 0;
try
{
Trud.idDolzhnost = AddDolgnost(Trud.NameDolzhnost);
Trud.idPredpr = GetIdPredpr(Trud.NamePred);
idTrud = Rep.AddTrudoustrSave(Trud);
}
catch (Exception e)
{
ViewBag.Message = e.Message;
return View("Error");
}
return RedirectToAction("InfoTrudoustr", Path, new { idTrud = idTrud, idStud = Trud.idStud });
}
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;
}
}
//закрыттие регистрации при нахождении работы самим обратившимся используется в связке с 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;
}
}
public ActionResult EditFactZanVipusknik(int id)
{
var qw = (from PZS in ugtu_db.PlanZanyat_Student
join PZ in ugtu_db.PlanZanyat on PZS.idPlanZanyat equals PZ.IDPlanZanyat
where PZS.idPlanZanyat_Student == id
select new
{
idStud = PZS.idStud,
idTrud = PZS.idTrudoustr,
data = PZS.DataObzvona
}).First();
TrudoustrModel _TrudoustrModel = new TrudoustrModel();
if (qw.idTrud != null)
{
ViewBag.idTrud = qw.idTrud;
ViewBag.idPredpr = new SelectList(ugtu_db.Predpriyatie.OrderBy(n => n.Name), "IDPredpriyatie", "Name", ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(m => m.IDPredpriyatie).First());
ViewBag.idDolzhnost = new SelectList(ugtu_db.Dolznost.OrderBy(n => n.NameDolznost), "IDDolznost", "NameDolznost", ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(m => m.IDDolznost).First());
if (ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataBegin).First() != null) ViewBag.DataNachTrudoustr = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataBegin).First().ToString()).ToShortDateString();
if (ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataEnd).First() != null) ViewBag.DataOkonTrudoustr = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataEnd).First().ToString()).ToShortDateString();
if (ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataObzvon).First() != null) ViewBag.DataObzvon = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataObzvon).First().ToString()).ToShortDateString();
ViewBag.ZarPlata = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.ZarPlata).First();
ViewBag.RabPoSpec = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.RabotaPoSpec).First();
ViewBag.BitSpravka = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.Spravka).First();
ViewBag.DopInfo = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DopInfo).First();
if (ViewBag.DataNachTrudoustr != null) _TrudoustrModel.DataNachTrudoustr = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataBegin).First().ToString());
if (ViewBag.DataOkonTrudoustr != null) _TrudoustrModel.DataOkonTrudoustr = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataEnd).First().ToString());
if (ViewBag.DataObzvon != null) _TrudoustrModel.DataObzvon = DateTime.Parse(ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.DataObzvon).First().ToString());
_TrudoustrModel.ZarPlata = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(M => M.ZarPlata).First();
_TrudoustrModel.NamePred = ugtu_db.Predpriyatie.Where(m => m.IDPredpriyatie == ugtu_db.Trudoustr.Where(m1 => m1.IDTrudoustr == qw.idTrud).Select(m1 => m1.IDPredpriyatie).SingleOrDefault()).Select(m => m.Name).SingleOrDefault();
_TrudoustrModel.NameDolzhnost = ugtu_db.Dolznost.Where(m => m.IDDolznost == ugtu_db.Trudoustr.Where(m1 => m1.IDTrudoustr == qw.idTrud).Select(m1 => m1.IDDolznost).SingleOrDefault()).Select(m => m.NameDolznost).SingleOrDefault();
_TrudoustrModel.Otdel = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(m => m.Otdel).SingleOrDefault();
_TrudoustrModel.DopInfo = ugtu_db.Trudoustr.Where(m => m.IDTrudoustr == qw.idTrud).Select(m => m.DopInfo).SingleOrDefault();
}
else
{
ViewBag.Predpr = new SelectList(ugtu_db.Predpriyatie.OrderBy(n => n.Name), "IDPredpriyatie", "Name");
ViewBag.Dolzhnost = new SelectList(ugtu_db.Dolznost.OrderBy(n => n.NameDolznost), "IDDolznost", "NameDolznost");
}
var KaryeraVipusknik1 = (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
where Pers.nCode == qw.idStud// && Gr.DateExit.Value.Year == DateTime.Today.Year && DateTime.Today.Month < Month
select new StudentKarModel
{
firstname = Pers.Cfirstname,
lastname = Pers.Clastname,
otch = Pers.Cotch,
FIO = Pers.PersonFullName,
nCode = Pers.nCode,
name_grup = Gr.Cname_grup,
}).ToList();
var KaryeraVipusknik = (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 == qw.idStud //&& Gr.DateExit.Value.Year == DateTime.Today.Year && DateTime.Today.Month < Month
select new
{
spravka = Tr.Spravka
}).ToList();
ViewBag.bitSpravkaAll = false;
foreach (var c in KaryeraVipusknik)
{
if (c.spravka == true)
{
ViewBag.bitSpravkaAll = true;
}
}
ViewBag.InfoStud = KaryeraVipusknik1.Last();
ViewBag.idStud = qw.idStud;
// ViewBag.idTrud = 0; ???надо, нет???
if (qw.idTrud != null) { ViewBag.idTrud = qw.idTrud; };
ViewBag.idPlanZan = id;
ViewBag.Tel = ugtu_db.Person.Where(m => m.nCode == qw.idStud).Select(M => M.cSotTel).FirstOrDefault();
ViewBag.mail = ugtu_db.Person.Where(m => m.nCode == qw.idStud).Select(M => M.cEmail).FirstOrDefault();
ViewBag.FactZan = new SelectList(ugtu_db.PlanZanyat.Where(m => m.IDTypeZan == FactTypeZan), "IDPlanZanyat", "NamePlanZanyat",
ugtu_db.PlanZanyat_Student.Where(m => m.idPlanZanyat_Student == id).Select(m => m.idPlanZanyat).First());
ViewBag.DataObzvonFactZan = DateTime.Parse(qw.data.ToString()).ToShortDateString();
return PartialView("VipusknikEditFactZan", _TrudoustrModel);
}
public ActionResult EditTrudoustrSave(TrudoustrModel Trud, string Path)
{
using (var ugtu_db = new UGTU_DBDataContext())
{
var Trudostr = ugtu_db.Trudoustr.Where(tr => tr.IDTrudoustr == Trud.idTrud).First();
if (Path == "Vipusknik")
{
Models.ugtuRealTest.File F = null;
if (Trudostr.Spravka == true && Trud.BitSpravka == false)//если справка была и её не стало
{
ugtu_db.File.DeleteOnSubmit(ugtu_db.File.Where(f => f.idFile == Trudostr.IDFile).SingleOrDefault());
Trudostr.IDFile = null;
ugtu_db.SubmitChanges();
}
else
{
if (Trud.BitSpravka == true && Trud.upload != null)
{
if (Trudostr.Spravka == true) F = new Models.ugtuRealTest.File();
else F = ugtu_db.File.Where(f => f.idFile == Trudostr.IDFile).SingleOrDefault();
F.ExtensionFile = System.IO.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;
if (Trudostr.Spravka == true) ugtu_db.File.InsertOnSubmit(F);
ugtu_db.SubmitChanges();
if (F != null) Trudostr.IDFile = F.idFile;
if (Path == "Vipusknik" && F == null) Trudostr.IDFile = null;
}
}
}
//var Trudostr = ugtu_db.Trudoustr.Where(tr => tr.IDTrudoustr == Trud.idTrud).First();
Trudostr.DataBegin = Trud.DataNachTrudoustr;
Trudostr.DataObzvon = Trud.DataObzvon;
Trudostr.DataEnd = Trud.DataOkonTrudoustr;
Trudostr.IDDolznost = AddDolgnost(Trud.NameDolzhnost);
Trudostr.IDPredpriyatie =GetIdPredpr(Trud.NamePred);
Trudostr.RabotaPoSpec = Trud.RabPoSpec;
Trudostr.Otdel = Trud.Otdel;
Trudostr.ZarPlata = Trud.ZarPlata;
Trudostr.IDStudent = Trud.idStud;
Trudostr.Spravka = Trud.BitSpravka;
Trudostr.DopInfo = Trud.DopInfo;
ugtu_db.SubmitChanges();
}
return RedirectToAction("InfoTrudoustr", Path, new { idTrud = Trud.idTrud, idStud = Trud.idStud });
}
public ActionResult InfoTrudoustr(int idTrud, string Path)
{
TrudoustrModel InfoTrud = new TrudoustrModel();
InfoTrud = Rep.InfoTrudoustr(idTrud);
ViewBag.idStud = InfoTrud.idStud;
ViewBag.idTrud = idTrud;
ViewBag.Path = Path;
return PartialView("PartialInfoTrudoustr", InfoTrud);
}
