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