public date(int Id) { InitializeComponent(); _db = new WorkerContext(); _Id = Id; _db.Peoples.Load(); _db.HolyDays.Load(); if (_db.HolyDays.Count(i => i.Peopleid == _Id) < 1) { MessageBox.Show("Don`t have weekend"); } else { BindingSource DatedbOne = new BindingSource(); var DatedbOneK = from w in _db.HolyDays.Local where (w.Peopleid == _Id) select w; personOfweekend = _db.HolyDays.FirstOrDefault(q => q.People.Id == _Id); checkBox1.Checked = personOfweekend.IndexDate; var qieryAsList = new BindingList <HolyDay>(DatedbOneK.ToList()); DatedbOne.DataSource = qieryAsList; dataGridView1.DataSource = DatedbOne; } }
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(); } }
public void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { HolyDay holydayn = new HolyDay(); int Daysu; int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } holydayn.People = db.Peoples.Find(id); AddHol addHolForm = new AddHol(holydayn.People.Day); if (holydayn.People.Day < 1) { MessageBox.Show("don`t have weekend!!!"); return; } DialogResult result = addHolForm.ShowDialog(this); holydayn.FirstDate = addHolForm.dateTimePicker1.Value; holydayn.IndexDate = false; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(holydayn.People.Day); holydayn.SecontDate = addHolForm.dateTimePicker2.Value; if (result == DialogResult.Cancel) { return; } Daysu = holydayn.People.Day - holydayn.SecontDate.Subtract(holydayn.FirstDate).Days; holydayn.People.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(); } }
private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { 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); peoplday.IndexDate = true; _db.SaveChanges(); } }
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(); } } }
public void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { HolyDay holydayn = new HolyDay(); int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } holydayn.People = db.Peoples.Find(id); AddHol addHolForm = new AddHol(holydayn.People.Day); DialogResult result = addHolForm.ShowDialog(this); holydayn.FirstDate = addHolForm.dateTimePicker1.Value; holydayn.IndexDate = false; addHolForm.dateTimePicker2.MaxDate = addHolForm.dateTimePicker1.Value.AddDays(holydayn.People.Day); holydayn.SecontDate = addHolForm.dateTimePicker2.Value; db.HolyDays.Add(holydayn); db.SaveChanges(); if (result == DialogResult.Cancel) { return; } MessageBox.Show("New date add"); } }