private void button1_Click(object sender, EventArgs e)
{
db.AddCity(cbCity.Text);
cbCity.DataSource = db.GetTableCity();
cbCity.DisplayMember = "City";
cbCity.SelectedIndex = cbCity.Items.Count - 1;
MessageBox.Show("Добавлен новый горд");
}
private void buttonSave_Click(object sender, EventArgs e)
{
db.AddCity(cbCity.Text);
int lastday;
if (dataGridViewDB.RowCount == 1)
{
lastday = 0;
}
else
{
lastday = (Convert.ToDateTime(dataGridViewDB[0, dataGridViewDB.RowCount - 2].Value)).Day;
}
if (((lastday == 0) & (dtMain.Value.Day == 1)) || (dtMain.Value.Day == lastday + 1))
{
db.year = dtMain.Value.Year;
db.month = dtMain.Value.Month;
db.day = dtMain.Value.Day;
db.hStart = dtStart.Value.Hour;
db.minStart = dtStart.Value.Minute;
db.hEnd = dtEnd.Value.Hour;
db.minEnd = dtEnd.Value.Minute;
db.specCheck = cbSpec.Text;
db.specAchiv = tbSpecAch.Text;
db.city = cbCity.Text;
db.AddAllRows();
dataGridViewDB.Rows.Clear();
cbCity.DataSource = db.GetTableCity();
cbCity.DisplayMember = "City";
List <OneDayData> Rows = db.GetTable(dtMain.Value.Year, dtMain.Value.Month);
int i = 0;
Rows.ForEach(q =>
{
TimeSpan dinnerHour = new TimeSpan(0, 48, 0);
if (q.specCheck == "ком." || db.HoliIsThisDay(dtMain.Value.Year, dtMain.Value.Month, q.daynumber.Day) == true)
{
dinnerHour = new TimeSpan(0, 0, 0);
}
else
{
dinnerHour = new TimeSpan(0, 48, 0);
}
if (q.dayDuration.Duration() < dinnerHour)
{
dataGridViewDB.Rows.Add(q.daynumber.ToShortDateString(), q.city, q.specCheck, q.startday.ToShortTimeString(), q.endday.ToShortTimeString(), q.achiv, q.dayDuration.Duration());
}
else
{
dataGridViewDB.Rows.Add(q.daynumber.ToShortDateString(), q.city, q.specCheck, q.startday.ToShortTimeString(), q.endday.ToShortTimeString(), q.achiv, q.dayDuration.Duration() - dinnerHour);
}
if (db.HoliIsThisDay(dtMain.Value.Year, dtMain.Value.Month, q.daynumber.Day) == true)
{
dataGridViewDB.Rows[i].DefaultCellStyle.BackColor = Color.LightSkyBlue;
}
else
{
}
i++;
});
dataGridViewDB.Rows[dataGridViewDB.Rows.Count - 1].Selected = true;
if (dtMain.Value.Day < DateTime.DaysInMonth(dtMain.Value.Year, dtMain.Value.Month))
{
dtMain.Value = new DateTime(dtMain.Value.Year, dtMain.Value.Month, dtMain.Value.Day + 1);
}
if (db.HoliIsThisDay(dtMain.Value.Year, dtMain.Value.Month, dtMain.Value.Day) == true)
{
dtStart.Value = new DateTime(1753, 1, 1, 0, 0, 0);
dtEnd.Value = new DateTime(1753, 1, 1, 0, 0, 0);
tbSpecAch.Text = "";
cbCity.Text = Tabel_client.Properties.Settings.Default.city;
cbSpec.Text = Tabel_client.Properties.Settings.Default.specCheck;
}
else
{
dtStart.Value = new DateTime(1753, 1, 1, Tabel_client.Properties.Settings.Default.hStart, Tabel_client.Properties.Settings.Default.minStart, 0);
dtEnd.Value = new DateTime(1753, 1, 1, Tabel_client.Properties.Settings.Default.hEnd, Tabel_client.Properties.Settings.Default.minEnd, 0);
cbCity.Text = Tabel_client.Properties.Settings.Default.city;
cbSpec.Text = Tabel_client.Properties.Settings.Default.specCheck;
tbSpecAch.Text = Tabel_client.Properties.Settings.Default.specAchiv;
}
}
else if (lastday == DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month))
{
MessageBox.Show("Табель текущего месяца закончен");
}
else
{
MessageBox.Show("Неверная последовательность заполения табеля! " + "\r \n" + " Дни вводятся строго последовательно!");
}
//cbCity.SelectedIndex = Tabel_client.Properties.Settings.Default.cityIndex;
}
private void btSave_Click(object sender, EventArgs e)
{
Tabel_client.Properties.Settings.Default.family = tbFamily.Text;
Tabel_client.Properties.Settings.Default.name = tbName.Text;
Tabel_client.Properties.Settings.Default.parentName = tbParentName.Text;
Tabel_client.Properties.Settings.Default.TabelNumber = tbTabelNumber.Text;
Tabel_client.Properties.Settings.Default.hStart = dtStart.Value.Hour;
Tabel_client.Properties.Settings.Default.minStart = dtStart.Value.Minute;
Tabel_client.Properties.Settings.Default.hEnd = dtEnd.Value.Hour;
Tabel_client.Properties.Settings.Default.minEnd = dtEnd.Value.Minute;
Tabel_client.Properties.Settings.Default.specCheck = cbSpec.Text;
Tabel_client.Properties.Settings.Default.specAchiv = tbSpecAch.Text;
Tabel_client.Properties.Settings.Default.city = cbCity.Text;
Tabel_client.Properties.Settings.Default.selectedTimeZone = cbTimeZone.SelectedIndex.ToString();
db.AddCity(cbCity.Text);
Tabel_client.Properties.Settings.Default.cityIndex = cbCity.SelectedIndex;
Tabel_client.Properties.Settings.Default.Save();
//if (cbHolidays.Checked == true)
//{
// Tabel_client.Properties.Settings.Default.cbHolidays = 1;
// Tabel_client.Properties.Settings.Default.Save();
//}
//else
//{
// Tabel_client.Properties.Settings.Default.cbHolidays = 0;
// Tabel_client.Properties.Settings.Default.Save();
//}
// MessageBox.Show(Tabel_client.Properties.Settings.Default.TabelNumber);
//db.year = 1753;
//db.month = 1;
//db.day = 1;
//db.hStart = dtStart.Value.Hour;
//db.minStart = dtStart.Value.Minute;
//db.hEnd = dtEnd.Value.Hour;
//db.minEnd = dtEnd.Value.Minute;
//db.specCheck = cbSpec.Text;
//db.specAchiv = tbSpecAch.Text;
//db.city = cbCity.Text;
//db.ChangeSelectedRow();
//if (cbHolidays.Checked == true)
//{
// db.year = 1753;
// db.month = 1;
// db.day = 2;
// db.specAchiv = "1";
// db.ChangeSelectedRow();
//}
//else
//{
// db.year = 1753;
// db.month = 1;
// db.day = 2;
// db.specAchiv = "0";
// db.ChangeSelectedRow();
//}
Close();
}
