private void TakeDocumentDate(int proceedings_id) { List <int> documentDateTimeYearArr = new List <int>(); List <int> documentDateTimeMonthArr = new List <int>(); List <int> documentDateTimeDayArr = new List <int>(); List <string> documentDateTimeArr = new List <string>(); using (var db = new ovuEntities()) { foreach (var item in db.articles) { if (proceedings_id == item.proceedings_id) { documentDateTimeYearArr.Add(item.created_at.Year); documentDateTimeMonthArr.Add(item.created_at.Month); documentDateTimeDayArr.Add(item.created_at.Day); } } } for (int i = 0; i < documentDateTimeDayArr.Count; i++) { documentDateTimeArr.Add(documentDateTimeYearArr[i].ToString() + "-" + documentDateTimeMonthArr[i].ToString() + "-" + documentDateTimeDayArr[i].ToString()); textBox1.Text += documentDateTimeArr[i]; } File.WriteAllLines(FinalFolderPath + "\\" + "DocumentsDate_" + ((int)YearComboBox.SelectedItem).ToString() + "_" + (string)OvuNumberComboBox.SelectedItem + ".txt", documentDateTimeArr); }
private void TakeDocumentType(List <int?> articles_id) { using (var db = new ovuEntities()) { List <string> documentTypeArr = new List <string>(); List <int?> article_type_id = new List <int?>(); int?check = 0; foreach (var item3 in articles_id) { foreach (var item4 in db.collections) { if (item4.articles_id == item3 && item4.articles_id != check) { article_type_id.Add(item4.article_type_id); check = item4.articles_id; } } } foreach (var item5 in article_type_id) { foreach (var item6 in db.article_types) { if (item5 == item6.id) { documentTypeArr.Add(item6.title); textBox1.Text += item6.title; } } } File.WriteAllLines(FinalFolderPath + "\\" + "DocumentsType_" + ((int)YearComboBox.SelectedItem).ToString() + "_" + (string)OvuNumberComboBox.SelectedItem + ".txt", documentTypeArr); } }
private void TakeDocumentSections(int proceedings_id) { using (var db = new ovuEntities()) { List <int?> section_id = new List <int?>(); List <string> documentSectionArr = new List <string>(); foreach (var item2 in db.articles) { if (item2.proceedings_id == proceedings_id) { section_id.Add(item2.section_id); } } foreach (var item3 in section_id) { foreach (var item4 in db.sections) { documentSectionArr.Add(item4.title); textBox1.Text += item4.title; } } File.WriteAllLines(FinalFolderPath + "\\" + "DocumentsSection_" + ((int)YearComboBox.SelectedItem).ToString() + "_" + (string)OvuNumberComboBox.SelectedItem + ".txt", documentSectionArr); } }
void OvuNumberComboBox_SelectedIndexChanged(object sender, EventArgs e) { using (ovuEntities db = new ovuEntities()) { var proceedings = db.proceedings; List <string> ovuNumbers = new List <string>(); foreach (var item in proceedings) { if ((int)YearComboBox.SelectedItem == item.created_at.Year) { ovuNumbers.Add(item.number); } } OvuNumberComboBox.DataSource = ovuNumbers; } }
private int TakeProceedingId() { int proceedings_id = 0; using (var db = new ovuEntities()) { foreach (var item in db.proceedings) { if (item.created_at.Year == (int)YearComboBox.SelectedItem && item.number == (string)OvuNumberComboBox.SelectedItem) { proceedings_id = item.id; } } } return(proceedings_id); }
private List <int?> TakeArticlesId(int proceedings_id) { List <int?> articles_id = new List <int?>(); using (var db = new ovuEntities()) { foreach (var item2 in db.articles) { if (item2.proceedings_id == proceedings_id) { articles_id.Add(item2.id); } } } return(articles_id); }
public Form1() { InitializeComponent(); using (ovuEntities db = new ovuEntities()) { // Заполнение списка с годами var proceedings = db.proceedings; List <int> years = new List <int>(); foreach (var item in proceedings) { if (!years.Contains(item.created_at.Year)) { years.Add(item.created_at.Year); } } YearComboBox.DataSource = years; OvuNumberComboBox_SelectedIndexChanged(new object(), new EventArgs()); YearComboBox.SelectedIndexChanged += OvuNumberComboBox_SelectedIndexChanged; } }
private void TakeDocumentNumberAndNames(int proceedings_id) { List <string> documentNumberArr = new List <string>(); List <string> documentNamesArr = new List <string>(); using (var db = new ovuEntities()) { foreach (var item in db.articles) { if (item.proceedings_id == proceedings_id) { documentNumberArr.Add(item.number); textBox1.Text += item.number; documentNamesArr.Add(item.title); textBox1.Text += item.title; } } File.WriteAllLines(FinalFolderPath + "\\" + "DocumentsNumber_" + ((int)YearComboBox.SelectedItem).ToString() + "_" + (string)OvuNumberComboBox.SelectedItem + ".txt", documentNumberArr); File.WriteAllLines(FinalFolderPath + "\\" + "DocumentsName_" + ((int)YearComboBox.SelectedItem).ToString() + "_" + (string)OvuNumberComboBox.SelectedItem + ".txt", documentNamesArr); } }