コード例 #1
0
        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("\"", "&quot;");
                    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());
            }
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
 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());
     }
 }
コード例 #4
0
 public static bool UpdateThoiDiemXem(int id, string maSinhVien)
 {
     using (var db = new UMS_HUSCEntities())
     {
         var tinNhan = db.TINNHANs.FirstOrDefault(t => t.MaTinNhan == id);
         if (tinNhan != null)
         {
             var maTaiKhoan = SinhVienDao.GetMaTaiKhoan(maSinhVien);
             var nguoiNhan  = db.NGUOINHANs.FirstOrDefault(n => n.MaNguoiNhan == maTaiKhoan && n.MaTinNhan == id);
             //var nguoiGui = db.NGUOIGUIs.FirstOrDefault(n => n.MaNguoiGui == maTaiKhoan && n.MaTinNhan == id);
             if (nguoiNhan != null && nguoiNhan.ThoiDiemXem == null)
             {
                 nguoiNhan.ThoiDiemXem = DateTime.Now;
                 db.SaveChanges();
             }
             return(nguoiNhan != null) /*|| (nguoiGui != null)*/;
         }
         return(false);
     }
 }