public static bool suaDiem(string strMaMon, string strMaSV, string strMaHK, string strMaDiem, float fSoDiem, float fHeSo, DateTime dtmNgayDiem)
{
dataProvider = new CDataProvider_DAL();
string strUpdateDiem = string.Format("update DiemSo set SoDiem='{3}', HeSo='{4}', NgayDiem='{5}' where MaMon='{0}' and MaSV='{1}' and MaDiem='{2}'",
strMaMon, strMaSV, strMaDiem, fSoDiem, fHeSo, dtmNgayDiem);
string error = "";
return(dataProvider.excuteNonQuery(strUpdateDiem, ref error));
}
public static bool removeDiem(string strMaMon, string strMaSV, string strMaHK, string strMaDiem)
{
dataProvider = new CDataProvider_DAL();
string strUpdateDiem = string.Format("delete DiemSo where MaMon='{0}' and MaSV='{1}' and MaDiem='{2}' and MaHK='{3}'",
strMaMon, strMaSV, strMaDiem, strMaHK);
string error = "";
return(dataProvider.excuteNonQuery(strUpdateDiem, ref error));
}
public static bool addAccountSinhVien(string strTaiKhoan, string strMatKhau)
{
dataProvider = new CDataProvider_DAL();
string strAddSinhVien = string.Format("insert into AccountSinhVien values ('{0}',N'{1}')", strTaiKhoan, strMatKhau);
string strErr = "";
dataProvider.excuteNonQuery(strAddSinhVien, ref strErr);
if (strErr != "")
{
return(false);
}
return(true);
}
public static bool suaSinhVien(string strMaSV, string strHoTen, bool bGioiTinh, DateTime dtmNgaySinh, string strDiaChi, string strCacThongTinKhac, string ImageSV)
{
dataProvider = new CDataProvider_DAL();
string strAddSinhVien = string.Format("update SinhVien set HoTen=N'{1}',GioiTinh='{2}',NgaySinh='{3}',DiaChi=N'{4}',CacThongTin=N'{5}',HinhAnh='{6}' where MaSV='{0}'",
strMaSV, strHoTen, bGioiTinh, dtmNgaySinh, strDiaChi, strCacThongTinKhac, ImageSV);
string strErr = "";
dataProvider.excuteNonQuery(strAddSinhVien, ref strErr);
if (strErr != "")
{
return(false);
}
return(true);
}
public static bool themSinhVien(string strMaSV, string strHoTen, bool bGioiTinh, DateTime dtmNgaySinh, string strDiaChi, string strCacThongTinKhac, string ImageSV)
{
dataProvider = new CDataProvider_DAL();
string strAddSinhVien = string.Format("insert into SinhVien values ('{0}',N'{1}','{2}','{3}','{4}','{5}','{6}')",
strMaSV, strHoTen, bGioiTinh, dtmNgaySinh, strDiaChi, strCacThongTinKhac, ImageSV);
string strErr = "";
dataProvider.excuteNonQuery(strAddSinhVien, ref strErr);
if (strErr != "")
{
return(false);
}
return(true);
}
public static bool themLichHoc(string strMaSV, int iThu, string strMaHD, string strMaMon, bool bChinhKhoa, DateTime dtmGioBD, DateTime dtmGioKT, string strGhiChu, int MauSac)
{
dataProvider = new CDataProvider_DAL();
string strAddCmd = string.Format("spAddLichHoc");
string strErr = "";
dataProvider.excuteNonQuery(strAddCmd, ref strErr, CommandType.StoredProcedure,
new SqlParameter("@MaSV", strMaSV),
new SqlParameter("@Thu", iThu),
new SqlParameter("@MaHD", strMaHD),
new SqlParameter("@MaMon", strMaMon),
new SqlParameter("@ChinhKhoa", bChinhKhoa),
new SqlParameter("@GioBD", dtmGioBD),
new SqlParameter("@GioKT", dtmGioKT),
new SqlParameter("@GhiChuHD", strGhiChu),
new SqlParameter("@MauMucDo", MauSac)
);
if (strErr != "")
{
return(false);
}
return(true);
}