public void DeleteSV(string maSV)
{
string sql = "delete tbl_DIEM where MaSV = '" + maSV + "' ";
sql += "delete tbl_SINHVIEN where MaSV = '" + maSV + "' ";
da.ExcuteNonQuery1(sql);
}
public void insertDiem(string maSV, string maLop, string maMH, float dHS1, float dHS2, float diemThi, float diemTP, float diemHP, string diemChu, int lanThi, int hocKi, int soTietN)
{
try
{
string sql = @"insert into tbl_DIEM (MaSV,MaLop,MaMH,DiemQTHeS1,DiemQTHeS2,DiemThi,DiemTP,DiemTBHP,DiemChuTBHP,LanThi,HocKi,SoTietNghi)";
sql += "values( '" + maSV + "','" + maLop + "','" + maMH + "','" + dHS1 + "','" + dHS2 + "','" + diemThi + "','" + diemTP + "','" + diemHP + "','" + diemChu + "','" + lanThi + "','" + hocKi + "','" + soTietN + "')";
kn.ExcuteNonQuery1(sql);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateTK(string dk, string tk, string mk)
{
string sql = @" UPDATE tbl_NGUOIDUNG SET TaiKhoan = N'" + tk + "' , MatKhau= N'" + mk + "' ";
sql += " WHERE TaiKhoan ='" + dk + "'";
kn.ExcuteNonQuery1(sql);
}
public void InsertKhoa(string maKhoa, string tenKhoa, string sdt, string email, string diaChi)
{
string sql = " INSERT INTO tbl_KHOA VALUES ('" + maKhoa + "', N'" + tenKhoa + "', '" + sdt + "','" + email + "', N'" + diaChi + "') ";
kn.ExcuteNonQuery1(sql);
}
public void UpdateNghanh(string madk, string maNghanh, string tenNghanh, int soLop, string maKhoa, int sdt, string email, string diaChi)
{
string sql = " Update tbl_NGHANH SET MaNghanh ='" + maNghanh + "', TenNghanh =N'" + tenNghanh + "', SoLop= '" + soLop + "', MaKhoa='" + maKhoa + "', SDT='" + sdt + "', Email ='" + email + "' , DiaChi =N'" + diaChi + "' WHERE MaNghanh ='" + madk + "' ";
kn.ExcuteNonQuery1(sql);
}
public void InsertTK(string tk, string mk)
{
string sql = " INSERT INTO tbl_NGUOIDUNG VALUES (N'" + tk + "', N'" + mk + "')";
kn.ExcuteNonQuery1(sql);
}
public void DeleteMH(string maMH)
{
string sql = "delete from tbl_MONHOC where MaMH = '" + maMH + "'";
da.ExcuteNonQuery1(sql);
}
public void InsertNghanh(string maNghanh, string tenNghanh, int soLop, string maKhoa, int sdt, string email, string diaChi)
{
string sql = " INSERT INTO tbl_NGHANH VALUES ('" + maNghanh + "', N'" + tenNghanh + "',N'" + soLop + "', '" + maKhoa + "', '" + sdt + "','" + email + "', N'" + diaChi + "') ";
kn.ExcuteNonQuery1(sql);
}
public void DeleteLop(string malop)
{
string sql = "delete tbl_LOP where MaLop = '" + malop + "' ";
da.ExcuteNonQuery1(sql);
}
public void DeleteGV(string maGV)
{
string sql = "delete tbl_GIAOVIEN where MaGV = '" + maGV + "' ";
kn.ExcuteNonQuery1(sql);
}