public static bool UpdateMonHoc(string x_strMaMonHoc, string x_strTenMonHoc)
{
if (DataProvider.ConnectDatabase())
{
return(DataProvider.ExecSQLQuery(string.Format("UPDATE MONHOC SET TENMH = N'{0}' WHERE MAMH = '{1}'", x_strTenMonHoc, x_strMaMonHoc)));
}
return(false);
}
public static bool DeleteMonHoc(string x_strMaMonHoc)
{
if (DataProvider.ConnectDatabase())
{
return(DataProvider.ExecSQLQuery(string.Format("DELETE FROM MONHOC WHERE MAMH = '{0}'", x_strMaMonHoc)));
}
return(false);
}
public static bool InsertMonHoc(string x_strMaMonHoc, string x_strTenMonHoc)
{
if (DataProvider.ConnectDatabase())
{
return(DataProvider.ExecSQLQuery(string.Format("INSERT INTO MONHOC(MAMH, TENMH) VALUES('{0}', N'{1}')", x_strMaMonHoc, x_strTenMonHoc)));
}
return(false);
}
public static bool UpdateLop(LopDTO lop)
{
if (DataProvider.ConnectDatabase())
{
string str = "update LOP set TENLOP = N'" + lop.TENLOP + "', MAKH = '" + lop.MAKH + "' where MALOP = '" + lop.MALOP + "'";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}
public static bool DeleteLop(string malop)
{
if (DataProvider.ConnectDatabase())
{
string str = "delete from LOP where MALOP = '" + malop + "'";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}
public static bool AddLop(LopDTO lop)
{
if (DataProvider.ConnectDatabase())
{
string str = "insert into LOP(MALOP,TENLOP,MAKH) values ('" + lop.MALOP + "',N'" + lop.TENLOP + "','" + lop.MAKH + "')";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}
public static bool DeleteSinhVien(string masv)
{
if (DataProvider.ConnectDatabase())
{
string str = "delete from SINHVIEN where MASV = '" + masv + "'";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}
public static bool UpdateSinhVien(SinhVienDTO sv)
{
if (DataProvider.ConnectDatabase())
{
string str = "update SINHVIEN set HO = N'" + sv.HO + "', TEN = N'" + sv.TEN + "',MALOP = '" + sv.MALOP + "' ," +
"PHAI = '" + sv.PHAI + "',NGAYSINH = '" + sv.NGAYSINH + "',NOISINH = N'" + sv.NOISINH + "',DIACHI = N'" + sv.DIACHI + "'," +
"NGHIHOC = '" + sv.NGHIHOC + "',GHICHU = N'" + sv.GHICHU + "' where MASV = '" + sv.MASV + "'";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}
public static bool AddSinhVien(SinhVienDTO sv)
{
if (DataProvider.ConnectDatabase())
{
string str = "insert into SINHVIEN(MASV,HO,TEN,MALOP,PHAI,NGAYSINH,NOISINH,DIACHI,NGHIHOC,GHICHU) " +
"values('" + sv.MASV + "',N'" + sv.HO + "',N'" + sv.TEN + "','" + sv.MALOP + "','" + sv.PHAI + "'," +
"'" + sv.NGAYSINH + "',N'" + sv.NOISINH + "',N'" + sv.DIACHI + "','" + sv.NGHIHOC + "',N'" + sv.GHICHU + "')";
return(DataProvider.ExecSQLQuery(str));
}
return(false);
}