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