private void BDelete_Click(object sender, EventArgs e)
{
using (var context = new BotanicalGardenContext())
{
DialogResult dr = MessageBox.Show("Подтверждение удаления!", "Удаление", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
switch (TabControl.SelectedIndex)
{
case 0:
foreach (DataGridViewRow row in DGVTree.SelectedRows)
{
var deleteTree = context.Trees.Find(row.Cells[0].Value);
deleteTree.Statistics.Clear();
context.Trees.Remove(deleteTree);
}
context.SaveChanges();
InitDGVTree();
break;
case 1:
foreach (DataGridViewRow row in DGVPlant.SelectedRows)
{
var deletePlant = context.Plants.Find(row.Cells[0].Value);
deletePlant.Statistics.Clear();
context.Plants.Remove(deletePlant);
}
context.SaveChanges();
InitDGVPlants();
break;
case 2:
foreach (DataGridViewRow row in DGVStatistics.SelectedRows)
{
var deleteStatistics = context.Statistics.Find(row.Cells[0].Value);
context.Statistics.Remove(deleteStatistics);
}
context.SaveChanges();
InitDGVStatistics();
break;
}
}
}
}
private void BSave_Click(object sender, EventArgs e)
{
var dateTime = TBDateTime.Text;
var livingСonditions = TBLivingСonditions.Text;
var condition = TBCondition.Text;
var population = TBPopulation.Text;
var key = TreeView.SelectedNode != null?int.Parse(TreeView.SelectedNode.Name) : -1;
if (dateTime.Equals("") || livingСonditions.Equals("") || condition.Equals("") || population.Equals("") || key == -1)
{
MessageBox.Show("Укажите все параметры", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var stat = new Statistic();
using (var context = new BotanicalGardenContext())
{
switch (param)
{
case ActionParameters.AddStatistics:
stat.DateTime = Convert.ToDateTime(dateTime);
stat.LivingСonditions = livingСonditions;
stat.Сondition = condition;
stat.Population = int.Parse(population);
if (RBTree.Checked)
{
stat.TreeId = key;
}
if (RBPlant.Checked)
{
stat.PlantId = key;
}
context.Statistics.Add(stat);
break;
case ActionParameters.EditStatistics:
stat = context.Statistics.Find(selectedCells[0].Value);
stat.DateTime = Convert.ToDateTime(dateTime);
stat.LivingСonditions = livingСonditions;
stat.Сondition = condition;
stat.Population = int.Parse(population);
if (RBTree.Checked)
{
stat.TreeId = key; stat.PlantId = null;
}
if (RBPlant.Checked)
{
stat.PlantId = key; stat.TreeId = null;
}
break;
}
context.SaveChanges();
}
Hide();
fsClass.InitDGVStatistics();
}
private void ButtonSave_Click(object sender, EventArgs e)
{
var name = TBName.Text;
var type = TBType.Text;
var family = TBFamily.Text;
var rod = TBRod.Text;
using (var context = new BotanicalGardenContext())
{
switch (param)
{
case ActionParameters.AddTree:
context.Trees.Add(new Tree {
Name = name, View = type, Family = family, Rod = rod
});
break;
case ActionParameters.AddPlant:
context.Plants.Add(new Plant {
Name = name, Type = type
});
break;
case ActionParameters.EditTree:
var tree = context.Trees.Find(selectedCells[0].Value);
tree.Name = name;
tree.View = type;
tree.Family = family;
tree.Rod = rod;
context.Entry(tree).State = EntityState.Modified;
break;
case ActionParameters.EditPlant:
var plant = context.Plants.Find(selectedCells[0].Value);
plant.Name = name;
plant.Type = type;
context.Entry(plant).State = EntityState.Modified;
break;
}
context.SaveChanges();
}
Hide();
switch (param)
{
case ActionParameters.AddTree:
case ActionParameters.EditTree:
fsClass.InitDGVTree();
break;
case ActionParameters.AddPlant:
case ActionParameters.EditPlant:
fsClass.InitDGVPlants();
break;
}
}