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");
}
}
