Beispiel #1
0
        public List <Thongke_lhs_time_class> Thongke_LHS_time(int year)
        {
            LUUHS        lhs     = new LUUHS();
            SqlParameter endDate = new SqlParameter("@date", year);

            endDate.SqlDbType = SqlDbType.Int;
            return(lhs.Database.SqlQuery <Thongke_lhs_time_class>("exec dbo.ThongKe_LHS_ThoiGian @date", endDate).ToList());
        }
        public ActionResult DetailLHS(string MALHS)
        {
            LUUHS        lhs       = new LUUHS();
            F_Luuhocsinh f_lhs     = new F_Luuhocsinh();
            var          detaillhs = f_lhs.Detai_LHS_Ma(MALHS);

            ViewBag.Doituong = lhs.DoiTuongs.Where(x => x.MaDoiTuong != 0).ToList();
            return(View(detaillhs));
        }
Beispiel #3
0
 public bool ChangeImageLHS(string id, string image)
 {
     using (var db = new LUUHS())
     {
         var result = db.LuuHocSinhs.SingleOrDefault(b => b.MaLHS == id);
         if (result != null)
         {
             result.Image = image;
             db.SaveChanges();
         }
     }
     return(true);
 }
Beispiel #4
0
 public bool AddNewLHS(LuuHocSinh lhs)
 {
     using (LUUHS luuhs = new LUUHS())
     {
         try
         {
             luuhs.LuuHocSinhs.Add(lhs);
             luuhs.SaveChanges();
             return(true);
         }
         catch (Exception)
         {
             return(false);
         }
     }
 }
        /// <summary>
        /// Thêm mới lưu học sinh(trang view)
        /// </summary>
        /// <returns></returns>
        public ActionResult AddNewLHS()
        {
            LUUHS  lhs   = new LUUHS();
            var    count = lhs.LuuHocSinhs.Count();
            string malhs = "SV" + DateTime.UtcNow.Year;

            if (count < 100 && count > 10)
            {
                malhs += "0";
            }
            else if (count > 0 && count < 10)
            {
                malhs += "00";
            }
            else
            {
            }
            ViewBag.malhs = malhs + count;

            ViewBag.Doituong = lhs.DoiTuongs.Where(x => x.MaDoiTuong != 0).ToList();
            return(View());
        }