public List <GiaoVu> LayDanhSachGiaoVu() { using (MamNonBK context = new MamNonBK()) { var DsGiaoVu = from gv in context.GiaoVus.AsNoTracking() select gv; return(DsGiaoVu.ToList()); } }
public List <DangKyHoc> GetAlls() { using (MamNonBK db = new MamNonBK()) { var dsDK = from dk in db.DangKyHocs.AsNoTracking() select dk; return(dsDK.ToList()); } }
public List <LopHanhChinh> GetAlls() { using (MamNonBK db = new MamNonBK()) { var dsLopHC = from lophc in db.LopHanhChinhs select lophc; return(dsLopHC.ToList()); } }
public List <HocSinh> GetAlls() { using (MamNonBK db = new MamNonBK()) { var dsHS = from hs in db.HocSinhs.Include("LopHanhChinh").AsNoTracking() select hs; return(dsHS.ToList()); } }
public List <CLB> GetAlls() { using (MamNonBK db = new MamNonBK()) { var dsCLB = from clb in db.CLBs select clb; return(dsCLB.ToList()); } }
public List <HoaDon> GetAlls() { using (MamNonBK db = new MamNonBK()) { var dsHD = from hd in db.HoaDons.AsNoTracking() select hd; return(dsHD.ToList()); } }
public GiaoVu LayThongTinGiaoVuBangMaGiaoVu(string MaGiaoVu) { using (MamNonBK context = new MamNonBK()) { var TTGiaoVu = from gv in context.GiaoVus.AsNoTracking() where MaGiaoVu == gv.MaGV select gv; return(TTGiaoVu.ToList().FirstOrDefault()); } }
public GiaoVu LayThongtinGiaoVu(string TaiKhoan) { using (MamNonBK context = new MamNonBK()) { var TTGiaoVu = from gv in context.GiaoVus.AsNoTracking() where TaiKhoan == gv.TaiKhoan select gv; return(TTGiaoVu.ToList().FirstOrDefault()); } }
public List <DangKyHoc> GetAllsCurrent() { using (MamNonBK db = new MamNonBK()) { var DsDKhocThangHienTai = from dkhoc in db.DangKyHocs.AsNoTracking() where (dkhoc.NgayDangKy.Year == DateTime.Now.Year && dkhoc.NgayDangKy.Month == DateTime.Now.Month) select dkhoc; return(DsDKhocThangHienTai.ToList()); } }
public List <HoaDon> GetAllCurrent() { using (MamNonBK db = new MamNonBK()) { var DsHoaDonThangHienTai = from hd in db.HoaDons.AsNoTracking() where (hd.NgayTao.Value.Month == DateTime.Now.Month && hd.NgayTao.Value.Year == DateTime.Now.Year) select hd; return(DsHoaDonThangHienTai.ToList()); } }
public int ThemCLBMoi(string TenCLB) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenCLB", TenCLB); return(db.Execute("ThemCLB", p, commandType: CommandType.StoredProcedure)); } } }
public List <LopDangKy> LayDanhSachLopDangKy() { List <LopDangKy> DsLopDK = new List <LopDangKy>(); using (MamNonBK db = new MamNonBK()) { DsLopDK = (from ds in db.LopDangKies.Include("CLB1").AsNoTracking() select ds).ToList(); return(DsLopDK); } }
public void XoaDuLieuHoaDon(string MaHD) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@MaHoaDon", MaHD); db.Execute("XoaDuLieuHoaDOn", p, commandType: CommandType.StoredProcedure); } } }
public void HuyDangKy(string MaHS, string MaLopDangKy) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@MaHocSinh", MaHS); p.Add("@LopDangKy", MaLopDangKy); db.Execute("HuyDangKyHoc", p, commandType: CommandType.StoredProcedure); } } }
public int UpdateHD(string MaHD) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@MaHD", MaHD); return(db.Execute("UpdateTinhTrangHoaDon", p, commandType: CommandType.StoredProcedure)); } } }
public int ThemLopHCMoi(string TenLopHC, string NienKhoa, string TenGiaoVienCN) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenLopHC", TenLopHC); p.Add("@NienKhoa", NienKhoa); p.Add("@TenGiaoVienChuNhiem", TenGiaoVienCN); return(db.Execute("ThemLopHC", p, commandType: CommandType.StoredProcedure)); } } }
public void DoiMatKhau(string MaGiaoVu, string MatKhauMoi) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { //Đổi mật khẩu var p = new DynamicParameters(); p.Add("@MatKhauMoi", MatKhauMoi); p.Add("@MaGV", MaGiaoVu); db.Execute("DoiMatKhau", p, commandType: CommandType.StoredProcedure); } } }
public void DangKyMoi(string MaHS, string MaLopDangKy) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { //Tạo hóa đơn var p = new DynamicParameters(); p.Add("@MaHocSinh", MaHS); db.Execute("InsertHoaDon", p, commandType: CommandType.StoredProcedure); //Đăng ký học var q = new DynamicParameters(); q.Add("@LopDK", MaLopDangKy); q.Add("@HocSinh", MaHS); db.Execute("DangKyHocProc", q, commandType: CommandType.StoredProcedure); } } }
public int ThemHocSinh(string TenHS, DateTime NgaySinh, string TenChaMe, string SDTChaMe, string DiaChi, string LopHC) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenHS", TenHS); p.Add("@NgaySinh", NgaySinh.ToString("yyyy-MM-dd")); p.Add("@TenChaMe", TenChaMe); p.Add("@SDTChaMe", SDTChaMe); p.Add("@DiaChi", DiaChi); p.Add("@LopHC", LopHC); return(db.Execute("ThemHocSinh", p, commandType: CommandType.StoredProcedure)); } } }
public int DoiThongTinTaiKhoan(string MaGiaoVU, string TenGiaoVu, string SDT, string Email, string TaiKhoan) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenGiaoVu", TenGiaoVu); p.Add("@Email", Email); p.Add("@DienThoai", SDT); p.Add("@TaiKhoan", TaiKhoan); p.Add("@MaGiaoVu", MaGiaoVU); return(db.Execute("UpdateTTGiaoVu", p, commandType: CommandType.StoredProcedure)); } } }
public int ThemGiaoVu(string TenGiaoVu, string SDT, string Email, string TaiKhoan, string MatKhau) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenGiaoVu", TenGiaoVu); p.Add("@TaiKhoan", TaiKhoan); p.Add("@MatKhau", MatKhau); p.Add("@Email", Email); p.Add("@SDT", SDT); return(db.Execute("ThemTaiKhoanGiaoVu", p, commandType: CommandType.StoredProcedure)); } } }
public int ThemThongTinLopDangKy(string TenLop, string MaCLB, string Namhoc, decimal HocPhi, int LichHoc) { using (MamNonBK context = new MamNonBK()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { var p = new DynamicParameters(); p.Add("@TenLopDangKy", TenLop); p.Add("@HocPhi", HocPhi); p.Add("@NamHoc", Namhoc); p.Add("@LichHoc", LichHoc); p.Add("@MaCLB", MaCLB); return(db.Execute("ThemLopDangKyMoi", p, commandType: CommandType.StoredProcedure)); } } }
public bool CheckuserName(string username) { using (MamNonBK context = new MamNonBK()) { var TaiKhoan = from tk in context.GiaoVus.AsNoTracking() where tk.TaiKhoan == username select tk.TaiKhoan; if (!TaiKhoan.ToList().Any()) { return(false); } else { return(true); } } }