private void button1_Click(object sender, EventArgs e)
{
Work_Data gl = new Work_Data();
InterpolContext context = new InterpolContext();
if (Add_radio.Checked == true)
{
if (context.PSRelations.Any(c => c.person_id == GlobalTab.data_id))
{
MessageBox.Show("Этот бандит уже прендалежит к синдикату!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
gl.Add_To_Syndicate(GlobalTab.data_id, context.Syndicates.Where(c => c.syn_name == comboBox1.SelectedItem.ToString()).Select(c => c.syn_id).FirstOrDefault(), maskedTextBox1.Text);
MessageBox.Show("Запись успешно создана!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (Delete_radio.Checked == true)
{
if (context.PSRelations.Any(c => c.person_id == GlobalTab.data_id))
{
gl.Delete_From_Syndicate(GlobalTab.data_id);
MessageBox.Show("Запись успешно удаленна!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Этот бандит не прендалежит к выбраному синдикату!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public void Data_Delete(int bandit_id)
{
InterpolContext context = new InterpolContext();
Spirit spirit_remove = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault();
Parameter par_remove = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault();
Passport pass_remove = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault();
Criminal criminal_remove = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault();
Permit permit_remove = context.Permits.Where(c => c.person_id == bandit_id).FirstOrDefault();
context.Permits.Remove(permit_remove);
context.Spirits.Remove(spirit_remove);
context.Parameters.Remove(par_remove);
context.Passports.Remove(pass_remove);
context.Criminals.Remove(criminal_remove);
context.SaveChanges();
if (context.PSRelations.Any(c => c.person_id == bandit_id))
{
PSRelation rel = context.PSRelations.Where(c => c.person_id == bandit_id).FirstOrDefault();
context.PSRelations.Remove(rel);
context.SaveChanges();
}
context.SaveChanges();
Person person_remove = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault();
context.Persons.Remove(person_remove);
context.SaveChanges();
GlobalTab.count_datarows--;
}
//---------------------------------
// Passports table -
//---------------------------------
public void UpdatePerson_Citizenship(int bandit_id, string new_bandit_citizen)
{
InterpolContext context = new InterpolContext();
var person = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_citizenship = new_bandit_citizen;
context.SaveChanges();
}
public void UpdatePerson_Role(int bandit_id, string new_bandit_role)
{
InterpolContext context = new InterpolContext();
var person = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_role = new_bandit_role;
context.SaveChanges();
}
//---------------------------------
// Criminals table -
//---------------------------------
public void UpdatePerson_Profession(int bandit_id, string new_bandit_profession)
{
InterpolContext context = new InterpolContext();
var person = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_profession = new_bandit_profession;
context.SaveChanges();
}
public void UpdatePerson_Haircolor(int bandit_id, string new_bandit_haircolor)
{
InterpolContext context = new InterpolContext();
var person = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_haircolor = new_bandit_haircolor;
context.SaveChanges();
}
public void UpdatePerson_Weight(int bandit_id, int new_bandit_Weight)
{
InterpolContext context = new InterpolContext();
var person = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_weight = new_bandit_Weight;
context.SaveChanges();
}
public void UpdatePerson_Photo(int bandit_id, string new_bandit_photo)
{
InterpolContext context = new InterpolContext();
var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.photo_path = new_bandit_photo;
context.SaveChanges();
}
public void UpdatePerson_Status(int bandit_id, string new_bandit_status)
{
InterpolContext context = new InterpolContext();
var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_status = new_bandit_status;
context.SaveChanges();
}
public void UpdatePerson_Birthday(int bandit_id, string new_bandit_birthday)
{
InterpolContext context = new InterpolContext();
var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_birthday = new_bandit_birthday;
context.SaveChanges();
}
public void UpdatePerson_Nickname(int bandit_id, string new_bandit_nickname)
{
InterpolContext context = new InterpolContext();
var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_nickname = new_bandit_nickname;
context.SaveChanges();
}
public void UpdatePerson_Nationality(int bandit_id, string new_bandit_nationality)
{
InterpolContext context = new InterpolContext();
var person = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_nationality = new_bandit_nationality;
context.SaveChanges();
}
//---------------------------------
// Spirits table -
//---------------------------------
public void UpdatePerson_Religion(int bandit_id, string new_bandit_religion)
{
InterpolContext context = new InterpolContext();
var person = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_religion = new_bandit_religion;
context.SaveChanges();
}
public void OpenPermit(int bandit_id)
{
InterpolContext context = new InterpolContext();
var permit = context.Permits.Where(c => c.person_id == bandit_id).FirstOrDefault();
permit.permit_value = "Свободна";
context.SaveChanges();
}
public void Delete_From_Syndicate(int bandit_id)
{
InterpolContext context = new InterpolContext();
PSRelation syndicate_person = context.PSRelations.Where(c => c.person_id == bandit_id).FirstOrDefault();
context.PSRelations.Remove(syndicate_person);
context.SaveChanges();
}
public void UpdatePerson_Language(int bandit_id, string new_bandit_language)
{
InterpolContext context = new InterpolContext();
var person = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault();
person.person_language = new_bandit_language;
context.SaveChanges();
}
public void CreateSyndicate(string synd_name, string synd_date)
{
InterpolContext context = new InterpolContext();
Syndicate syn = new Syndicate
{
syn_name = synd_name,
syn_date = synd_date
};
context.Syndicates.Add(syn);
context.SaveChanges();
}
private void FSyndicate_Create_Shown(object sender, EventArgs e)
{
InterpolContext context = new InterpolContext();
if (context.Syndicates.Count() != 0)
{
dataGridView1.Rows.Clear();
foreach (var r in context.Syndicates.ToList())
{
dataGridView1.Rows.Add(r.syn_id, r.syn_name, r.syn_date);
}
}
}
public bool CheckPermit(int bandit_id)
{
InterpolContext context = new InterpolContext();
string permit = context.Permits.Where(c => c.person_id == bandit_id).Select(c => c.permit_value).FirstOrDefault();
if (permit == "Свободна")
{
return(true);
}
else
{
return(false);
}
}
public void Add_To_Syndicate(int bandit_id, int syndicate_id, string bandit_date)
{
InterpolContext context = new InterpolContext();
PSRelation rel = new PSRelation
{
person_id = bandit_id,
sys_id = syndicate_id,
dateFrom = bandit_date
};
context.PSRelations.Add(rel);
context.SaveChanges();
}
private void FPreson_Syndicate_Shown(object sender, EventArgs e)
{
Work_Data gl = new Work_Data();
InterpolContext context = new InterpolContext();
gl.ClosePermit(GlobalTab.data_id);
bandit_id_lbl.Text = GlobalTab.data_id.ToString();
bandit_name_lbl.Text = gl.Return_banditName(GlobalTab.data_id);
foreach (var r in context.Syndicates.ToList())
{
comboBox1.Items.Add(r.syn_name);
}
}
public void Syndicate_Delete(int synd_id)
{
InterpolContext context = new InterpolContext();
if (context.PSRelations.Any(c => c.sys_id == synd_id))
{
var relation_list = context.PSRelations.Where(c => c.sys_id == synd_id).ToList();
context.PSRelations.RemoveRange(relation_list);
context.SaveChanges();
}
context.SaveChanges();
Syndicate syndicate = context.Syndicates.Where(c => c.syn_id == synd_id).FirstOrDefault();
context.Syndicates.Remove(syndicate);
context.SaveChanges();
}
//----------------------------------
//Фильтр по дате рождения(перебор и проверка всех дат бандитов на вхождения в спектр дат).
public List <int> GetDatePersons(DateTime d1, DateTime d2)
{
DateTime d3;
InterpolContext context = new InterpolContext();
var datelist = context.Persons.ToList();
List <int> idlist = new List <int>();
foreach (var r in datelist)
{
d3 = Convert.ToDateTime(r.person_birthday.ToString());
if (d1.CompareTo(d3) <= 0 && d2.CompareTo(d3) >= 0)
{
idlist.Add(r.person_id);
}
}
return(idlist);
}
public bool Check_nickname(string bandit_nickname)
{
InterpolContext context = new InterpolContext();
List <string> nick_list = new List <string>();
foreach (var r in context.Persons.ToList())
{
nick_list.Add(r.person_nickname);
}
if (nick_list.Contains(bandit_nickname))
{
return(true);
}
else
{
return(false);
}
}
//-------------------------------------------
//-------------------------------------------
//-------------------------------------------
//-------------------------------------------
public bool Check_SyndicateName(string synd_name)
{
InterpolContext context = new InterpolContext();
List <string> nick_list = new List <string>();
foreach (var r in context.Syndicates.ToList())
{
nick_list.Add(r.syn_name);
}
if (nick_list.Contains(synd_name))
{
return(true);
}
else
{
return(false);
}
}
private void next_btn_Click(object sender, EventArgs e)
{
InterpolContext context = new InterpolContext();
ClearObjects();
GlobalTab gl = new GlobalTab();
GlobalTab.pages_count = gl.PageCount(context.Persons.Count());
if (Convert.ToUInt32(page_label.Text) == GlobalTab.pages_count)
{
next_btn.Enabled = false;
back_btn.Enabled = true;
}
else
{
next_btn.Enabled = true;
page_label.Text = (int.Parse(page_label.Text) + 1).ToString();
}
}
private void button1_Click(object sender, EventArgs e)
{
Work_Data wdata = new Work_Data();
if (!wdata.Check_SyndicateName(syndicate_name_box.Text))
{
wdata.CreateSyndicate(syndicate_name_box.Text, syndicate_date_box.Text);
MessageBox.Show("Запись успешно создана!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Такой синдикат уже существует, задайте другое!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
InterpolContext context = new InterpolContext();
dataGridView1.Rows.Clear();
foreach (var r in context.Syndicates.ToList())
{
dataGridView1.Rows.Add(r.syn_id, r.syn_name, r.syn_date);
}
}
private void button2_Click(object sender, EventArgs e)
{
Work_Data work = new Work_Data();
InterpolContext context = new InterpolContext();
if (context.Syndicates.Any(c => c.syn_id == id_num.Value))
{
work.Syndicate_Delete(Convert.ToInt32(id_num.Value));
if (context.Syndicates.Count() != 0)
{
dataGridView1.Rows.Clear();
foreach (var r in context.Syndicates.ToList())
{
dataGridView1.Rows.Add(r.syn_id, r.syn_name, r.syn_date);
}
}
MessageBox.Show("Запись успешно удаленна!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Не существует записи с таким id!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (word_radio.Checked == true)
{
InterpolContext context = new InterpolContext();
switch (reports_list.SelectedItem.ToString())
{
case "по росту":
{
List <int> bandits_id = context.Parameters.Where(c => c.person_rise >= GlobalTab.Num1_Rise_Min.Value &&
c.person_rise <= GlobalTab.Num2_Rise_Max.Value).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_Rise.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_rise_min"].Range.Text = GlobalTab.Num1_Rise_Min.Value.ToString();
WordDocument.Bookmarks["person_rise_max"].Range.Text = GlobalTab.Num2_Rise_Max.Value.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " Рост:" +
context.Parameters.Where(c => c.person_id == r).Select(c => c.person_rise).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
// WordDocument.SaveAs(@"C:\test.rtf");
break;
}
case "по весу":
{
List <int> bandits_id = context.Parameters.Where(c => c.person_weight >= GlobalTab.Num1_Weight_Min.Value &&
c.person_weight <= GlobalTab.Num2_Weight_Max.Value).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_Weight.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_weight_min"].Range.Text = GlobalTab.Num1_Weight_Min.Value.ToString();
WordDocument.Bookmarks["person_weight_max"].Range.Text = GlobalTab.Num2_Weight_Max.Value.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " Вес:" +
context.Parameters.Where(c => c.person_id == r).Select(c => c.person_weight).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
case "по росту и весу":
{
List <int> bandits_id = context.Parameters.Where(c => c.person_rise >= GlobalTab.Num1_Rise_Min.Value &&
c.person_rise <= GlobalTab.Num2_Rise_Max.Value &&
c.person_weight >= GlobalTab.Num1_Weight_Min.Value &&
c.person_weight <= GlobalTab.Num2_Weight_Max.Value).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_RiseAndWeight.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_rise_min"].Range.Text = GlobalTab.Num1_Rise_Min.Value.ToString();
WordDocument.Bookmarks["person_rise_max"].Range.Text = GlobalTab.Num2_Rise_Max.Value.ToString();
WordDocument.Bookmarks["person_weight_min"].Range.Text = GlobalTab.Num1_Weight_Min.Value.ToString();
WordDocument.Bookmarks["person_weight_max"].Range.Text = GlobalTab.Num2_Weight_Max.Value.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " Вес:" +
context.Parameters.Where(c => c.person_id == r).Select(c => c.person_weight).FirstOrDefault().ToString() + " Рост:" +
context.Parameters.Where(c => c.person_id == r).Select(c => c.person_rise).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
case "по дате рождения":
{
GlobalTab gl = new GlobalTab();
List <int> bandits_id = gl.GetDatePersons(Convert.ToDateTime(GlobalTab.Date_First.Text), Convert.ToDateTime(GlobalTab.Date_Last.Text));
object fileName = Application.StartupPath + "\\reports\\Person_Birthday.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_date_first"].Range.Text = GlobalTab.Date_First.Text;
WordDocument.Bookmarks["person_date_last"].Range.Text = GlobalTab.Date_Last.Text;
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " " +
context.Persons.Where(c => c.person_id == r).Select(c => c.person_birthday).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
case "по религии":
{
List <int> bandits_id = context.Spirits.Where(c => c.person_religion == GlobalTab.religion_combo.SelectedItem.ToString()).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_Religion.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_religion"].Range.Text = GlobalTab.religion_combo.SelectedItem.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " Веруют в " +
context.Spirits.Where(c => c.person_id == r).Select(c => c.person_religion).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
case "по национальности":
{
List <int> bandits_id = context.Passports.Where(c => c.person_nationality == GlobalTab.national_combo.SelectedItem.ToString()).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_National.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_national"].Range.Text = GlobalTab.national_combo.SelectedItem.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + " " +
context.Passports.Where(c => c.person_id == r).Select(c => c.person_nationality).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
case "по синдикату":
{
int syndicate_id = context.Syndicates.Where(c => c.syn_name == GlobalTab.national_combo.SelectedItem.ToString()).Select(c => c.syn_id).FirstOrDefault();
List <int> bandits_id = context.PSRelations.Where(c => c.sys_id == syndicate_id).Select(c => c.person_id).ToList();
object fileName = Application.StartupPath + "\\reports\\Person_Syndicate.dotx";
Word.Application WordApplication = new Word.Application();
Word.Document WordDocument = WordApplication.Documents.Open(fileName);
WordDocument.Bookmarks["person_syndicate"].Range.Text = GlobalTab.national_combo.SelectedItem.ToString();
foreach (var r in bandits_id)
{
WordDocument.Bookmarks["person_name"].Range.Text += context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString() + "\r\n";
}
WordDocument.Fields.Update();
WordApplication.Visible = true;
break;
}
}
}
else
if (excel_radio.Checked == true)
{
InterpolContext context = new InterpolContext();
switch (reports_list.SelectedItem.ToString())
{
case "по росту":
{
int i = 1;
List <int> bandits_id = context.Parameters.Where(c => c.person_rise >= GlobalTab.Num1_Rise_Min.Value &&
c.person_rise <= GlobalTab.Num2_Rise_Max.Value).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по весу":
{
int i = 1;
List <int> bandits_id = context.Parameters.Where(c => c.person_weight >= GlobalTab.Num1_Weight_Min.Value &&
c.person_weight <= GlobalTab.Num2_Weight_Max.Value).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по росту и весу":
{
int i = 1;
List <int> bandits_id = context.Parameters.Where(c => c.person_rise >= GlobalTab.Num1_Rise_Min.Value &&
c.person_rise <= GlobalTab.Num2_Rise_Max.Value &&
c.person_weight >= GlobalTab.Num1_Weight_Min.Value &&
c.person_weight <= GlobalTab.Num2_Weight_Max.Value).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по дате рождения":
{
int i = 1;
GlobalTab gl = new GlobalTab();
List <int> bandits_id = gl.GetDatePersons(Convert.ToDateTime(GlobalTab.Date_First.Text), Convert.ToDateTime(GlobalTab.Date_Last.Text));
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по религии":
{
int i = 1;
List <int> bandits_id = context.Spirits.Where(c => c.person_religion == GlobalTab.religion_combo.SelectedItem.ToString()).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по национальности":
{
int i = 1;
List <int> bandits_id = context.Passports.Where(c => c.person_nationality == GlobalTab.national_combo.SelectedItem.ToString()).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString(); i++;
}
ExcelApplication.Visible = true;
break;
}
case "по синдикату":
{
int i = 1;
int syndicate_id = context.Syndicates.Where(c => c.syn_name == GlobalTab.national_combo.SelectedItem.ToString()).Select(c => c.syn_id).FirstOrDefault();
List <int> bandits_id = context.PSRelations.Where(c => c.sys_id == syndicate_id).Select(c => c.person_id).ToList();
Excel.Application ExcelApplication = new Excel.Application();
Excel.Workbook newWorkbook = ExcelApplication.Workbooks.Add();
Excel.Worksheet currentSheet = (Excel.Worksheet)ExcelApplication.Workbooks[1].Worksheets[1];
foreach (var r in bandits_id)
{
currentSheet.Cells[i, 1] = context.Persons.Where(c => c.person_id == r).Select(c => c.person_name).FirstOrDefault().ToString();
i++;
}
ExcelApplication.Visible = true;
break;
}
}
}
}
private void reports_list_SelectedIndexChanged(object sender, EventArgs e)
{
GlobalTab gl = new GlobalTab();
switch (reports_list.SelectedItem.ToString())
{
case "по росту":
{
gl.ObjDispose_Reports();
gl.ObjInitial_Label1_Rise();
gl.ObjInitial_Num1_Rise_Min();
gl.ObjInitial_Label2_Rise();
gl.ObjInitial_Num2_Rise_Max();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах \n" + "указаного роста(от min до max).\n" + "Минимальный и максимальный рост укажите ниже.";
GlobalTab.label1_Rise.Text = "От";
GlobalTab.label1_Rise.Location = new Point(250, 120);
GlobalTab.Num1_Rise_Min.Location = new Point(280, 117);
GlobalTab.Num1_Rise_Min.Size = new Size(50, 20);
GlobalTab.Num1_Rise_Min.Value = 0;
GlobalTab.Num1_Rise_Min.Minimum = 0;
GlobalTab.Num1_Rise_Min.Maximum = 2000;
GlobalTab.label2_Rise.Text = "До";
GlobalTab.label2_Rise.Location = new Point(355, 120);
GlobalTab.Num2_Rise_Max.Location = new Point(395, 117);
GlobalTab.Num2_Rise_Max.Size = new Size(50, 20);
GlobalTab.Num2_Rise_Max.Value = 0;
GlobalTab.Num2_Rise_Max.Minimum = 0;
GlobalTab.Num2_Rise_Max.Maximum = 2000;
Controls.Add(GlobalTab.Num1_Rise_Min);
Controls.Add(GlobalTab.Num2_Rise_Max);
Controls.Add(GlobalTab.label1_Rise);
Controls.Add(GlobalTab.label2_Rise);
break;
}
case "по весу":
{
gl.ObjDispose_Reports();
gl.ObjInitial_Label1_Weight();
gl.ObjInitial_Num1_Weight_Min();
gl.ObjInitial_Label2_Weight();
gl.ObjInitial_Num2_Weight_Max();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах \n" + "указаного веса(от min до max).\n" + "Минимальный и максимальный вес укажите ниже.";
GlobalTab.label1_Weight.Text = "От";
GlobalTab.label1_Weight.Location = new Point(250, 120);
GlobalTab.Num1_Weight_Min.Location = new Point(280, 117);
GlobalTab.Num1_Weight_Min.Size = new Size(50, 20);
GlobalTab.Num1_Weight_Min.Value = 0;
GlobalTab.Num1_Weight_Min.Minimum = 0;
GlobalTab.Num1_Weight_Min.Maximum = 2000;
GlobalTab.label2_Weight.Text = "До";
GlobalTab.label2_Weight.Location = new Point(355, 120);
GlobalTab.Num2_Weight_Max.Location = new Point(395, 117);
GlobalTab.Num2_Weight_Max.Size = new Size(50, 20);
GlobalTab.Num2_Weight_Max.Value = 0;
GlobalTab.Num2_Weight_Max.Minimum = 0;
GlobalTab.Num2_Weight_Max.Maximum = 2000;
Controls.Add(GlobalTab.Num1_Weight_Min);
Controls.Add(GlobalTab.Num2_Weight_Max);
Controls.Add(GlobalTab.label1_Weight);
Controls.Add(GlobalTab.label2_Weight);
break;
}
case "по росту и весу":
{
gl.ObjDispose_Reports();
gl.ObjInitial_Label1_Rise();
gl.ObjInitial_Label1_Weight();
gl.ObjInitial_Label2_Rise();
gl.ObjInitial_Label2_Weight();
gl.ObjInitial_Num1_Rise_Min();
gl.ObjInitial_Num2_Rise_Max();
gl.ObjInitial_Num1_Weight_Min();
gl.ObjInitial_Num2_Weight_Max();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах \n" + "указаного роста и веса(от min до max).\n" + "Минимальный, максимальный рост и вес укажите ниже.";
GlobalTab.label1_Rise.Text = "Рост от";
GlobalTab.label1_Rise.Location = new Point(250, 120);
GlobalTab.Num1_Rise_Min.Location = new Point(320, 117);
GlobalTab.Num1_Rise_Min.Size = new Size(50, 20);
GlobalTab.Num1_Rise_Min.Value = 0;
GlobalTab.Num1_Rise_Min.Minimum = 0;
GlobalTab.Num1_Rise_Min.Maximum = 2000;
GlobalTab.label2_Rise.Text = "До";
GlobalTab.label2_Rise.Location = new Point(395, 120);
GlobalTab.Num2_Rise_Max.Location = new Point(445, 117);
GlobalTab.Num2_Rise_Max.Size = new Size(50, 20);
GlobalTab.Num2_Rise_Max.Value = 0;
GlobalTab.Num2_Rise_Max.Minimum = 0;
GlobalTab.Num2_Rise_Max.Maximum = 2000;
GlobalTab.label1_Weight.Text = "Вес от";
GlobalTab.label1_Weight.Location = new Point(250, 160);
GlobalTab.Num1_Weight_Min.Location = new Point(320, 157);
GlobalTab.Num1_Weight_Min.Size = new Size(50, 20);
GlobalTab.Num1_Weight_Min.Value = 0;
GlobalTab.Num1_Weight_Min.Minimum = 0;
GlobalTab.Num1_Weight_Min.Maximum = 2000;
GlobalTab.label2_Weight.Text = "До";
GlobalTab.label2_Weight.Location = new Point(395, 160);
GlobalTab.Num2_Weight_Max.Location = new Point(445, 157);
GlobalTab.Num2_Weight_Max.Size = new Size(50, 20);
GlobalTab.Num2_Weight_Max.Value = 0;
GlobalTab.Num2_Weight_Max.Minimum = 0;
GlobalTab.Num2_Weight_Max.Maximum = 2000;
Controls.Add(GlobalTab.Num1_Rise_Min);
Controls.Add(GlobalTab.Num2_Rise_Max);
Controls.Add(GlobalTab.label1_Rise);
Controls.Add(GlobalTab.label2_Rise);
Controls.Add(GlobalTab.Num1_Weight_Min);
Controls.Add(GlobalTab.Num2_Weight_Max);
Controls.Add(GlobalTab.label1_Weight);
Controls.Add(GlobalTab.label2_Weight);
break;
}
case "по дате рождения":
{
gl.ObjDispose_Reports();
gl.ObjInitial_Mask1_FirstDate();
gl.ObjInitial_Mask2_LastDate();
gl.ObjInitial_Label1_Rise(); // лень создавать отдельный label под остальные репорты.
gl.ObjInitial_Label2_Rise();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах указаной даты рождения.\n" + "Дату рождения укажите ниже.";
GlobalTab.label1_Rise.Text = "c";
GlobalTab.label1_Rise.AutoSize = true;
GlobalTab.label1_Rise.Location = new Point(250, 120);
GlobalTab.Date_First.Location = new Point(270, 117);
GlobalTab.Date_First.Size = new Size(60, 60);
GlobalTab.Date_First.Mask = "00/00/0000";
GlobalTab.label2_Rise.Text = "по";
GlobalTab.label2_Rise.AutoSize = true;
GlobalTab.label2_Rise.Location = new Point(335, 120);
GlobalTab.Date_Last.Location = new Point(360, 117);
GlobalTab.Date_Last.Size = new Size(60, 60);
GlobalTab.Date_Last.Mask = "00/00/0000";
Controls.Add(GlobalTab.label1_Rise);
Controls.Add(GlobalTab.label2_Rise);
Controls.Add(GlobalTab.Date_First);
Controls.Add(GlobalTab.Date_Last);
break;
}
case "по религии":
{
gl.ObjDispose_Reports();
gl.ObjInitial_ComboBox_Religion();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах указаной религии.\n" + "Религию укажите ниже.";
GlobalTab.religion_combo.Location = new Point(270, 120);
GlobalTab.religion_combo.Size = new Size(121, 21);
GlobalTab.religion_combo.DropDownStyle = ComboBoxStyle.DropDownList;
GlobalTab.religion_combo.Items.Add("Атеизм");
GlobalTab.religion_combo.Items.Add("Африканская");
GlobalTab.religion_combo.Items.Add("Бахаи");
GlobalTab.religion_combo.Items.Add("Буддизм");
GlobalTab.religion_combo.Items.Add("Джайнизм");
GlobalTab.religion_combo.Items.Add("Диаспорик");
GlobalTab.religion_combo.Items.Add("Зороастризм");
GlobalTab.religion_combo.Items.Add("Индуизм");
GlobalTab.religion_combo.Items.Add("Ислам");
GlobalTab.religion_combo.Items.Add("Иудаизм");
GlobalTab.religion_combo.Items.Add("Као даи");
GlobalTab.religion_combo.Items.Add("Китайская");
GlobalTab.religion_combo.Items.Add("Нео-язычество");
GlobalTab.religion_combo.Items.Add("Раставарианизм");
GlobalTab.religion_combo.Items.Add("Саиентология");
GlobalTab.religion_combo.Items.Add("Сикхизм");
GlobalTab.religion_combo.Items.Add("Синто");
GlobalTab.religion_combo.Items.Add("Спиритизм");
GlobalTab.religion_combo.Items.Add("Тенкуо");
GlobalTab.religion_combo.Items.Add("Универсализм");
GlobalTab.religion_combo.Items.Add("Христианство");
GlobalTab.religion_combo.Items.Add("Чучхе");
Controls.Add(GlobalTab.religion_combo);
break;
}
case "по национальности":
{
gl.ObjDispose_Reports();
gl.ObjInitial_ComboBox_National();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах указаной национальности.\n" + "Национальность укажите ниже.";
GlobalTab.national_combo.Location = new Point(270, 120);
GlobalTab.national_combo.Size = new Size(121, 21);
GlobalTab.national_combo.DropDownStyle = ComboBoxStyle.DropDownList;
GlobalTab.national_combo.Items.Add("Русский");
GlobalTab.national_combo.Items.Add("Татар");
GlobalTab.national_combo.Items.Add("Украинец");
GlobalTab.national_combo.Items.Add("Башкир");
GlobalTab.national_combo.Items.Add("Чуваш");
GlobalTab.national_combo.Items.Add("Чеченец");
GlobalTab.national_combo.Items.Add("Армянин");
GlobalTab.national_combo.Items.Add("Аварец");
GlobalTab.national_combo.Items.Add("Мордов");
GlobalTab.national_combo.Items.Add("Казах");
GlobalTab.national_combo.Items.Add("Азербайджанец");
GlobalTab.national_combo.Items.Add("Даргинец");
GlobalTab.national_combo.Items.Add("Удмурец");
GlobalTab.national_combo.Items.Add("Марий");
GlobalTab.national_combo.Items.Add("Осетин");
GlobalTab.national_combo.Items.Add("Белорус");
GlobalTab.national_combo.Items.Add("Кабардин");
GlobalTab.national_combo.Items.Add("Якут");
GlobalTab.national_combo.Items.Add("Лезгин");
GlobalTab.national_combo.Items.Add("Бурят");
GlobalTab.national_combo.Items.Add("Ингуш");
GlobalTab.national_combo.Items.Add("Норвежец");
Controls.Add(GlobalTab.national_combo);
break;
}
case "по синдикату":
{
gl.ObjDispose_Reports();
gl.ObjInitial_ComboBox_National();
InterpolContext context = new InterpolContext();
report_info_lbl.Text = "Отчет предоставляет данные о всех бандитах указаного синдиката.\n" + "Синдикат укажите ниже.";
GlobalTab.national_combo.Location = new Point(270, 120);
GlobalTab.national_combo.Size = new Size(121, 21);
GlobalTab.national_combo.DropDownStyle = ComboBoxStyle.DropDownList;
foreach (var r in context.Syndicates.ToList())
{
GlobalTab.national_combo.Items.Add(r.syn_name);
}
Controls.Add(GlobalTab.national_combo);
break;
}
}
}
