//duc hung
private void button1_Click(object sender, EventArgs e)
{
ThongTinGiangDay gv = new ThongTinGiangDay();
bool add = false;
try
{
gv.MaKip = textBox1.Text;
gv.MaGV = new GiaoVienDAO().GetIDbyName(comboBox1.Text);
gv.SoTiet = Convert.ToInt32(textBox3.Text);
gv.TenLop = comboBox2.Text;
gv.MonHoc = textBox2.Text;
gv.Ngay = dateTimePicker1.Value;
add = new ThongTinGiangDayDAO().Insert(gv);
}
catch
{
}
if (!add)
{
MessageBox.Show("Mã kíp đã tồn tại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Đã thêm lịch", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
dtg_TTGD.DataSource = new ThongTinGiangDayDAO().ListAll();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
}
private void button3_Click(object sender, EventArgs e)
{
bool del = new ThongTinGiangDayDAO().Delete(textBox1.Text);
MessageBox.Show("Đã xóa", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
dtg_TTGD.DataSource = new ThongTinGiangDayDAO().ListAll();
}
private void dtg_TTGD_CellClick(object sender, DataGridViewCellEventArgs e)
{
dtg_TTGD.CurrentRow.Selected = true;
string MaGV = dtg_TTGD.CurrentRow.Cells["MaKip"].Value.ToString();
var chosen = new ThongTinGiangDayDAO().GetByID(MaGV);
textBox1.Text = chosen.MaKip;
comboBox1.Text = new GiaoVienDAO().GetByID(chosen.MaGV).HoTen;
textBox3.Text = chosen.SoTiet.ToString();
dateTimePicker1.Value = Convert.ToDateTime(chosen.Ngay);
textBox2.Text = chosen.MonHoc;
comboBox2.Text = chosen.TenLop;
}
private void usr_TTGD_Load(object sender, EventArgs e)
{
ThongTinGiangDayDAO dtgv = new ThongTinGiangDayDAO();
dtg_TTGD.DataSource = dtgv.ListAll();
comboBox1.DataSource = new GiaoVienDAO().GetGvName();
comboBox2.DataSource = new LopHocDAO().GetTenLop();
dtg_TTGD.Columns["MaKip"].HeaderText = "Mã kíp";
dtg_TTGD.Columns["GiaoVien"].HeaderText = "Giáo viên";
dtg_TTGD.Columns["TenLop"].HeaderText = "Lớp";
dtg_TTGD.Columns["MonHoc"].HeaderText = "Môn học";
dtg_TTGD.Columns["Ngay"].HeaderText = "Ngày";
dtg_TTGD.Columns["SoTiet"].HeaderText = "Số tiết";
}
