public void DeliveriesSetAdd(DeliveriesSet deliveries)
{
using (BakeryEntities db = new BakeryEntities())
{
db.DeliveriesSet.Add(deliveries);
db.SaveChanges();
}
}
public void ShiftsSetAdd(ShiftsSet shifts)
{
using (BakeryEntities db = new BakeryEntities())
{
db.ShiftsSet.Add(shifts);
db.SaveChanges();
}
}
public void BackerySetAdd(BackerySet backery)
{
using (BakeryEntities db = new BakeryEntities())
{
db.BackerySet.Add(backery);
db.SaveChanges();
}
}
public void StaffSetAdd(StaffSet staff)
{
using (BakeryEntities db = new BakeryEntities())
{
db.StaffSet.Add(staff);
db.SaveChanges();
}
}
private void BackerySetDataGridFill()
{
BakeryEntities db = new BakeryEntities();
db.BackerySet.Load();
Grid.DataSource = db.BackerySet.Local.ToBindingList();
DeleteButtom(Grid.RowCount);
Grid.Columns[1].HeaderText = "Адрес";
}
private void DeliveriesSetDataGridFill()
{
BakeryEntities db = new BakeryEntities();
db.DeliveriesSet.Load();
Grid.DataSource = db.DeliveriesSet.Local.ToBindingList();
DeleteButtom(Grid.RowCount);
Grid.Columns[1].HeaderText = "Адресс доставки";
Grid.Columns[2].HeaderText = "Количестов тортов";
Grid.Columns[3].HeaderText = "Булочная";
}
private void ShiftsSetDataGridFill()
{
BakeryEntities db = new BakeryEntities();
db.ShiftsSet.Load();
Grid.DataSource = db.ShiftsSet.Local.ToBindingList();
DeleteButtom(Grid.RowCount);
Grid.Columns[1].HeaderText = "Выполнен ли план";
Grid.Columns[2].HeaderText = "Сотрудник";
Grid.Columns[3].HeaderText = "Булочная";
}
private void StaffSetDataGridFill()
{
BakeryEntities db = new BakeryEntities();
db.StaffSet.Load();
Grid.DataSource = db.StaffSet.Local.ToBindingList();
DeleteButtom(Grid.RowCount);
Grid.Columns[1].HeaderText = "Фамилия";
Grid.Columns[2].HeaderText = "Имя";
Grid.Columns[3].HeaderText = "Отчество";
}
private void Grid_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
BakeryEntities db = new BakeryEntities();
if (e.ColumnIndex == 0)
{
if (comboBox1.SelectedIndex == 0)
{
BackerySet BackerySet = db.BackerySet.Find(Grid[0, e.RowIndex].Value);
db.BackerySet.Remove(BackerySet);
db.SaveChanges();
BackerySetDataGridFill();
}
else if (comboBox1.SelectedIndex == 1)
{
StaffSet StaffSet = db.StaffSet.Find(Grid[0, e.RowIndex].Value);
db.StaffSet.Remove(StaffSet);
db.SaveChanges();
StaffSetDataGridFill();
}
else if (comboBox1.SelectedIndex == 2)
{
ShiftsSet ShiftsSet = db.ShiftsSet.Find(Grid[0, e.RowIndex].Value);
db.ShiftsSet.Remove(ShiftsSet);
db.SaveChanges();
ShiftsSetDataGridFill();
}
else if (comboBox1.SelectedIndex == 3)
{
DeliveriesSet DeliveriesSet = db.DeliveriesSet.Find(Grid[0, e.RowIndex].Value);
db.DeliveriesSet.Remove(DeliveriesSet);
db.SaveChanges();
DeliveriesSetDataGridFill();
}
}
}
private void Grid_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
BakeryEntities db = new BakeryEntities();
if (checkBox1.Checked)
{
if (comboBox1.SelectedIndex == 0)
{
if (e.ColumnIndex == 1)
{
BackerySet backerySet = db.BackerySet.Find(Grid[0, e.RowIndex].Value);
backerySet.adres = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
BackerySetDataGridFill();
}
}
else if (comboBox1.SelectedIndex == 1)
{
if (e.ColumnIndex == 1)
{
StaffSet staffSet = db.StaffSet.Find(Grid[0, e.RowIndex].Value);
staffSet.Surname = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
StaffSetDataGridFill();
}
else if (e.ColumnIndex == 2)
{
StaffSet staffSet = db.StaffSet.Find(Grid[0, e.RowIndex].Value);
staffSet.name = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
StaffSetDataGridFill();
}
else if (e.ColumnIndex == 3)
{
StaffSet staffSet = db.StaffSet.Find(Grid[0, e.RowIndex].Value);
staffSet.patronymic = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
StaffSetDataGridFill();
}
}
else if (comboBox1.SelectedIndex == 3)
{
if (e.ColumnIndex == 1)
{
DeliveriesSet deliveriesSet = db.DeliveriesSet.Find(Grid[0, e.RowIndex].Value);
deliveriesSet.adres = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
DeliveriesSetDataGridFill();
}
else if (e.ColumnIndex == 3)
{
DeliveriesSet deliveriesSet = db.DeliveriesSet.Find(Grid[0, e.RowIndex].Value);
deliveriesSet.Backery_Id = Convert.ToInt32(Grid[e.ColumnIndex, e.RowIndex].Value.ToString());
db.SaveChanges();
DeliveriesSetDataGridFill();
}
else if (e.ColumnIndex == 2)
{
DeliveriesSet deliveriesSet = db.DeliveriesSet.Find(Grid[0, e.RowIndex].Value);
deliveriesSet.numberOfCakes = Convert.ToInt16(Grid[e.ColumnIndex, e.RowIndex].Value.ToString());
db.SaveChanges();
DeliveriesSetDataGridFill();
}
}
else if (comboBox1.SelectedIndex == 2)
{
if (e.ColumnIndex == 1)
{
ShiftsSet shifts = db.ShiftsSet.Find(Grid[0, e.RowIndex].Value);
shifts.Plan = Grid[e.ColumnIndex, e.RowIndex].Value.ToString();
db.SaveChanges();
ShiftsSetDataGridFill();
}
else if (e.ColumnIndex == 2)
{
ShiftsSet shifts = db.ShiftsSet.Find(Grid[0, e.RowIndex].Value);
shifts.Backery_Id = Convert.ToInt32(Grid[e.ColumnIndex, e.RowIndex].Value.ToString());
db.SaveChanges();
ShiftsSetDataGridFill();
}
else if (e.ColumnIndex == 3)
{
ShiftsSet shifts = db.ShiftsSet.Find(Grid[0, e.RowIndex].Value);
shifts.Staff_Id = Convert.ToInt32(Grid[e.ColumnIndex, e.RowIndex].Value.ToString());
db.SaveChanges();
ShiftsSetDataGridFill();
}
}
}
}
