private void btnxoa_Click(object sender, EventArgs e)
{
PhanCongGiangDayDTO dto = new PhanCongGiangDayDTO((String)cblop.SelectedValue, (String)cbmon.SelectedValue, (String)cbgv.SelectedValue, datephancong.Text);
myPhanCong.xoaPC(dto);
hienthi();
}
public void xoa(PhanCongGiangDayDTO dto)
{
KetNoiCoSoDuLieu.MoKetNoi();
String sqlsua = "Delete PhanCongGiangDay where MaLop=@malop AND MaMon=@mamon AND MaCanBoGiaoVien=@macbgv";
SqlCommand cmd = new SqlCommand(sqlsua, KetNoiCoSoDuLieu.KetNoi);
cmd.Parameters.AddWithValue("malop", dto.MaLop);
cmd.Parameters.AddWithValue("mamon", dto.MaMon);
cmd.Parameters.AddWithValue("macbgv", dto.MaCanBoGiaoVien);
cmd.ExecuteNonQuery();
KetNoiCoSoDuLieu.DongKetNoi();
}
public void sua(PhanCongGiangDayDTO dto)
{
KetNoiCoSoDuLieu.MoKetNoi();
String sqlsua = "UPDATE PhanCongGiangDay SET NgayPhanCong=@ngaypc WHERE MaLop=@malop AND MaMon=@mamon AND MaCanBoGiaoVien=@macbgv";
SqlCommand cmd = new SqlCommand(sqlsua, KetNoiCoSoDuLieu.KetNoi);
cmd.Parameters.AddWithValue("malop", dto.MaLop);
cmd.Parameters.AddWithValue("mamon", dto.MaMon);
cmd.Parameters.AddWithValue("macbgv", dto.MaCanBoGiaoVien);
cmd.Parameters.AddWithValue("ngaypc", dto.NgayPhanCong);
cmd.ExecuteNonQuery();
KetNoiCoSoDuLieu.DongKetNoi();
}
private void btnsua_Click(object sender, EventArgs e)
{
if (cblop.SelectedIndex != -1 && cbgv.SelectedIndex != -1 && cbmon.SelectedIndex != -1)
{
PhanCongGiangDayDTO dto = new PhanCongGiangDayDTO((String)cblop.SelectedValue, (String)cbmon.SelectedValue, (String)cbgv.SelectedValue, datephancong.Text);
myPhanCong.sua(dto);
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
hienthi();
}
else
{
MessageBox.Show("Thao tác không hợp lệ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <PhanCongGiangDayDTO> LayBangPhanCongGiangDay()
{
List <PhanCongGiangDayDTO> dspcgd = new List <PhanCongGiangDayDTO>();
KetNoiCoSoDuLieu.MoKetNoi();
string sqlSELECT = "SELECT * FROM PhanCongGiangDay";
SqlCommand cmd = new SqlCommand(sqlSELECT, KetNoiCoSoDuLieu.KetNoi);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
PhanCongGiangDayDTO pcgd = new PhanCongGiangDayDTO(
dr["MaLop"].ToString(),
dr["MaMon"].ToString(),
dr["MaCanBoGiaoVien"].ToString(),
dr["NgayPhanCong"].ToString());
dspcgd.Add(pcgd);
}
KetNoiCoSoDuLieu.DongKetNoi();
return(dspcgd);
}
public void xoaPC(PhanCongGiangDayDTO dto)
{
myPhanCongDAL.xoa(dto);
}
public void sua(PhanCongGiangDayDTO dto)
{
myPhanCongDAL.sua(dto);
}
