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