Exemple #1
0
 public NhanVienDom()
 {
     db = new QLKSdbContext();
 }
Exemple #2
0
 public KhachHangDom()
 {
     db = new QLKSdbContext();
 }
Exemple #3
0
 public UserDom()
 {
     db = new QLKSdbContext();
 }
Exemple #4
0
        public ActionResult Dashboardv1()
        {
            //QUẢN LÝ THPT
            List <DIEM> hs = dbTHPTcontext.DIEMs.ToList();

            ViewBag.HocSinh = hs;

            ViewBag.totalStudent    = (from s in dbTHPTcontext.HOCSINHs select s).Count();
            ViewBag.totalStudentXS  = (from s in dbTHPTcontext.DIEMs where s.HocLuc == "Xuất Sắc" select s).Count();
            ViewBag.totalStudentG   = (from s in dbTHPTcontext.DIEMs where s.HocLuc == "Giỏi" select s).Count();
            ViewBag.totalStudentK   = (from s in dbTHPTcontext.DIEMs where s.HocLuc == "Khá" select s).Count();
            ViewBag.totalStudentTB  = (from s in dbTHPTcontext.DIEMs where s.HocLuc == "Trung Bình" select s).Count();
            ViewBag.totalStudentY   = (from s in dbTHPTcontext.DIEMs where s.HocLuc == "Yếu" select s).Count();
            ViewBag.totalStudentDUT = (from s in dbTHPTcontext.HOCSINHs where s.MaDUT != 1 select s).Count();
            ViewBag.totalTeacher    = (from t in dbTHPTcontext.HOCSINHs select t).Count();
            ViewBag.totalClass      = (from c in dbTHPTcontext.HOCSINHs select c).Count();

            // QL_NhanSu
            DBQLNSContext dBQLNS = new DBQLNSContext();

            ViewBag.TotalStaffON  = dBQLNS.staffs.Where(x => x.sta_status == 1).Count();
            ViewBag.TotalStaffOFF = dBQLNS.staffs.Where(x => x.sta_status == 0).Count();
            var gr_admin = dBQLNS.group_role.Where(x => x.gr_name == "Admin").FirstOrDefault();
            var gr_user  = dBQLNS.group_role.Where(x => x.gr_name == "User").FirstOrDefault();

            if (gr_admin != null)
            {
                ViewBag.TotalQL = dBQLNS.staffs.Where(x => x.group_role_id == gr_admin.gr_id).Count();
            }
            if (gr_user != null)
            {
                ViewBag.TotalND = dBQLNS.staffs.Where(x => x.group_role_id == gr_user.gr_id).Count();
            }


            // QL_ThuVien
            DBQLTVContext dbQLTV    = new DBQLTVContext();
            var           totalBook = (from b in dbQLTV.Saches
                                       select b).Count();

            var totalCategory = (from c in dbQLTV.TheLoais
                                 select c).Count();

            var totalPublishingCompany = (from c in dbQLTV.NhaXuatBans
                                          select c).Count();

            var totalAuthor = (from a in dbQLTV.TacGias
                               select a).Count();

            var totalReader = (from r in dbQLTV.DocGias
                               select r).Count();

            var totalBG = (from bg in dbQLTV.MuonTraSaches
                           select bg).Count();

            var alreadyBG = (from bg in dbQLTV.MuonTraSaches
                             where bg.DaTra == true
                             select bg).Count();

            var yetBG = (from bg in dbQLTV.MuonTraSaches
                         where bg.DaTra == false
                         select bg).Count();

            ViewBag.TotalBook              = totalBook;
            ViewBag.TotalCategory          = totalCategory;
            ViewBag.TotalPublishingCompany = totalPublishingCompany;
            ViewBag.TotalAuthor            = totalAuthor;
            ViewBag.TotalReader            = totalReader;
            ViewBag.TotalBG   = totalBG;
            ViewBag.AlreadyBG = alreadyBG;
            ViewBag.YetBG     = yetBG;

            // QL_Kho
            DBQLKHOContext dbQLKHO = new DBQLKHOContext();
            var            HH      = (from b in dbQLKHO.HANGHOAs
                                      select b).Count();

            var KH = (from c in dbQLKHO.KHACHHANGs
                      select c).Count();

            var NCC = (from c in dbQLKHO.NHACCs
                       select c).Count();

            var PN = (from a in dbQLKHO.PHIEUNHAPs
                      select a).Count();

            var PX = (from r in dbQLKHO.PHIEUXUATs
                      select r).Count();

            ViewBag.HH  = HH;
            ViewBag.KH  = KH;
            ViewBag.NCC = NCC;
            ViewBag.PN  = PN;
            ViewBag.PX  = PX;

            // QL_KhachSan

            QLKSdbContext dbQLKS = new QLKSdbContext();

            ViewBag.NhanVien = dbQLKS.NhanViens.Count();
            // số lượng khách hàng
            ViewBag.KhachHang = dbQLKS.KhachHangs.Count();
            // thu lãi ngày
            ViewBag.ThuNgay = Convert.ToDecimal((dbQLKS.PhieuThus.Where(p => p.ngaytao.Value.Day == DateTime.Now.Day).Sum(p => p.tongtien)));
            // chi tiề ngày
            ViewBag.ChiNgay = Convert.ToDecimal((dbQLKS.PhieuChis.Where(p => p.ngaytao.Value.Day == DateTime.Now.Day).Sum(p => p.tongtien)));
            // thu lãi tháng
            ViewBag.ThuThang = Convert.ToDecimal((dbQLKS.PhieuThus.Where(p => p.ngaytao.Value.Month == DateTime.Now.Month).Sum(p => p.tongtien)));
            // chi tiền tháng
            ViewBag.ChiThang = Convert.ToDecimal((dbQLKS.PhieuChis.Where(p => p.ngaytao.Value.Month == DateTime.Now.Month).Sum(p => p.tongtien)));

            // QL_TruongTHPT

            return(View());
        }
 public PhieuChiDom()
 {
     db = new QLKSdbContext();
 }
Exemple #6
0
 public DichVuChungDom()
 {
     db = new QLKSdbContext();
 }