// Получение фамилии и инициалов студента в дательном падеже по id студента
public ActionResult GetShortNameStudentInDat(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Student student = db.Students.Where(s => s.ID == id).FirstOrDefault();
dataForDPProtocol.ShortNameStudentInDat = student.LastName + " " + student.FirstName.ToUpper()[0] + "." + student.Patronymic.ToUpper()[0] + ".";
}
return(PartialView(dataForDPProtocol));
}
// Получение фамилии и инициалов руководителя в родительном падеже по id работника
public ActionResult GetShortNameLeaderInGen(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Employee employee = db.Employees.Where(e => e.ID == id).FirstOrDefault();
dataForDPProtocol.ShortNameLeaderInGen = employee.LastNameInGenitive + " " + employee.FirstName.ToUpper()[0] + "." + employee.Patronymic.ToUpper()[0] + ".";
}
return(PartialView(dataForDPProtocol));
}
// Получение консультантов по id группы
public ActionResult GetConsultants(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Group group = new Group();
group = db.Groups.Where(g => g.ID == id).FirstOrDefault();
dataForDPProtocol.Consultants = group.ComissionMembers;
}
return(PartialView(dataForDPProtocol));
}
// Получение отчества студента по id студента
public ActionResult GetPatronymicStudent(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Student student = new Student();
student = db.Students.Where(s => s.ID == id).FirstOrDefault();
dataForDPProtocol.StPatronymicInGen = student.Patronymic;
}
return(PartialView(dataForDPProtocol));
}
// Получение номера и наименования специальности по id группы
public ActionResult GetSpecialty(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Group group = db.Groups.Where(g => g.ID == id).FirstOrDefault();
Specialty specialty = db.Specialties.Where(s => s.ID == group.SpecialtyID).FirstOrDefault();
dataForDPProtocol.Specialty = specialty.NumberOfSpecialty + " «" + specialty.NameOfSpecialty + "»";
}
return(PartialView(dataForDPProtocol));
}
// Получение инициалов и фамилии третьего члена комиссии по id ГЭКа
public ActionResult GetShortNameMemberThreeTwo(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Committee committee = new Committee();
committee = db.Committees.Where(c => c.SebID == id).FirstOrDefault();
if (committee != null)
{
Employee employee = new Employee();
employee = db.Employees.Where(e => e.ID == committee.MemberThreeID).FirstOrDefault();
dataForDPProtocol.ShortNameMemberThreeTwo = employee.FirstName.ToUpper()[0] + "." + employee.Patronymic.ToUpper()[0] + "." + employee.LastName;
}
}
return(PartialView(dataForDPProtocol));
}
// Получение полного имени первого члена комиссии по id ГЭКа
public ActionResult GetFullNameMemberOne(int?id)
{
DataForDPProtocol dataForDPProtocol = new DataForDPProtocol();
if (id != null)
{
Committee committee = new Committee();
committee = db.Committees.Where(c => c.SebID == id).FirstOrDefault();
if (committee != null)
{
Employee employee = new Employee();
employee = db.Employees.Where(e => e.ID == committee.MemberOneID).FirstOrDefault();
dataForDPProtocol.FullNameMemberOne = employee.LastName + " " + employee.FirstName + " " + employee.Patronymic;
}
}
return(PartialView(dataForDPProtocol));
}
public ActionResult Create(DataForDPProtocol dataForDPProtocol)
{
if (ModelState.IsValid)
{
Application app = new Application();
Document doc = app.Documents.Add(@"F:\Protocol.docx");
doc.Bookmarks["FIO"].Range.Text = dataForDPProtocol.StLastNameInGen + " " + dataForDPProtocol.StFirstNameInGen + " " + dataForDPProtocol.StPatronymicInGen;
doc.Bookmarks["Specialty"].Range.Text = dataForDPProtocol.Specialty;
doc.Bookmarks["Theme"].Range.Text = dataForDPProtocol.Theme;
doc.Bookmarks["ShortNameChairpersonOne"].Range.Text = dataForDPProtocol.ShortNameChairpersonOne;
doc.Bookmarks["ShortNameSecretaryOne"].Range.Text = dataForDPProtocol.ShortNameSecretaryOne;
doc.Bookmarks["ShortNameMemberOneOne"].Range.Text = dataForDPProtocol.ShortNameMemberOneOne;
doc.Bookmarks["ShortNameMemberTwoOne"].Range.Text = dataForDPProtocol.ShortNameMemberTwoOne;
doc.Bookmarks["ShortNameMemberThreeOne"].Range.Text = dataForDPProtocol.ShortNameMemberThreeOne;
doc.Bookmarks["ShortNameLeaderInGen"].Range.Text = dataForDPProtocol.ShortNameLeaderInGen;
doc.Bookmarks["ShortNameLeaderInGen2"].Range.Text = dataForDPProtocol.ShortNameLeaderInGen;
doc.Bookmarks["Consultants"].Range.Text = dataForDPProtocol.Consultants;
doc.Bookmarks["ShortNameStudentInDat1"].Range.Text = dataForDPProtocol.ShortNameStudentInDat;
doc.Bookmarks["ShortNameStudentInDat2"].Range.Text = dataForDPProtocol.ShortNameStudentInDat;
doc.Bookmarks["ShortNameChairpersonTwo"].Range.Text = dataForDPProtocol.ShortNameChairpersonTwo;
doc.Bookmarks["ShortNameSecretaryTwo"].Range.Text = dataForDPProtocol.ShortNameSecretaryTwo;
doc.Bookmarks["ShortNameMemberOneTwo"].Range.Text = dataForDPProtocol.ShortNameMemberOneTwo;
doc.Bookmarks["ShortNameMemberTwoTwo"].Range.Text = dataForDPProtocol.ShortNameMemberTwoTwo;
doc.Bookmarks["ShortNameMemberThreeTwo"].Range.Text = dataForDPProtocol.ShortNameMemberThreeTwo;
doc.SaveAs(FileName: @"F:\NewProtocolQQQ.docx");
try
{
doc.Close();
app.Quit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(RedirectToAction("Index", "Home"));
}
return(View(dataForDPProtocol));
}