private void CreateApplication_Click(object sender, EventArgs e)
{
if (Classes.Settings.CurrentCampaignID == 0)
{
MessageBox.Show("Не выбрана текущая кампания. Перейдите в Главное меню -> Приемная кампания -> Приемные кампании.");
}
else
{
StopTableAutoUpdating();
Form form;
if (_MasterCampaign)
{
form = new ApplicationMagEdit(_DB_Connection, Classes.Settings.CurrentCampaignID, _UserLogin, null);
}
else
{
List <object[]> campaidnEduLevels = _DB_Connection.Select(DB_Table._CAMPAIGNS_HAS_DICTIONARIES_ITEMS, new string[] { "dictionaries_items_item_id" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("campaigns_id", Relation.EQUAL, Classes.Settings.CurrentCampaignID),
new Tuple <string, Relation, object>("dictionaries_items_dictionary_id", Relation.EQUAL, (uint)FIS_Dictionary.EDU_LEVEL)
});
bool spo = false;
foreach (object[] eduLevel in campaidnEduLevels)
{
if (DB_Helper.EduLevelSPO == _DB_Helper.GetDictionaryItemName(FIS_Dictionary.EDU_LEVEL, (uint)eduLevel[0]))
{
spo = true;
}
}
if (spo)
{
form = new ApplicationSPOEdit(_DB_Connection, Classes.Settings.CurrentCampaignID, _UserLogin, null);
}
else
{
form = new ApplicationEdit(_DB_Connection, Classes.Settings.CurrentCampaignID, _UserLogin, null);
}
}
form.ShowDialog();
UpdateApplicationsTable();
timer.Start();
}
}
private void cbOlympName_SelectedIndexChanged(object sender, EventArgs e)
{
if ((OlympTuple)((ComboBox)sender).SelectedValue != null)
{
tbOlympID.Text = ((OlympTuple)((ComboBox)sender).SelectedValue).Item1.ToString();
cbOlympProfile.ValueMember = "Value";
cbOlympProfile.DisplayMember = "Name";
cbOlympProfile.DataSource = _DB_Connection.Select(DB_Table._DICTIONARY_OLYMPIC_PROFILES_HAS_DICTIONARIES_ITEMS, new string[] { "dictionary_olympic_profiles_profile_id" },
new System.Collections.Generic.List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("dictionary_olympic_profiles_olympic_id", Relation.EQUAL, ((OlympTuple)((ComboBox)sender).SelectedValue).Item1)
}).Select(s => new
{
Name = _DB_Helper.GetDictionaryItemName(FIS_Dictionary.OLYMPICS_PROFILES, (uint)s[0]),
Value = new OlympTuple((uint)s[0], _DB_Helper.GetDictionaryItemName(FIS_Dictionary.OLYMPICS_PROFILES, (uint)s[0]))
}).ToArray();
}
}
private void UpdateTable()
{
dgvAchievements.Rows.Clear();
foreach (var record in _DB_Connection.Select(DB_Table.INSTITUTION_ACHIEVEMENTS, new string[] { "id", "name", "category_dict_id",
"category_id", "value" }, new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("campaign_id", Relation.EQUAL, _LoadedCampaign)
}))
{
dgvAchievements.Rows.Add(record[0], record[1], record[4], _DB_Helper.GetDictionaryItemName((FIS_Dictionary)record[2], (uint)record[3]), record[3]);
}
}
private void UpdateTableAndCombobox()
{
dgvCampaigns.Rows.Clear();
List <object[]> campaigns = _DB_Connection.Select(DB_Table.CAMPAIGNS,
new string[] { "id", "name", "start_year", "end_year", "status_dict_id", "status_id" });
foreach (object[] v in campaigns)
{
dgvCampaigns.Rows.Add(v[0], v[1], v[2].ToString() + " - " + v[3].ToString(), "", _DB_Helper.GetDictionaryItemName((FIS_Dictionary)v[4], (uint)v[5]));
foreach (object[] r in _DB_Connection.Select(DB_Table._CAMPAIGNS_HAS_DICTIONARIES_ITEMS, new string[] { "dictionaries_items_item_id" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("dictionaries_items_dictionary_id", Relation.EQUAL, (uint)FIS_Dictionary.EDU_LEVEL),
new Tuple <string, Relation, object>("campaigns_id", Relation.EQUAL, dgvCampaigns.Rows[dgvCampaigns.Rows.Count - 1].Cells[0].Value)
}))
{
string levelName = _DB_Helper.GetDictionaryItemName(FIS_Dictionary.EDU_LEVEL, (uint)r[0]);
if (dgvCampaigns.Rows[dgvCampaigns.Rows.Count - 1].Cells[3].Value.ToString() == "")
{
dgvCampaigns.Rows[dgvCampaigns.Rows.Count - 1].Cells[3].Value = levelName;
}
else
{
dgvCampaigns.Rows[dgvCampaigns.Rows.Count - 1].Cells[3].Value = dgvCampaigns.Rows[dgvCampaigns.Rows.Count - 1].Cells[3].Value.ToString() + " - " + levelName;
}
}
}
cbCurrentCampaign.ValueMember = "Value";
cbCurrentCampaign.DisplayMember = "Display";
cbCurrentCampaign.DataSource = campaigns.Select(s => new
{
Value = (uint)s[0],
Display = s[1].ToString()
}).ToArray();
if (Classes.Settings.CurrentCampaignID != 0)
{
cbCurrentCampaign.SelectedValue = Classes.Settings.CurrentCampaignID;
}
else
{
cbCurrentCampaign.SelectedIndex = -1;
}
}
private void UpdateTable()
{
DataGridViewColumn sortedColumn = dataGridView.SortedColumn;
System.ComponentModel.ListSortDirection sortMethod = System.ComponentModel.ListSortDirection.Ascending;
if (dataGridView.SortOrder == SortOrder.Ascending)
{
sortMethod = System.ComponentModel.ListSortDirection.Ascending;
}
else if (dataGridView.SortOrder == SortOrder.Descending)
{
sortMethod = System.ComponentModel.ListSortDirection.Descending;
}
int firstDisplayedRow = dataGridView.FirstDisplayedScrollingRowIndex;
dataGridView.Rows.Clear();
DB_Helper dbHelper = new DB_Helper(_DB_Connection);
List <Tuple <string, Relation, object> > filter = new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("campaign_id", Relation.EQUAL, Classes.Settings.CurrentCampaignID)
};
if (toolStrip_RegFilter.SelectedItem.ToString() == "Зарегистрированные")
{
filter.Add(new Tuple <string, Relation, object>("protocol_number", Relation.NOT_EQUAL, null));
}
else if (toolStrip_RegFilter.SelectedItem.ToString() == "Незарегистрированные")
{
filter.Add(new Tuple <string, Relation, object>("protocol_number", Relation.EQUAL, null));
}
foreach (var row in _DB_Connection.Select(
DB_Table.ORDERS,
new string[] { "number", "type", "date", "protocol_number", "edu_source_id", "edu_form_id", "faculty_short_name", "direction_id", "profile_short_name" },
filter
).GroupJoin(
_DB_Connection.Select(DB_Table.ORDERS_HAS_APPLICATIONS, "orders_number"),
k1 => k1[0],
k2 => k2[0],
(e, g) => new { e, Count = g.Count() }
))
{
dataGridView.Rows.Add(
row.e[0],
_OrderTypes[row.e[1].ToString()],
(DateTime)row.e[2],
row.e[3] as ushort?,
dbHelper.GetDictionaryItemName(FIS_Dictionary.EDU_SOURCE, (uint)row.e[4]),
dbHelper.GetDictionaryItemName(FIS_Dictionary.EDU_FORM, (uint)row.e[5]),
row.e[6].ToString() + (row.e[7] is uint? " " + dbHelper.GetDirectionNameAndCode((uint)row.e[7]).Item1: null),
row.e[8] is string?DB_Queries.GetProfileName(_DB_Connection, row.e[6].ToString(), (uint)row.e[7], row.e[8].ToString()) : null,
row.Count
);
}
if (sortedColumn != null)
{
dataGridView.Sort(sortedColumn, sortMethod);
}
if (firstDisplayedRow != -1 && dataGridView.Rows.Count > firstDisplayedRow)
{
dataGridView.FirstDisplayedScrollingRowIndex = firstDisplayedRow;
}
}
private void LoadDocuments()
{
List <object[]> appDocuments = new List <object[]>();
foreach (var documentID in _DB_Connection.Select(DB_Table._APPLICATIONS_HAS_DOCUMENTS, new string[] { "documents_id" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("applications_id", Relation.EQUAL, _ApplicationID)
}))
{
appDocuments.Add(_DB_Connection.Select(DB_Table.DOCUMENTS, new string[] { "id", "type", "series", "number", "date", "organization", "original_recieved_date" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("id", Relation.EQUAL, documentID[0])
})[0]);
}
foreach (var document in appDocuments)
{
if (document[1].ToString() == "identity")
{
tbIDDocSeries.Text = document[2].ToString();
tbIDDocNumber.Text = document[3].ToString();
dtpIDDocDate.Value = (DateTime)document[4];
tbIssuedBy.Text = document[5].ToString();
object[] passport = _DB_Connection.Select(DB_Table.IDENTITY_DOCS_ADDITIONAL_DATA, new string[] { "subdivision_code", "type_id", "nationality_id",
"birth_date", "birth_place", "reg_region", "reg_district", "reg_town", "reg_street", "reg_house", "reg_index", "reg_flat", "gender_id" }, new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("document_id", Relation.EQUAL, (uint)document[0])
})[0];
mtbSubdivisionCode.Text = passport[0].ToString();
cbIDDocType.SelectedItem = _DB_Helper.GetDictionaryItemName(FIS_Dictionary.IDENTITY_DOC_TYPE, (uint)passport[1]);
cbNationality.SelectedItem = _DB_Helper.GetDictionaryItemName(FIS_Dictionary.COUNTRY, (uint)passport[2]);
dtpDateOfBirth.Value = (DateTime)passport[3];
tbPlaceOfBirth.Text = passport[4].ToString();
cbRegion.Text = passport[5].ToString();
cbDistrict.Text = passport[6].ToString();
cbTown.Text = passport[7].ToString();
cbStreet.Text = passport[8].ToString();
cbHouse.Text = passport[9].ToString();
tbPostcode.Text = passport[10].ToString();
tbAppartment.Text = passport[11].ToString();
cbSex.SelectedItem = _DB_Helper.GetDictionaryItemName(FIS_Dictionary.GENDER, (uint)passport[12]);
}
else if (document[1].ToString() == "school_certificate" || document[1].ToString() == "middle_edu_diploma" || document[1].ToString() == "high_edu_diploma")
{
if (document[1].ToString() == "school_certificate")
{
rbCertificate.Checked = true;
cbEduDoc.Checked = true;
}
else if (document[1].ToString() == "middle_edu_diploma" || document[1].ToString() == "high_edu_diploma")
{
rbDiploma.Checked = true;
cbEduDoc.Checked = true;
}
tbEduDocSeries.Text = document[2].ToString();
tbEduDocNumber.Text = document[3].ToString();
if (document[6] as DateTime? != null)
{
cbOriginal.Checked = true;
}
if (document[5].ToString().Split('|').Length > 1)
{
cbInstitutionType.SelectedItem = document[5].ToString().Split('|')[0];
tbInstitutionNumber.Text = document[5].ToString().Split('|')[1];
tbInstitutionLocation.Text = document[5].ToString().Split('|')[2];
}
cbGraduationYear.SelectedItem = int.Parse(_DB_Connection.Select(DB_Table.OTHER_DOCS_ADDITIONAL_DATA, new string[] { "year" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("document_id", Relation.EQUAL, document[0])
})[0][0].ToString());
}
else if (document[1].ToString() == "photos")
{
cbPhotos.Checked = true;
}
else if (document[1].ToString() == "medical")
{
List <object[]> spravkaData = _DB_Connection.Select(DB_Table.OTHER_DOCS_ADDITIONAL_DATA, new string[] { "name" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("document_id", Relation.EQUAL, (uint)document[0])
});
if (spravkaData.Count > 0 && spravkaData[0][0].ToString() == DB_Helper.MedCertificate)
{
cbMedCertificate.Checked = true;
}
}
}
}
private void bPrint_Click(object sender, EventArgs e)
{
if (!cbActs.Checked && !cbReceipts.Checked && !cbExamSheets.Checked)
{
MessageBox.Show("Не отмечена информация к печати.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Cursor.Current = Cursors.WaitCursor;
IEnumerable <string> ordersNumbers;
if (rbDate.Checked)
{
ordersNumbers = _DB_Connection.Select(
DB_Table.ORDERS,
new string[] { "number" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("date", Relation.GREATER_EQUAL, dtpStart.Value.Date),
new Tuple <string, Relation, object>("date", Relation.LESS, dtpEnd.Value.Date.AddDays(1))
}).Select(s => s[0].ToString());
}
else
{
ordersNumbers = new string[] { tbNumber.Text }
};
DB_Helper dbHelper = new DB_Helper(_DB_Connection);
var orders = ordersNumbers.Join(
_DB_Connection.Select(
DB_Table.ORDERS,//TODO убрать лишние поля
new string[] { "number", "type", "date", "protocol_number", "protocol_date", "edu_form_id", "edu_source_id", "faculty_short_name", "direction_id", "profile_short_name", "campaign_id" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("campaign_id", Relation.EQUAL, Classes.Settings.CurrentCampaignID),
new Tuple <string, Relation, object>("type", Relation.EQUAL, "admission"),
new Tuple <string, Relation, object>("protocol_number", Relation.NOT_EQUAL, null)
}),
k1 => k1,
k2 => k2[0],
(s1, s2) => new
{
Number = s1,
Date = (DateTime)s2[2],
ProtocolNumber = (ushort)s2[3],
ProtocolDate = (DateTime)s2[4],
EduForm = (uint)s2[5],
EduSource = (uint)s2[6],
Faculty = s2[7].ToString(),
Direction = (uint)s2[8],
Profile = s2[9] as string,
Master = dbHelper.GetCampaignType((uint)s2[10]) == DB_Helper.CampaignType.MASTER
});
if (orders.Count() == 0)
{
MessageBox.Show("Не найдено соответствующих приказов.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Dictionary <uint, string> forms = new Dictionary <uint, string>
{
{ 11, "очной формы" },
{ 12, "очно-заочной (вечерней) формы" },
{ 10, "заочной формы" }
};
uint mathID = dbHelper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectMath);
uint physID = dbHelper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectPhis);
uint rusID = dbHelper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectRus);
uint socID = dbHelper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectObsh);
uint forID = dbHelper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectForen);
List <Classes.DocumentCreator.DocumentParameters> actsDocs = new List <Classes.DocumentCreator.DocumentParameters>();
List <Classes.DocumentCreator.DocumentParameters> receiptsDocs = new List <Classes.DocumentCreator.DocumentParameters>();
List <Classes.DocumentCreator.DocumentParameters> sheetsDocs = new List <Classes.DocumentCreator.DocumentParameters>();
foreach (var order in orders)
{
var applications = _DB_Connection.Select(
DB_Table.ORDERS_HAS_APPLICATIONS,
new string[] { "applications_id", "record_book_number" },
new List <Tuple <string, Relation, object> > {
new Tuple <string, Relation, object>("orders_number", Relation.EQUAL, order.Number)
}
).Join(
_DB_Connection.Select(DB_Table.APPLICATIONS, "id", "entrant_id", "status"),
k1 => k1[0],
k2 => k2[0],
(s1, s2) => new { ApplID = (uint)s2[0], EntrID = (uint)s2[1], RecordBook = s1[1].ToString() }
).Join(
_DB_Connection.Select(DB_Table.ENTRANTS_VIEW, "id", "last_name", "first_name", "middle_name"),
k1 => k1.EntrID,
k2 => k2[0],
(s1, s2) => new { s1.ApplID, s1.EntrID, s1.RecordBook, LastName = s2[1].ToString(), FirstName = s2[2].ToString(), MiddleName = s2[3] as string }
);
List <Tuple <string, Relation, object> > whereExpr = new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("type", Relation.EQUAL, "exception"),
new Tuple <string, Relation, object>("protocol_number", Relation.NOT_EQUAL, null),
new Tuple <string, Relation, object>("edu_form_id", Relation.EQUAL, order.EduForm),
new Tuple <string, Relation, object>("edu_source_id", Relation.EQUAL, order.EduSource),
new Tuple <string, Relation, object>("faculty_short_name", Relation.EQUAL, order.Faculty),
new Tuple <string, Relation, object>("direction_id", Relation.EQUAL, order.Direction)
};
if (order.Profile != null)
{
whereExpr.Add(new Tuple <string, Relation, object>("profile_short_name", Relation.EQUAL, order.Profile));
}
applications = applications.Where(s =>
{
IEnumerable <DateTime> admDates = _DB_Connection.Select(
DB_Table.ORDERS_HAS_APPLICATIONS,
new string[] { "orders_number" },
new List <Tuple <string, Relation, object> > {
new Tuple <string, Relation, object>("applications_id", Relation.EQUAL, s.ApplID)
}
).Join(
_DB_Connection.Select(DB_Table.ORDERS, new string[] { "number", "date" },
whereExpr
),
k1 => k1[0],
k2 => k2[0],
(s1, s2) => (DateTime)s2[1]
);
return(!admDates.Any(d => d > order.Date));
});
if (applications.Count() == 0)
{
continue;
}
if (dbHelper.GetCampaignType(Classes.Settings.CurrentCampaignID) == DB_Helper.CampaignType.MASTER)
{
var table = applications.Join(
_DB_Connection.Select(
DB_Table.MASTERS_EXAMS_MARKS,
new string[] { "entrant_id", "mark", "bonus" },
new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("campaign_id", Relation.EQUAL, Classes.Settings.CurrentCampaignID),
new Tuple <string, Relation, object>("faculty", Relation.EQUAL, order.Faculty),
new Tuple <string, Relation, object>("direction_id", Relation.EQUAL, order.Direction),
new Tuple <string, Relation, object>("profile_short_name", Relation.EQUAL, order.Profile),
}),
k1 => k1.EntrID,
k2 => k2[0],
(s1, s2) => new { s1.ApplID, s1.LastName, s1.FirstName, s1.MiddleName, s1.RecordBook, Mark = (short)s2[1] + (ushort)s2[2] }
);
//Tuple<string, string> dirNameCode = dbHelper.GetDirectionNameAndCode(order.Direction);
//string dirSocr = dbHelper.GetDirectionShortName(order.Faculty, order.Direction);
//if (cbActs.Checked)
// actsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
// Classes.Settings.DocumentsTemplatesPath + "Act.xml",
// null,
// null,
// new string[]
// {
// DateTime.Now.ToShortDateString(),
// order.Date.Year.ToString(),
// forms[order.EduForm] + " обучения" +
// (order.EduSource == dbHelper.GetDictionaryItemID(FIS_Dictionary.EDU_SOURCE, DB_Helper.EduSourceP) ? " по договорам с оплатой стоимости обучения" : ""),
// order.Faculty,
// dirNameCode.Item2,
// dirNameCode.Item1,
// order.Master?"Магистерская программа: " :(order.Profile != null ?(dirNameCode.Item2.Split('.')[1]=="05"?"Специализация": "Профиль")+": " : ""),
// order.Profile != null ? order.Profile + " - " + DB_Queries.GetProfileName(_DB_Connection,order.Faculty,order.Direction,order.Profile).Split('|')[0] : ""
// },
// new IEnumerable<string[]>[] { table.Select(s=>new
// {
// Name = s.LastName + " " + s.FirstName + " " + s.MiddleName,
// s.RecordBook
// }).OrderBy(s => s.Name).Select(s => new string[] { s.Name, s.RecordBook }) }));
foreach (var appl in table)
{
//if (cbReceipts.Checked)
// receiptsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
// Classes.Settings.DocumentsTemplatesPath + "AdmReceipt.xml",
// null,
// null,
// new string[]
// {
// order.Number,
// order.Date.ToShortDateString(),
// (appl.LastName+" "+appl.FirstName[0]+"."+(appl.MiddleName.Length!=0?appl.MiddleName[0].ToString()+".":"")).ToUpper(),
// order.Faculty,
// order.Profile != null ?order.Profile:dirSocr
// },
// null
// ));
if (cbExamSheets.Checked)
{
sheetsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
Classes.Settings.DocumentsTemplatesPath + "ExamSheetM.xml",
null,
null,
new string[]
{
appl.Mark.ToString(),
dbHelper.GetDictionaryItemName(FIS_Dictionary.EDU_FORM, order.EduForm),
appl.ApplID.ToString(),
appl.LastName.ToUpper(),
appl.FirstName.ToUpper(),
appl.MiddleName.ToUpper(),
order.Profile
},
null
));
}
}
}
else
{
IEnumerable <DB_Queries.Mark> marks = DB_Queries.GetMarks(_DB_Connection, applications.Select(s => s.ApplID), Classes.Settings.CurrentCampaignID);
var table = applications.Join(
marks.GroupBy(
k => Tuple.Create(k.ApplID, k.SubjID),
(k, g) => new { g.First().ApplID, Mark = g.First(s => s.Value == g.Max(m => m.Value)) }
).GroupBy(
k => k.ApplID,
(k, g) => new { g.First().ApplID, Subjects = g.Select(s => s.Mark) }
),
k1 => k1.ApplID,
k2 => k2.ApplID,
(s1, s2) => new { s1.ApplID, s1.LastName, s1.FirstName, s1.MiddleName, s1.RecordBook, s2.Subjects }
);
Tuple <string, string> dirNameCode = dbHelper.GetDirectionNameAndCode(order.Direction);
string dirSocr = dbHelper.GetDirectionShortName(order.Faculty, order.Direction);
if (cbActs.Checked)
{
actsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
Classes.Settings.DocumentsTemplatesPath + "Act.xml",
null,
null,
new string[]
{
DateTime.Now.ToShortDateString(),
order.Date.Year.ToString(),
forms[order.EduForm] + " обучения" +
(order.EduSource == dbHelper.GetDictionaryItemID(FIS_Dictionary.EDU_SOURCE, DB_Helper.EduSourceP) ? " по договорам с оплатой стоимости обучения" : ""),
order.Faculty,
dirNameCode.Item2,
dirNameCode.Item1,
order.Master?"Магистерская программа: " :(order.Profile != null ?(dirNameCode.Item2.Split('.')[1] == "05"?"Специализация": "Профиль") + ": " : ""),
order.Profile != null ? order.Profile + " - " + DB_Queries.GetProfileName(_DB_Connection, order.Faculty, order.Direction, order.Profile).Split('|')[0] : ""
},
new IEnumerable <string[]>[] { table.Select(s => new
{
Name = s.LastName + " " + s.FirstName + " " + s.MiddleName,
s.RecordBook
}).OrderBy(s => s.Name).Select(s => new string[] { s.Name, s.RecordBook }) }));
}
foreach (var appl in table)
{
if (cbReceipts.Checked)
{
receiptsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
Classes.Settings.DocumentsTemplatesPath + "AdmReceipt.xml",
null,
null,
new string[]
{
order.Number,
order.Date.ToShortDateString(),
(appl.LastName + " " + appl.FirstName[0] + "." + (appl.MiddleName.Length != 0?appl.MiddleName[0].ToString() + ".":"")).ToUpper(),
order.Faculty,
order.Profile != null ?order.Profile:dirSocr
},
null
));
}
if (cbExamSheets.Checked)
{
sheetsDocs.Add(new Classes.DocumentCreator.DocumentParameters(
Classes.Settings.DocumentsTemplatesPath + "ExamSheet.xml",
null,
null,
new string[]
{
appl.Subjects.SingleOrDefault(s => s.SubjID == mathID)?.Value.ToString(),
dbHelper.GetDictionaryItemName(FIS_Dictionary.EDU_FORM, order.EduForm),
appl.Subjects.SingleOrDefault(s => s.SubjID == physID)?.Value.ToString(),
appl.ApplID.ToString(),
appl.Subjects.SingleOrDefault(s => s.SubjID == rusID)?.Value.ToString(),
appl.LastName.ToUpper(),
appl.Subjects.SingleOrDefault(s => s.SubjID == socID)?.Value.ToString(),
appl.FirstName.ToUpper(),
appl.Subjects.SingleOrDefault(s => s.SubjID == forID)?.Value.ToString(),
appl.MiddleName.ToUpper(),
order.Profile != null ?order.Profile:dirSocr
},
null
));
}
}
}
}
if (cbActs.Checked)
{
string doc = Classes.Settings.TempPath + "acts" + new Random().Next();
Classes.DocumentCreator.Create(doc, actsDocs, false);
System.Diagnostics.Process.Start(doc + ".docx");
}
if (cbReceipts.Checked)
{
string doc = Classes.Settings.TempPath + "receipts" + new Random().Next();
Classes.DocumentCreator.Create(doc, receiptsDocs, false);
System.Diagnostics.Process.Start(doc + ".docx");
}
if (cbExamSheets.Checked)
{
string doc = Classes.Settings.TempPath + "examSheets" + new Random().Next();
Classes.DocumentCreator.Create(doc, sheetsDocs, false);
System.Diagnostics.Process.Start(doc + ".docx");
}
Cursor.Current = Cursors.Default;
}
}
