private void btnAdd_Click(object sender, EventArgs e)
{
ConsumAEForm caeForm = new ConsumAEForm();
List <ConsCategory> consCategories = context.ConsCategoryList.ToList();
caeForm.cbCategory.DataSource = consCategories;
caeForm.cbCategory.ValueMember = "ConsCategoryId";
caeForm.cbCategory.DisplayMember = "Name";
DialogResult result = caeForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
Consum consum = new Consum();
consum.ConsDate = (DateTime)caeForm.dtDate.Value;
consum.ConsSum = decimal.Parse(caeForm.txtIncSum.Text);
consum.ConsCategory = (ConsCategory)caeForm.cbCategory.SelectedItem;
consum.Descr = caeForm.txtDescr.Text;
context.ConsList.Add(consum);
context.SaveChanges();
MessageBox.Show("Расход добавлен");
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dataGridView.SelectedRows.Count > 0)
{
int index = dataGridView.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
Consum consum = context.ConsList.Find(id);
ConsumAEForm caeForm = new ConsumAEForm();
caeForm.dtDate.Value = consum.ConsDate;
caeForm.txtIncSum.Text = consum.ConsSum.ToString();
caeForm.cbCategory.SelectedItem = consum.ConsCategory;
caeForm.txtDescr.Text = consum.Descr;
List <ConsCategory> conCats = context.ConsCategoryList.ToList();
caeForm.cbCategory.DataSource = conCats;
caeForm.cbCategory.ValueMember = "ConsCategoryId";
caeForm.cbCategory.DisplayMember = "Name";
if (consum.ConsCategory != null)
{
caeForm.cbCategory.SelectedValue = consum.ConsCategory.ConsCategoryId;
}
DialogResult result = caeForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
consum.ConsDate = (DateTime)caeForm.dtDate.Value;
consum.ConsSum = decimal.Parse(caeForm.txtIncSum.Text);
consum.ConsCategory = (ConsCategory)caeForm.cbCategory.SelectedItem;
consum.Descr = caeForm.txtDescr.Text;
context.Entry(consum).State = EntityState.Modified;
context.SaveChanges();
MessageBox.Show("Запись обновлен");
}
}