public void btnAddVacation(object sender, EventArgs e) { Vacation holydayn = new Vacation(); int Daysu; Guid id = SearcId(); if (id == IdError) { return; } db.Workers.AsNoTracking(); // db.Workers.Load(); Person person = db.Workers.FirstOrDefault(i => i.Id == id); if (person == null) { return; } db.Entry(person).Reload(); db.Entry(person).State = EntityState.Modified; // holydayn.People = db.Peoples.AsNoTracking().ToList().FirstOrDefault(i=>i.Id==id); holydayn.Peopleid = person.Id; AddHol addHolForm = new AddHol(person.Day); DateTime date = new DateTime(person.Year, 1, 1); if (person.Day < 1) { MessageBox.Show("don`t have weekend!!!"); return; } addHolForm.dateTimePicker1.Value = date; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(person.Day); addHolForm.dateTimePicker2.MinDate = addHolForm.dateTimePicker1.Value; DialogResult result = addHolForm.ShowDialog(this); holydayn.Id = Guid.NewGuid(); holydayn.FirstDate = addHolForm.dateTimePicker1.Value; holydayn.IndexDate = false; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(person.Day); holydayn.SecontDate = addHolForm.dateTimePicker2.Value; if (result == DialogResult.Cancel) { return; } Daysu = person.Day - holydayn.SecontDate.Subtract(holydayn.FirstDate).Days; person.Day = Daysu; holydayn.Days = holydayn.SecontDate.Subtract(holydayn.FirstDate).Days; db.Vacations.Add(holydayn); addHolForm.Close(); db.SaveChanges(); evenstb(); }
public void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { HolyDay holydayn = new HolyDay(); People person = new People(); int Daysu; int Dayx; int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } db.Peoples.AsNoTracking().ToList(); db.Peoples.Load(); person = db.Peoples.ToList().FirstOrDefault(i => i.Id == id); db.Entry(person).Reload(); db.Entry(person).State = EntityState.Modified; // holydayn.People = db.Peoples.AsNoTracking().ToList().FirstOrDefault(i=>i.Id==id); holydayn.Peopleid = person.Id; AddHol addHolForm = new AddHol(person.Day); DateTime date = new DateTime(person.Year, 1, 1); if (person.Day < 1) { MessageBox.Show("don`t have weekend!!!"); return; } addHolForm.dateTimePicker1.Value = date; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(person.Day); addHolForm.dateTimePicker2.MinDate = addHolForm.dateTimePicker1.Value; DialogResult result = addHolForm.ShowDialog(this); holydayn.FirstDate = addHolForm.dateTimePicker1.Value; holydayn.IndexDate = false; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(person.Day); holydayn.SecontDate = addHolForm.dateTimePicker2.Value; if (result == DialogResult.Cancel) { return; } Daysu = person.Day - holydayn.SecontDate.Subtract(holydayn.FirstDate).Days; person.Day = Daysu; holydayn.Days = holydayn.SecontDate.Subtract(holydayn.FirstDate).Days; db.HolyDays.Add(holydayn); db.SaveChanges(); dataGridView1.DataSource = null; dataGridView1.Update(); db.Peoples.Load(); dataGridView1.DataSource = db.Peoples.AsNoTracking().ToList(); dataGridView1.Refresh(); } }