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 appendConsum(StringBuilder builder, Consum consum)
{
builder.Append(consum.Pac);
builder.Append(", ");
builder.Append(consum.DaySum);
builder.Append(", ");
builder.Append(consum.Status);
builder.Append(", ");
}
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("Запись обновлен");
}
}
private void btnDelete_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);
context.ConsList.Remove(consum);
context.SaveChanges();
MessageBox.Show("Запись удален");
}
}
public FiveMinutes(
int datum,
Consum consum,
Production production1,
Production production2,
Production production3,
Production production4,
Production production5,
Production production6)
{
this.Datum = datum;
this.Consum = consum;
this.Production1 = production1;
this.Production2 = production2;
this.Production3 = production3;
this.Production4 = production4;
this.Production5 = production5;
this.Production6 = production6;
}
internal DtoBuilder WithRow(List <string> row)
{
this.consum = new Consum(
Parse(row[3]),
Parse(row[4]),
Parse(row[5]));
this.production1 = new Production(
Parse(row[7]),
Parse(row[8]),
Parse(row[9]),
Parse(row[10]),
Parse(row[11]),
Parse(row[12]),
Parse(row[13]),
Parse(row[14]),
Parse(row[15]),
Parse(row[16]),
Parse(row[17]));
this.production2 = new Production(
Parse(row[19]),
Parse(row[20]),
Parse(row[21]),
Parse(row[22]),
Parse(row[23]),
Parse(row[24]),
Parse(row[25]),
Parse(row[26]),
Parse(row[27]),
Parse(row[28]),
Parse(row[29]));
this.production3 = new Production(
Parse(row[31]),
Parse(row[32]),
Parse(row[33]),
Parse(row[34]),
Parse(row[35]),
Parse(row[36]),
Parse(row[37]),
Parse(row[38]),
Parse(row[39]),
Parse(row[40]),
Parse(row[41]));
this.production4 = new Production(
Parse(row[43]),
Parse(row[44]),
Parse(row[45]),
Parse(row[46]),
Parse(row[47]),
Parse(row[48]),
Parse(row[49]),
Parse(row[50]),
Parse(row[51]),
Parse(row[52]),
Parse(row[53]));
this.production5 = new Production(
Parse(row[55]),
Parse(row[56]),
Parse(row[57]),
Parse(row[58]),
Parse(row[59]),
Parse(row[60]),
Parse(row[61]),
Parse(row[62]),
Parse(row[63]),
Parse(row[64]),
Parse(row[65]));
this.production6 = new Production(
Parse(row[67]),
Parse(row[68]),
Parse(row[69]),
Parse(row[70]),
Parse(row[71]),
Parse(row[72]),
Parse(row[73]),
Parse(row[74]),
Parse(row[75]),
Parse(row[76]),
Parse(row[77]));
return(this);
}
