private void buttonSave_Click(object sender, EventArgs e) { using(var db = new Animals()) { for (int i = 0; i < amount; i++) { var animal = new Animal { Name = this.dataGridViewAnimals.Rows[i].Cells[0].Value.ToString(), Breed = this.dataGridViewAnimals.Rows[i].Cells[1].Value.ToString(), Sex = this.dataGridViewAnimals.Rows[i].Cells[2].Value.ToString()}; db.AnimalSet.Add(animal); db.SaveChanges(); } } dataGridViewAnimals.Rows.Clear(); dataGridViewAnimals.Columns.Clear(); this.dataGridViewAnimals.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridViewAnimals.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridViewAnimals.Columns.Add("Name", "Ім'я"); this.dataGridViewAnimals.Columns.Add("Breed", "Порода"); this.dataGridViewAnimals.Columns.Add("Sex", "Стать"); this.dataGridViewAnimals.Columns[0].Width = 90; this.dataGridViewAnimals.Columns[1].Width = 90; this.dataGridViewAnimals.Columns[2].Width = 90; this.dataGridViewAnimals.ReadOnly = true; amount = 0; }
private void buttonFind_Click(object sender, EventArgs e) { this.dataGridViewFindAnimals.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridViewFindAnimals.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dataGridViewFindAnimals.Columns.Add("Name", "Ім'я"); this.dataGridViewFindAnimals.Columns.Add("Breed", "Порода"); this.dataGridViewFindAnimals.Columns.Add("Sex", "Стать"); this.dataGridViewFindAnimals.Columns[0].Width = 90; this.dataGridViewFindAnimals.Columns[1].Width = 90; this.dataGridViewFindAnimals.Columns[2].Width = 90; this.dataGridViewFindAnimals.ReadOnly = true; if (radioButton1.Checked == true) { using (var db = new Animals()) { var query = from animal in db.AnimalSet where animal.Name == textBoxFindName.Text select animal; if (query.Count<Animal>() == 0) { MessageBox.Show("Тварин з таким іменем не знайдено."); } else { dataGridViewFindAnimals.Visible = true; int amountFinded = 0; foreach (var item in query) { this.dataGridViewFindAnimals.Rows.Add(); this.dataGridViewFindAnimals.Rows[amountFinded].Cells[0].Value = item.Name; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[1].Value = item.Breed; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[2].Value = item.Sex; amountFinded++; } } } } else { if (radioButton2.Checked == true) { using (var db = new Animals()) { var query = from animal in db.AnimalSet where animal.Breed == textBoxFindBreed.Text select animal; if (query.Count<Animal>() == 0) { MessageBox.Show("Тварин з такою породою не знайдено."); } else { dataGridViewFindAnimals.Visible = true; int amountFinded = 0; foreach (var item in query) { this.dataGridViewFindAnimals.Rows.Add(); this.dataGridViewFindAnimals.Rows[amountFinded].Cells[0].Value = item.Name; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[1].Value = item.Breed; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[2].Value = item.Sex; amountFinded++; } } } } else { if (radioButtonFindMale.Checked || radioButtonFindFemale.Checked) { using (var db = new Animals()) { string sex = string.Empty; if (this.radioButtonFindMale.Checked == true) { sex = "Чоловік"; } else { sex = "Жінка"; } var query = from animal in db.AnimalSet where animal.Sex == sex select animal; if (query.Count<Animal>() == 0) { MessageBox.Show("Тварин з такою статтю не знайдено."); } else { dataGridViewFindAnimals.Visible = true; int amountFinded = 0; foreach (var item in query) { this.dataGridViewFindAnimals.Rows.Add(); this.dataGridViewFindAnimals.Rows[amountFinded].Cells[0].Value = item.Name; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[1].Value = item.Breed; this.dataGridViewFindAnimals.Rows[amountFinded].Cells[2].Value = item.Sex; amountFinded++; } } } } } } }