private void button1_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count < 1)
{
return;
}
if (comboBox1.SelectedIndex < 0 || comboBox2.SelectedIndex < 0)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
button1.Enabled = false;
ATINChamCongEntities context = new ATINChamCongEntities();
DateTime datetmp = DateTime.MinValue;
int i = 0;
int y = 0;
try
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
y = 0;
if (row.Cells[0].Value == null)
{
continue;
}
if ((bool)row.Cells[0].Value == true)
{
if (true)
{
foreach (ListViewItem lvItem in listView1.Items)
{
y++;
if (lvItem.Checked == true)
{
string s = (lvItem.Tag as int?).ToString() + "/" + (comboBox4.SelectedIndex + 1).ToString() + "/" + (2020 + comboBox5.SelectedIndex).ToString();
datetmp = Convert.ToDateTime(s, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
var x = context.spInsertChamCongLoaiVang(datetmp, (row.DataBoundItem as Nguoi).MaNguoi, (comboBox2.SelectedItem as CaLamViec).MaCaLamViec, (comboBox1.SelectedItem as KyHieuCacLoaiVang).MaKyHieu, textBox9.Text.Trim());
}
}
}
}
i++;
}
MessageBox.Show("Thêm công vắng thành công!");
}
catch (Exception ex)
{
if (ex.Message == "An error occurred while executing the command definition. See the inner exception for details.")
{
Nguoi loi = (dataGridView1.Rows[i].DataBoundItem as Nguoi);
MessageBox.Show("Thêm vắng bị dừng giữa chừng \nKhông thể thêm vắng cho " + loi.HoTen + "(" + loi.MaNguoi.ToString() + ")" + "\n" + (comboBox2.SelectedItem as CaLamViec).MaCaLamViec + " Ngày " + y.ToString() + "/" + (comboBox4.SelectedIndex + 1).ToString() + "/" + (2020 + comboBox5.SelectedIndex).ToString() + " Đã tồn tại!", "Cảnh báo!");
}
else
{
MessageBox.Show(ex.Message);
}
}
DataGridView2Config(dataGridView1.SelectedRows[0].DataBoundItem as Nguoi);
Cursor.Current = Cursors.Default;
button1.Enabled = true;
}
