public static TinNhan GetTinNhanTheoId(int id)
{
using (var db = new UMS_HUSCEntities())
{
var tn = db.TINNHANs.FirstOrDefault(t => t.MaTinNhan.Equals(id));
if (tn == null)
{
return(null);
}
string temp = HttpUtility.HtmlDecode(tn.NoiDung);
tn.NoiDung = temp.Replace("\r\n", "")
.Replace("style=\"", "style='")
.Replace("href=\"", "href='")
.Replace("\">", "'>")
.Replace(";\"", ";'")
.Replace("\"", """);
tn.TieuDe = HttpUtility.HtmlDecode(tn.TieuDe).Replace("\r\n", "");
return(new TinNhan()
{
MaTinNhan = tn.MaTinNhan,
MaNguoiGui = tn.NGUOIGUIs.ElementAt(0).MaNguoiGui,
HoTenNguoiGui = tn.NGUOIGUIs.ElementAt(0).HoTenNguoiGui,
TieuDe = tn.TieuDe,
NoiDung = tn.NoiDung,
ThoiDiemGui = tn.ThoiDiemGui,
NguoiNhans = GetAllNguoiNhan(tn.MaTinNhan)
});
}
}
public static bool AddFireBase(string maSinhVien, string token)
{
using (UMS_HUSCEntities db = new UMS_HUSCEntities())
{
try
{
var current = db.FIREBASEs.FirstOrDefault(f => f.MaSinhVien.Equals(maSinhVien) && f.Token.Equals(token));
if (current != null)
{
return(false);
}
FIREBASE fIREBASE = new FIREBASE()
{
Id = 1, MaSinhVien = maSinhVien, Token = token
};
db.FIREBASEs.Add(fIREBASE);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public static VLichSuBanThan GetLichSuBanThan(string maSinhVien)
{
UMS_HUSCEntities db = new UMS_HUSCEntities();
var current = db.VLichSuBanThans.FirstOrDefault(v => v.MaSinhVien.Equals(maSinhVien));
return(current);
}
public static int MaxMaHocKy()
{
using (var db = new UMS_HUSCEntities())
{
return(db.VHocKies.Max(i => i.MaHocKy));
}
}
public static List <TinNhan> GetTinNhanNhanDaXoa(string maSinhVien)
{
using (var db = new UMS_HUSCEntities())
{
var list = new List <TinNhan>();
var maTaiKhoan = SinhVienDao.GetMaTaiKhoan(maSinhVien);
var tinDaNhan = db.VTinNhanDaNhans.Where(n => n.MaNguoiNhan == maTaiKhoan && n.TrangThai == TINNHAN_TAM_XOA).ToList();
foreach (var item in tinDaNhan)
{
string temp = HttpUtility.HtmlDecode(item.NoiDung);
item.NoiDung = temp.Replace("\r\n", "")
.Replace("style=\"", "style='")
.Replace("href=\"", "href='")
.Replace("\">", "'>")
.Replace(";\"", ";'")
.Replace("\"", """);
item.TieuDe = HttpUtility.HtmlDecode(item.TieuDe).Replace("\r\n", "");
TinNhan tinNhan = new TinNhan()
{
MaTinNhan = item.MaTinNhan,
MaNguoiGui = item.MaNguoiGui,
HoTenNguoiGui = item.HoTenNguoiGui,
TieuDe = item.TieuDe,
NoiDung = item.NoiDung,
ThoiDiemGui = item.ThoiDiemGui,
NguoiNhans = GetAllNguoiNhan(item.MaTinNhan)
};
list.Add(tinNhan);
}
return(list.OrderBy(t => t.ThoiDiemGui).ToList());
}
}
public static bool TonTaiSinhVien(string maSinhVien, string matKhau)
{
using (var db = new UMS_HUSCEntities())
{
return(GetSinhVien(maSinhVien, matKhau) == null ? false : true);
}
}
public static int GetMaxMaTinNhan()
{
using (var db = new UMS_HUSCEntities())
{
return(db.TINNHANs.Max(t => t.MaTinNhan));
}
}
public static VThuongTru ThuongTru(string maSinhVien)
{
UMS_HUSCEntities db = new UMS_HUSCEntities();
var current = db.VThuongTrus.FirstOrDefault(v => v.MaSinhVien.Equals(maSinhVien));
return(current);
}
public static bool RestoreTinNhan(int id, string maSinhVien)
{
using (var db = new UMS_HUSCEntities())
{
var current = db.TINNHANs.FirstOrDefault(t => t.MaTinNhan == id);
if (current != null)
{
var maTaiKhoan = SinhVienDao.GetMaTaiKhoan(maSinhVien);
var nguoiGui = db.NGUOIGUIs.FirstOrDefault(n => n.MaNguoiGui == maTaiKhoan && n.MaTinNhan == id);
if (nguoiGui != null) // sinh vien nay la nguoi gui tin nhan
{
nguoiGui.TrangThai = TINNHAN_CHUA_XOA;
}
else
{
var nguoiNhan = db.NGUOINHANs.FirstOrDefault(n => n.MaNguoiNhan == maTaiKhoan && n.MaTinNhan == id);
if (nguoiNhan != null)
{
nguoiNhan.TrangThai = TINNHAN_CHUA_XOA;
}
}
db.SaveChanges();
return(true);
}
return(false);
}
}
public static PHONGHOC GetPhongHoc(int maPhong)
{
using (var db = new UMS_HUSCEntities())
{
return(db.PHONGHOCs.FirstOrDefault(l => l.MaPhong == maPhong));
}
}
public static GIANGVIEN GetGiangVien(int maGiangVien)
{
using (var db = new UMS_HUSCEntities())
{
return(db.GIANGVIENs.FirstOrDefault(l => l.MaGiangVien == maGiangVien));
}
}
public static long GetTongTinNhanDaXoa(string maSinhVien)
{
using (UMS_HUSCEntities db = new UMS_HUSCEntities())
{
return(GetAllTinNhanDaXoa(maSinhVien).Count());
}
}
public static List <LICHHOC> GetLichHoc(LOPHOCPHAN lopHocPhan, THOIKHOABIEU thoiKhoaBieu)
{
using (var db = new UMS_HUSCEntities())
{
var ngayBatDauHoc = lopHocPhan.NgayBatDauHoc;
var ngayKetThucHoc = lopHocPhan.NgayKetThucHoc;
var ngayTrongTuan = thoiKhoaBieu.NgayTrongTuan - 1;
var lichHoc = new List <LICHHOC>();
for (var index = ngayBatDauHoc; index <= ngayKetThucHoc; index = index.AddHours(24))
{
if (index.DayOfWeek.GetHashCode() == ngayTrongTuan)
{
var item = new LICHHOC()
{
MaLopHocPhan = lopHocPhan.MaLopHocPhan,
PhongHoc = thoiKhoaBieu.PhongHoc,
TietHocBatDau = thoiKhoaBieu.TietHocBatDau,
TietHocKetThuc = thoiKhoaBieu.TietHocKetThuc,
NgayHoc = index
};
lichHoc.Add(item);
}
}
return(lichHoc);
}
}
public static LOPHOCPHAN GetLopHocPhan(string maLopHocPhan)
{
using (var db = new UMS_HUSCEntities())
{
return(db.LOPHOCPHANs.FirstOrDefault(l => l.MaLopHocPhan.Equals(maLopHocPhan)));
}
}
public static List <ThoiKhoaBieu> GetLichHoc(string maLopHocPhan)
{
using (var db = new UMS_HUSCEntities())
{
var maxMaHocKy = db.VHocKies.Max(i => i.MaHocKy);
var lichHocs = db.VThoiKhoaBieux.Where(i => i.MaLopHocPhan.Equals(maLopHocPhan) && i.HocKy == maxMaHocKy)
.Select(i => new ThoiKhoaBieu()
{
MaSinhVien = "",
HoVaTen = i.HoVaTen, // Ho ten giang vien
MaLopHocPhan = i.MaLopHocPhan,
TenLopHocPhan = i.TenLopHocPhan,
HocKy = i.HocKy,
NgayHoc = i.NgayHoc,
PhongHoc = i.PhongHoc,
TenPhong = i.TenPhong,
TietHocBatDau = i.TietHocBatDau,
TietHocKetThuc = i.TietHocKetThuc
}).ToList();
lichHocs.ForEach(i => i.NgayTrongTuan = i.NgayHoc.DayOfWeek.GetHashCode() + 1);
return(lichHocs);
}
}
public static void AddThongBao(THONGBAO thongBao)
{
UMS_HUSCEntities db = new UMS_HUSCEntities();
db.THONGBAOs.Add(thongBao);
db.SaveChanges();
}
public static List <ThoiKhoaBieu> GetThoiKhoaBieu(string maSinhVien, int maHocKy)
{
using (var db = new UMS_HUSCEntities())
{
var list = db.VThoiKhoaBieux.Where(i => i.HocKy == maHocKy &&
i.MaSinhVien.Equals(maSinhVien)).OrderBy(i => i.NgayHoc)
.Select(i => new ThoiKhoaBieu()
{
MaSinhVien = maSinhVien,
HoVaTen = i.HoVaTen, // Ho ten giang vien
MaLopHocPhan = i.MaLopHocPhan,
TenLopHocPhan = i.TenLopHocPhan,
HocKy = i.HocKy,
NgayHoc = i.NgayHoc,
PhongHoc = i.PhongHoc,
TenPhong = i.TenPhong,
TietHocBatDau = i.TietHocBatDau,
TietHocKetThuc = i.TietHocKetThuc
}).ToList();
list.ForEach(i => i.NgayTrongTuan = i.NgayHoc.DayOfWeek.GetHashCode() + 1);
return(list);
}
}
public static List <TaiKhoan> GetMaTaiKhoanVaHoTen(string nameQuery, int soTrang, int soDong)
{
using (var db = new UMS_HUSCEntities())
{
var sinhViens = db.VThongTinCaNhans.Where(s => s.HoTen.ToLower().Trim().Contains(nameQuery.ToLower().Trim()))
.Select(s => new TaiKhoan()
{
MaTaiKhoan = s.MaTaiKhoan,
HoTen = s.HoTen,
MaSinhVien = s.MaSinhVien
}).ToList();
var giangViens = db.GIANGVIENs.Where(g => g.HoVaTen.ToLower().Trim().Contains(nameQuery.ToLower().Trim()))
.Select(g => new TaiKhoan()
{
MaTaiKhoan = g.MaTaiKhoan.Value,
HoTen = g.HoVaTen,
MaSinhVien = ""
}).ToList();
sinhViens.AddRange(giangViens);
var skipRow = (soTrang - 1) * soDong;
return(sinhViens.Skip(skipRow).Take(soDong).ToList());
}
}
public static long GetTongTinNhanDaNhan(string maSinhVien)
{
using (UMS_HUSCEntities db = new UMS_HUSCEntities())
{
var maTaiKhoan = SinhVienDao.GetMaTaiKhoan(maSinhVien);
return(db.VTinNhanDaNhans.Where(t => t.MaNguoiNhan.Equals(maTaiKhoan)).Count());
}
}
public static VThongTinLienHe ThongTinLienHe(string maSinhVien)
{
using (UMS_HUSCEntities db = new UMS_HUSCEntities())
{
var current = db.VThongTinLienHes.FirstOrDefault(v => v.MaSinhVien.Equals(maSinhVien));
return(current);
}
}
public static int GetMaTaiKhoan(string maSinhVien)
{
using (var db = new UMS_HUSCEntities())
{
var maTaiKhoan = db.SINHVIENs.FirstOrDefault(s => s.MaSinhVien.Equals(maSinhVien)).MaTaiKhoan;
return(maTaiKhoan.Value);
}
}
public static void AddTinNhan(TINNHAN tinNhan)
{
using (var db = new UMS_HUSCEntities())
{
db.TINNHANs.Add(tinNhan);
db.SaveChanges();
}
}
public static SINHVIEN GetSinhVien(string maSinhVien, string matKhau)
{
using (var db = new UMS_HUSCEntities())
{
return(db.SINHVIENs.Include("TAIKHOAN").FirstOrDefault(
sv => sv.MaSinhVien.ToLower().Equals(maSinhVien.ToLower()) && sv.TAIKHOAN.MatKhau.Equals(matKhau)));
}
}
public static void AddLichHoc(LICHHOC lichHoc)
{
using (var db = new UMS_HUSCEntities())
{
db.LICHHOCs.Add(lichHoc);
db.SaveChanges();
}
}
public ActionResult DemoSignUpClassThird(FormCollection form)
{
using (var db = new UMS_HUSCEntities())
{
var maSinhVien = form["sinhVien"];
var lopHocPhan = form["lopHocPhan"];
LopHocPhanDao.DangKyLop(maSinhVien, lopHocPhan);
return(RedirectToAction("DemoSignUpClassFirst", "Demo"));
}
}
public ActionResult DemoSignUpClassFirst()
{
using (var db = new UMS_HUSCEntities())
{
var hocKys = db.VHocKies.OrderByDescending(i => i.TenHocKy)
.OrderByDescending(i => i.NamBatDau).ToList();
return(View(new DemoSignUpCourse()
{
HocKys = hocKys
}));
}
}
public ActionResult DemoSignUpClassSecond(int hocKy)
{
using (var db = new UMS_HUSCEntities())
{
var lopHocPhans = db.LOPHOCPHANs.Where(i => i.HocKy == hocKy).ToList();
var sinhViens = db.VThongTinChungs.ToList();
return(View(new DemoSignUpCourse()
{
LopHocPhans = lopHocPhans, sinhViens = sinhViens
}));
}
}
public ActionResult DemoSubScheduleFirst(DemoKetQua demo)
{
using (var db = new UMS_HUSCEntities())
{
var maxHocKy = db.VHocKies.Max(i => i.MaHocKy);
var lopHocPhans = db.LOPHOCPHANs.Where(i => i.HocKy == maxHocKy).ToList();
return(View(new DemoAddSchedule()
{
LopHocPhans = lopHocPhans, Demo = demo
}));
}
}
public static List <TinNhan> SearchTinNhanDaXoa(string maSinhVien, string keyword, int soTrang, int soDong)
{
using (var db = new UMS_HUSCEntities())
{
var skipRow = (soTrang - 1) * soDong;
var keywordLower = keyword.ToLower();
var all = GetAllTinNhanDaXoa(maSinhVien);
var result = all.Where(t => t.TieuDe.ToLower().Contains(keywordLower) ||
t.HoTenNguoiGui.ToLower().Contains(keywordLower));
return(result.OrderByDescending(t => t.ThoiDiemGui).Skip(skipRow).Take(soDong).ToList());
}
}
public IHttpActionResult HocKy(string order, string maSinhVien, string matKhau, int maHocKy = 0)
{
if (string.IsNullOrEmpty(order) || string.IsNullOrEmpty(maSinhVien) || string.IsNullOrEmpty(matKhau))
{
return(BadRequest("Thông tin người dùng không được rỗng"));
}
if (!SinhVienDao.TonTaiSinhVien(maSinhVien, matKhau))
{
return(BadRequest("Thông tin người dùng không đúng"));
}
using (var db = new UMS_HUSCEntities())
{
switch (order.ToLower())
{
case "danhsach":
var hocKys = db.VHocKies.OrderByDescending(i => i.MaHocKy).ToArray();
return(Ok(hocKys));
case "tacnghiep":
var hocKy = db.VHocKies.FirstOrDefault(i => i.MaHocKy == maHocKy);
if (hocKy != null)
{
var sinhVien = db.SINHVIENs.FirstOrDefault(s => s.MaSinhVien.Equals(maSinhVien));
if (sinhVien != null)
{
sinhVien.HocKyTacNghiep = hocKy.MaHocKy;
db.SaveChanges();
return(ThoiKhoaBieu(maSinhVien, matKhau, hocKy.MaHocKy));
}
}
return(BadRequest("Mã học kỳ không tồn tại"));
case "dongbo":
var hocKyHienTai = db.SINHVIENs.FirstOrDefault(s => s.MaSinhVien.Equals(maSinhVien)).HocKyTacNghiep;
if (maHocKy == hocKyHienTai)
{
return(Ok(true));
}
else
{
return(Ok(hocKyHienTai));
}
default:
return(BadRequest("Tham số không hợp lệ"));
}
}
}
