private void button1_Click(object sender, EventArgs e) { Add addForm = new Add(); addForm.numericUpDown2.Value = (int)DateTime.Now.Year; DialogResult result = addForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } People people = new People(); people.Name = addForm.textBox1.Text; people.LastName = addForm.textBox2.Text; people.Day = (int)addForm.numericUpDown1.Value; people.Year = (int)addForm.numericUpDown2.Value; db.Peoples.Add(people); db.SaveChanges(); dataGridView1.DataSource = null; dataGridView1.Update(); db.Peoples.Load(); dataGridView1.DataSource = db.Peoples.AsNoTracking().ToList(); dataGridView1.Refresh(); }
private void button3_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { int DaysRegain; int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } HolyDay peoplday = _db.HolyDays.FirstOrDefault(c => c.Id == id); People people = _db.Peoples.FirstOrDefault(c => c.Id == peoplday.Peopleid); BindingSource DatedbOne = new BindingSource(); var DatedbOneK = from w in _db.HolyDays.Local where (w.Peopleid == _Id) select w; if (peoplday.IndexDate == true) { MessageBox.Show("it is used"); } else { // holydayn.SecontDate.Subtract(holydayn.FirstDate).Days DaysRegain = peoplday.People.Day + peoplday.SecontDate.Subtract(peoplday.FirstDate).Days; people.Day = DaysRegain; _db.HolyDays.Remove(peoplday); _db.SaveChanges(); DatedbOneK = from w in _db.HolyDays.Local where (w.Peopleid == _Id) select w; var qieryAsList = new BindingList <HolyDay>(DatedbOneK.ToList()); DatedbOne.DataSource = qieryAsList; dataGridView1.DataSource = DatedbOne; dataGridView1.Update(); dataGridView1.Refresh(); } } }
private void button1_Click(object sender, EventArgs e) { Add addForm = new Add(); DialogResult result = addForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } People people = new People(); people.Name = addForm.textBox1.Text; people.LastName = addForm.textBox2.Text; people.Day = (int)addForm.numericUpDown1.Value; db.Peoples.Add(people); db.SaveChanges(); MessageBox.Show("New person"); }
private void btnAddnewPerson(object sender, EventArgs e) { Add addForm = new Add(); DialogResult result = addForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Person people = new Person(); people.Id = Guid.NewGuid(); people.Name = addForm.textBox1.Text; people.LastName = addForm.textBox2.Text; people.Day = (int)addForm.numericUpDown1.Value; people.Year = (int)addForm.numericUpDown2.Value; db.Workers.Add(people); db.SaveChanges(); evenstb(); }
private void btnDeleteDate(object sender, EventArgs e) { int DaysRegain; Guid id = SearcId(); if (id == Form1.IdError) { return; } Vacation peoplday = _db.Vacations.FirstOrDefault(c => c.Id == id); Person people = _db.Workers.FirstOrDefault(c => c.Id == peoplday.Peopleid); BindingSource DatedbOne = new BindingSource(); var DatedbOneK = from w in _db.Vacations where (w.Peopleid == _Id) select w; if (peoplday.IndexDate == true) { MessageBox.Show("it is used"); } else { // holydayn.SecontDate.Subtract(holydayn.FirstDate).Days DaysRegain = peoplday.People.Day + peoplday.SecontDate.Subtract(peoplday.FirstDate).Days; people.Day = DaysRegain; _db.Vacations.Remove(peoplday); _db.SaveChanges(); DatedbOneK = from w in _db.Vacations where (w.Peopleid == _Id) select w; var qieryAsList = new BindingList <Vacation>(DatedbOneK.ToList()); DatedbOne.DataSource = qieryAsList; dataGridView1.DataSource = DatedbOne; dataGridView1.Update(); dataGridView1.Refresh(); } }