Пример #1
0
        public async Task <IActionResult> PutNhom(long id, Nhom nhom)
        {
            if (id != nhom.Id)
            {
                return(BadRequest());
            }

            _context.Entry(nhom).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!NhomExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Пример #2
0
        public async Task <ActionResult <Nhom> > PostNhom(Nhom nhom)
        {
            _context.Nhoms.Add(nhom);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetNhom", new { id = nhom.Id }, nhom));
        }
Пример #3
0
        public ActionResult sua(string id, HttpPostedFileBase fileUpLoad, FormCollection c)
        {
            int t = int.Parse(id);

            Session["l"] = id;
            Nhom s = db.Nhoms.SingleOrDefault(n => n.maNhom == t);

            //ViewBag.MaLoai = new SelectList(db.Loais.ToList().OrderBy(n => n.tenloai), "maLoai", "tenloai");
            ViewBag.MaNhom = new SelectList(db.Nhoms.ToList().OrderBy(n => n.tenNhom), "maNhom", "tenNhom");
            //ViewBag.MaNCC = new SelectList(db.nhaCungCaps.ToList().OrderBy(n => n.tenNCC), "maNCC", "tenNCC");
            if (fileUpLoad == null)
            {
            }
            if (ModelState.IsValid)
            {
                s.tenNhom = c["txtTenNhom"];

                if (fileUpLoad != null)
                {
                    var fileName = Path.GetFileName(fileUpLoad.FileName);
                    var path     = Path.Combine(Server.MapPath("~/Content"), fileName);
                    fileUpLoad.SaveAs(path);
                    s.hinhanhdaidien = fileName;
                }
                UpdateModel(s);
                db.SubmitChanges();
            }
            return(RedirectToAction("TrangQuanLyNhom", "QuanLyNhom"));
        }
Пример #4
0
 public bool Them(Nhom nhom)
 {
     try
     {
         if (_db.Nhoms.Count() > 0)
         {
             nhom.MaNhom = _db.Nhoms.Max(item => item.MaNhom) + 1;
         }
         else
         {
             nhom.MaNhom = 1;
         }
         nhom.CreateDate = DateTime.Now;
         nhom.CreateBy   = CNguoiDung.MaND;
         _db.Nhoms.InsertOnSubmit(nhom);
         _db.SubmitChanges();
         return(true);
     }
     catch (Exception ex)
     {
         Refresh();
         System.Windows.Forms.MessageBox.Show(ex.Message, "Thông Báo", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
         return(false);
     }
 }
Пример #5
0
        private void btnXoa_Click_1(object sender, EventArgs e)
        {
            if (currentIDDeAn == -1)
            {
                MessageBox.Show("Vui long chon Sinh vien");
                return;
            }
            DeAn da = new DeAn();

            da.IDDeAn   = currentIDDeAn;
            da.TenDeAn  = txtTenDeAn.Text.Trim();
            da.NoiDung  = rtbNoiDung.Text.Trim();
            da.LoaiDeAn = cbLoaiDeAn.SelectedItem.ToString();
            Nhom nhom = cbNhom.SelectedItem as Nhom;

            da.IDNhom = nhom.IDNhom;
            GiaoVien gv = cbGiaoVien.SelectedItem as GiaoVien;

            da.IDGiaoVien = gv.IDGiaoVien;
            da.status     = 0;
            if (DeAnController.CapNhatDeAn(da) == false)
            {
                MessageBox.Show("Khong xoa De an duoc");
                return;
            }
            currentIDDeAn = -1;
            showDSDeAn();
        }
Пример #6
0
        private void BtnDongY_Click(object sender, EventArgs e)
        {
            String tenNhom = txtTenNhom.Text;

            if (tenNhom == null || tenNhom == "")
            {
                errorProvider.SetError(txtTenNhom, "Vui lòng nhập tên nhóm");
                txtTenNhom.Focus();
                return;
            }
            else
            {
                Nhom nhom = Nhom.TimKiem(tenNhom);
                if (nhom != null)
                {
                    MessageBox.Show("Tên nhóm đã tồn tại", "Thông báo", MessageBoxButtons.OK,
                                    MessageBoxIcon.Information);
                }
                else
                {
                    Nhom.Add(tenNhom);
                    //MessageBox.Show("Đã thêm nhóm thành công", "Thông báo", MessageBoxButtons.OK,
                    //MessageBoxIcon.Information);
                    ThongBaoNhom f = new ThongBaoNhom();
                    f.ShowDialog();
                    this.Close();
                }
            }
        }
Пример #7
0
        protected void btnDeleteGroup_Click(object sender, EventArgs e)
        {
            if (cboGroup.Items.Count == 0)
            {
                return;
            }

            DCVimaruDataContext dc = new DCVimaruDataContext();

            XmlDocument doc  = new XmlDocument();
            List <int>  list = new List <int>();

            int id = Convert.ToInt32(cboGroup.SelectedValue);

            list.Add(id);

            doc.LoadXml(MoodleGroup.DeleteGroups(list, (string)Session["token"]));
            doc.Save("D:\\Group_Delete_" + cboGroup.SelectedItem.Text + ".xml");

            if (doc.DocumentElement.Name == "RESPONSE")
            {
                Nhom nhom = dc.Nhoms.Single(t => t.ID_Nhom == id);
                dc.Nhoms.DeleteOnSubmit(nhom);
                dc.ExecuteCommand("UPDATE DangKy SET ID_Nhom = null WHERE ID_Nhom = {0}", id);
                dc.SubmitChanges();

                cboGroup.DataBind();
            }
        }
Пример #8
0
 private void btnSua_Click(object sender, EventArgs e)
 {
     if (CNguoiDung.CheckQuyen(_mnu, "Sua"))
     {
         if (_selectedindex != -1)
         {
             Nhom nhom = _cNhom.GetByMaNhom(int.Parse(dgvNhom["MaNhom", _selectedindex].Value.ToString()));
             nhom.TenNhom = txtTenNhom.Text.Trim();
             _cNhom.Sua(nhom);
             DataTable dt = ((DataView)gridView.DataSource).Table;
             foreach (DataRow item in dt.Rows)
             {
                 PhanQuyenNhom phanquyennhom = _cPhanQuyenNhom.GetByMaMenuMaNhom(int.Parse(item["MaMenu"].ToString()), nhom.MaNhom);
                 if (phanquyennhom.Xem != bool.Parse(item["Xem"].ToString()) || phanquyennhom.Them != bool.Parse(item["Them"].ToString()) ||
                     phanquyennhom.Sua != bool.Parse(item["Sua"].ToString()) || phanquyennhom.Xoa != bool.Parse(item["Xoa"].ToString()) ||
                     phanquyennhom.QuanLy != bool.Parse(item["QuanLy"].ToString()))
                 {
                     phanquyennhom.Xem    = bool.Parse(item["Xem"].ToString());
                     phanquyennhom.Them   = bool.Parse(item["Them"].ToString());
                     phanquyennhom.Sua    = bool.Parse(item["Sua"].ToString());
                     phanquyennhom.Xoa    = bool.Parse(item["Xoa"].ToString());
                     phanquyennhom.QuanLy = bool.Parse(item["QuanLy"].ToString());
                     _cPhanQuyenNhom.Sua(phanquyennhom);
                 }
             }
             Clear();
             MessageBox.Show("Thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     else
     {
         MessageBox.Show("Bạn không có quyền Thêm Sửa này", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Пример #9
0
 private void btnThem_Click(object sender, EventArgs e)
 {
     if (CNguoiDung.CheckQuyen(_mnu, "Them"))
     {
         if (txtTenNhom.Text.Trim() != "")
         {
             Nhom nhom = new Nhom();
             nhom.TenNhom = txtTenNhom.Text.Trim();
             ///tự động thêm quyền cho nhóm mới
             foreach (var item in _cMenu.GetDS())
             {
                 PhanQuyenNhom phanquyennhom = new PhanQuyenNhom();
                 phanquyennhom.MaMenu = item.MaMenu;
                 phanquyennhom.MaNhom = nhom.MaNhom;
                 nhom.PhanQuyenNhoms.Add(phanquyennhom);
             }
             _cNhom.Them(nhom);
             Clear();
             MessageBox.Show("Thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     else
     {
         MessageBox.Show("Bạn không có quyền Thêm Form này", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Пример #10
0
    //============= Xử lý Chức năng ========
    public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
    {
        var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;
        var Nguoi_dung           = Danh_sach_Nguoi_dung.FirstOrDefault(
            x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau);

        if (Nguoi_dung != null)
        {
            var DS_Nhom_San_pham = (XmlElement)Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
            var Danh_sach_Nhom_San_pham_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham, "Nhom_San_pham");
            var Danh_sach_San_pham_cua_Nguoi_dung      = Danh_sach_San_pham.FindAll(
                x => Danh_sach_Nhom_San_pham_cua_Nguoi_dung.Any(Nhom => Nhom.GetAttribute("Ma_so") == x.SelectSingleNode("Nhom_San_pham/@Ma_so").Value));
            var Doanh_thu = Danh_sach_Nhom_San_pham_cua_Nguoi_dung.Sum(x => long.Parse(x.GetAttribute("Doanh_thu")));

            // Thống tin Online
            Nguoi_dung_Dang_nhap                         = new XL_NGUOI_DUNG_DANG_NHAP();
            Nguoi_dung_Dang_nhap.Ho_ten                  = Nguoi_dung.GetAttribute("Ho_ten");
            Nguoi_dung_Dang_nhap.Ma_so                   = Nguoi_dung.GetAttribute("Ma_so");
            Nguoi_dung_Dang_nhap.Doanh_thu               = Doanh_thu;
            Nguoi_dung_Dang_nhap.Cua_hang                = Cua_hang;
            Nguoi_dung_Dang_nhap.Danh_sach_San_pham      = Danh_sach_San_pham_cua_Nguoi_dung;
            Nguoi_dung_Dang_nhap.Danh_sach_Nhom_San_pham = Danh_sach_Nhom_San_pham_cua_Nguoi_dung;
            Nguoi_dung_Dang_nhap.Danh_sach_San_pham_Xem  = Nguoi_dung_Dang_nhap.Danh_sach_San_pham;

            HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
        }

        return(Nguoi_dung_Dang_nhap);
    }
        public static bool TaoTaiKhoan(createUserViewModel vm)
        {
            if (KiemTraEmailTonTai(vm.Email))
            {
                return(false);
            }

            Entities entities = new Entities();
            TaiKhoan TaiKhoan = new TaiKhoan();

            TaiKhoan.Ten         = vm.HoTen;
            TaiKhoan.TenDangNhap = vm.Email;
            TaiKhoan.MatKhau     = SecurePasswordHasher.Hash(vm.MatKhau);

            foreach (int MaNhom in vm.MaNhom.OrEmptyIfNull())
            {
                Nhom nhom = entities.Nhoms.Where(p => p.id == MaNhom).First();
                TaiKhoan.Nhom.Add(nhom);
            }

            entities.TaiKhoan.Add(TaiKhoan);
            entities.SaveChanges();

            return(true);
        }
Пример #12
0
 private void txtSearch_KeyUp(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter)
     {
         string key     = txtSearch.Text;
         string tenNhom = (string)dgvNhom.CurrentCell.Value;
         //Nhom nhom = Nhom.getNhomByName(tenNhom);
         Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
         //List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
         List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
         List <DanhBa> rs   = new List <DanhBa>();
         for (int i = 0; i < list.Count; i++)
         {
             if (list.ElementAt(i).tenGoi.Equals(key) || list.ElementAt(i).email.Equals(key) || list.ElementAt(i).sdt.Equals(key))
             {
                 rs.Add(list.ElementAt(i));
             }
         }
         bdsDanhBa.DataSource = rs;
         dgvDanhBa.DataSource = bdsDanhBa;
     }
     if (txtSearch.Text.Equals(""))
     {
         string tenNhom = (string)dgvNhom.CurrentCell.Value;
         //Nhom nhom = Nhom.getNhomByName(tenNhom);
         Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
         //List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
         List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
         bdsDanhBa.DataSource = list;
         dgvDanhBa.DataSource = bdsDanhBa;
     }
 }
Пример #13
0
        public int Save(Nhom Group)
        {
            try
            {
                if (Group.MaNhom != 0)
                {
                    return(DbContext.NonRecord("updateNhom",
                                               new SqlParameter(PARAM_MA_NHOM, Group.MaNhom),
                                               new SqlParameter(PARAM_TEN, Group.Ten),
                                               new SqlParameter(PARAM_MO_TA, Group.MoTa),
                                               new SqlParameter(PARAM_ROLE_ID, Group.RoleId)
                                               ));
                }
                //else
                return(DbContext.NonRecord("insertNhom",
                                           new SqlParameter(PARAM_TEN, Group.Ten),
                                           new SqlParameter(PARAM_MO_TA, Group.MoTa),
                                           new SqlParameter(PARAM_ROLE_ID, Group.RoleId)
                                           ));
            }
            catch (Exception)
            {
            }

            return(-1);
        }
Пример #14
0
 private void btnXoa_Click(object sender, EventArgs e)
 {
     if (CNguoiDung.CheckQuyen(_mnu, "Xoa"))
     {
         if (MessageBox.Show("Bạn có chắc chắn xóa?", "Xác nhận xóa", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
         {
             if (_selectedindex != -1)
             {
                 Nhom nhom = _cNhom.GetByMaNhom(int.Parse(dgvNhom["MaNhom", _selectedindex].Value.ToString()));
                 ///xóa quan hệ 1 nhiều
                 _cPhanQuyenNhom.Xoa(nhom.PhanQuyenNhoms.ToList());
                 _cNhom.Xoa(nhom);
                 Clear();
                 MessageBox.Show("Thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
             }
             else
             {
                 MessageBox.Show("Lỗi, Vui lòng chọn Nhóm cần xóa", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
         }
     }
     else
     {
         MessageBox.Show("Bạn không có quyền Xóa Form này", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Пример #15
0
        public ActionResult Create(Nhom NewGroup)
        {
            if (IsNotLogin())
            {
                return(View(MUST_LOGIN_AREA));
            }

            if (!IsAdmin())
            {
                return(View(NOT_ALLOWED_AREA));
            }

            IEnumerable <Role> dbsRole = Db.Role.All;

            if (!ModelState.IsValid)
            {
                ViewBag.RoleId = new SelectList(dbsRole, "RoleId", "Name", NewGroup.RoleId);

                return(View(NewGroup));
            }

            if (Db.Group.IsExist(NewGroup.Ten))
            {
                ViewBag.FailMsg = "Nhóm này đã tồn tại trên hệ thống";
                ViewBag.RoleId  = new SelectList(dbsRole, "RoleId", "Name", NewGroup.RoleId);

                return(View(NewGroup));
            }

            Db.Group.Save(NewGroup);

            return(RedirectToAction("Index"));
        }
Пример #16
0
        public Dictionary <string, string> FBListGroupFromUID(List <string> Handle, string UID)
        {
            try
            {
                Dictionary <string, string> result = new Dictionary <string, string>();
                string html = http.Get("https://graph.facebook.com/v3.0/" + UID + "?fields=groups.limit(1000)&access_token=" + Handle[3]).ToString(); //lấy dạng json
                Clipboard.SetText(html);                                                                                                              //gửi vào clipboard để xem
                Nhom         nh        = JsonConvert.DeserializeObject <Nhom>(html);
                Nhom2        nh2       = nh.groups;
                List <Nhom3> listNhom3 = nh2.data.ToList();
                for (int i = 0; i < listNhom3.Count; i++)
                {
                    Nhom3 n3 = listNhom3[i];
                    result.Add(n3.id, n3.name);
                    //MessageBox.Show("Ten = " + n3.name);
                }

                return(result);
            }
            catch (Exception ex)
            {
                ex.Message.ToString();
                return(null);
            }
        }
        private void btnXoaSinhVien_Click_1(object sender, EventArgs e)
        {
            if (currentIDSinhVien == -1)
            {
                MessageBox.Show("Vui long chon Sinh vien");
                return;
            }
            SinhVien sv = new SinhVien();

            sv.IDSinhVien = currentIDSinhVien;
            sv.HoTen      = txtHoten.Text.Trim();
            sv.MSSV       = txtMssv.Text.Trim();
            sv.NgaySinh   = dtpNgaySinh.Value;
            sv.Email      = txtEmail.Text.Trim();
            sv.SDT        = txtSdt.Text.Trim();
            sv.GioiTinh   = cbGioitinh.SelectedItem.ToString();
            Nhom nhom = cbNhom.SelectedItem as Nhom;

            sv.IDNhom = nhom.IDNhom;
            sv.status = 0;
            if (SinhVienController.CapNhatSinhVien(sv) == false)
            {
                MessageBox.Show("Khong xoa duoc Sinh vien");
                return;
            }
            currentIDSinhVien = -1;
            showDSSinhVien();
        }
Пример #18
0
        public Nhom Find(int id)
        {
            try
            {
                DbDataReader dbReader = DbContext.RecordSets("findNhomById", new SqlParameter(PARAM_MA_NHOM, id));

                if (!dbReader.HasRows)
                {
                    return(new Nhom());
                }

                dbReader.Read();

                Nhom rGroup = new Nhom();
                rGroup.MaNhom = id;
                rGroup.Ten    = dbReader.GetString(dbReader.GetOrdinal(COL_TEN));
                rGroup.MoTa   = dbReader.GetString(dbReader.GetOrdinal(COL_MO_TA));
                rGroup.RoleId = dbReader.GetInt32(dbReader.GetOrdinal(COL_ROLE_ID));
                rGroup.Role   = new RoleRepository(DbFactory).Find(rGroup.RoleId);

                return(rGroup);
            }
            catch (Exception)
            {
            }

            return(new Nhom());
        }
        public ResponseInfo UpdateNhomTaiKhoan(Nhom nhom)
        {
            ResponseInfo response = new ResponseInfo();

            try
            {
                var kt = Convert.ToInt64(new GetPermission().GetQuyen("ACCOUNT_UPD")) & Convert.ToInt64(Common.Common.GetTongQuyen());
                if (kt != 0)
                {
                    response = new QuanLyTaiKhoanModel().UpadateNhomTaiKhoan(nhom);
                }
                else
                {
                    var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.BanKhongDuQuyen);
                    response.TypeMsgError = errorMsg.Type;
                    response.MsgError     = errorMsg.Msg;
                }
            }
            catch (Exception e)
            {
                response.Code = (int)ConstantsEnum.CodeResponse.ServerError;
                var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.ServerError);
                response.TypeMsgError    = errorMsg.Type;
                response.MsgError        = errorMsg.Msg;
                response.ThongTinBoSung1 = e.Message;
            }
            return(response);
        }
Пример #20
0
        public static object update(int id, updateUserViewModel ViewModel)
        {
            var entities = new Entities();
            var User     = entities
                           .TaiKhoan
                           .Where(u => u.id == id).First();

            User.Ten         = ViewModel.HoTen;
            User.TenDangNhap = ViewModel.Email;
            List <Nhom> nhoms = new List <Nhom>();

            foreach (int MaNhom in ViewModel.MaNhom.OrEmptyIfNull())
            {
                Nhom nhom = entities.Nhoms.Where(p => p.id == MaNhom).First();
                nhoms.Add(nhom);
            }

            User.Nhom = nhoms;
            entities.SaveChanges();
            return(new {
                Fullname = User.Ten,
                Email = User.TenDangNhap,
                Id = User.id,
                State = User.TrangThai
            });
        }
Пример #21
0
        void loadNhom()
        {
            listNhom = Nhom.getListNhom(pathDataGroup);

            bindingSource_nhom.DataSource = listNhom;
            dataGridView_nhom.DataSource  = bindingSource_nhom;
        }
Пример #22
0
        public ActionResult Delete(FormCollection form)
        {
            int  id   = Convert.ToInt32(form["id"]);
            Nhom nhom = data.Nhoms.SingleOrDefault(i => i.IDNhom == id);

            //Nếu nhóm tồn tại
            if (nhom != null)
            {
                //Xóa nhóm
                data.Nhoms.DeleteOnSubmit(nhom);
                try
                {
                    data.SubmitChanges();
                }
                catch (Exception ex)
                {
                    int countLoai = data.Loais.Count(i => i.IDNhom == id);
                    ViewBag.IsError = true;
                    if (ex.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint"))
                    {
                        ViewBag.ErrorBody = string.Format("Không thể xóa nhóm [{0}] do có {1} loại thức ăn trong nhóm này.", nhom.TenNhom, countLoai);
                    }
                    else
                    {
                        ViewBag.ErrorBody = ex.ToString();
                    }
                    List <Nhom> all = data.Nhoms.ToList();
                    return(View("Index", all));
                }
            }
            //Xóa thành công hoặc nhóm k tồn tại thì trở về Index
            return(RedirectToAction("Index", "AdminNhom"));
        }
Пример #23
0
    //============= Xử lý Chức năng ========
    public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
    {
        var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;

        var Nguoi_dung = Danh_sach_Nguoi_dung.FirstOrDefault(
            x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau);

        if (Nguoi_dung != null)
        {
            var DS_Nhom_Lap_top = (XmlElement)Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
            var Danh_sach_Nhom_Lap_top_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_Lap_top, "Nhom_Lap_top");
            var Danh_sach_Lap_top_cua_Nguoi_dung      = Danh_sach_Lap_top.FindAll(
                x => Danh_sach_Nhom_Lap_top_cua_Nguoi_dung.Any(Nhom => Nhom.GetAttribute("Ma_so") == x.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value));
            var Doanh_thu = Danh_sach_Nhom_Lap_top_cua_Nguoi_dung.Sum(Nhom_Lap_top => long.Parse(Nhom_Lap_top.GetAttribute("Doanh_thu")));
            // Thống tin Online
            Nguoi_dung_Dang_nhap                                = new XL_NGUOI_DUNG_DANG_NHAP();
            Nguoi_dung_Dang_nhap.Doanh_thu                      = Doanh_thu;
            Nguoi_dung_Dang_nhap.Thong_bao                      = $"Doanhthu: { Nguoi_dung_Dang_nhap.Doanh_thu}" + "$<br />";
            Nguoi_dung_Dang_nhap.Danh_sach_Lap_top              = Danh_sach_Lap_top_cua_Nguoi_dung;
            Nguoi_dung_Dang_nhap.Danh_sach_Nhom_Lap_top         = Danh_sach_Nhom_Lap_top_cua_Nguoi_dung;
            Nguoi_dung_Dang_nhap.Danh_sach_Lap_top_Xem          = Nguoi_dung_Dang_nhap.Danh_sach_Lap_top;
            HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
        }

        return(Nguoi_dung_Dang_nhap);
    }
        private void btnThemSinhVien_Click(object sender, EventArgs e)
        {
            errorThemSinhVien.Clear();
            if (txtHoten.Text.Trim().Length <= 0)
            {
                errorThemSinhVien.SetError(txtHoten, "Nhập Họ và Tên");
                return;
            }
            if (txtMssv.Text.Trim().Length <= 0)
            {
                errorThemSinhVien.SetError(txtMssv, "Thêm MSSV");
                return;
            }
            if (DateTime.Now.Year - dtpNgaySinh.Value.Year < 10)
            {
                errorThemSinhVien.SetError(dtpNgaySinh, "Chọn ngày sinh phù hợp");
                return;
            }
            if (txtEmail.Text.Trim().Length <= 0)
            {
                errorThemSinhVien.SetError(txtEmail, "Thêm email");
                return;
            }
            if (txtSdt.Text.Trim().Length <= 0)
            {
                errorThemSinhVien.SetError(txtSdt, "Thêm SĐT");
                return;
            }
            if (cbGioitinh.SelectedItem == null)
            {
                errorThemSinhVien.SetError(cbGioitinh, "Chọn giới tính");
                return;
            }
            if (cbNhom.SelectedItem as Nhom == null)
            {
                errorThemSinhVien.SetError(cbNhom, "Chọn nhóm");
                return;
            }

            SinhVien sv = new SinhVien();

            sv.HoTen    = txtHoten.Text.Trim();
            sv.MSSV     = txtMssv.Text.Trim();
            sv.NgaySinh = dtpNgaySinh.Value;
            sv.Email    = txtEmail.Text.Trim();
            sv.SDT      = txtSdt.Text.Trim();
            sv.GioiTinh = cbGioitinh.SelectedItem.ToString();
            sv.status   = 1;
            Nhom nhom = cbNhom.SelectedItem as Nhom;

            sv.IDNhom = nhom.IDNhom;
            if (SinhVienController.ThemSinhVien(sv) == false)
            {
                MessageBox.Show("Khong them nhom duoc");
                return;
            }
            currentIDSinhVien = -1;
            showDSSinhVien();
        }
 public static bool UpdateNhom(Nhom nhom)
 {
     using (var _context = new ManagementTopicStudentEntities())
     {
         _context.Nhoms.AddOrUpdate(nhom);
         _context.SaveChanges();
         return(true);
     }
 }
Пример #26
0
        //thêm liên lạc
        private void Btnthemlienlac_Click(object sender, EventArgs e)
        {
            dtgvnhom.CurrentRow.Selected = true;
            string tennhom = dtgvnhom.SelectedCells[0].Value.ToString();
            string manhom  = Nhom.getMaTuTenNhom(tennhom, path);

            var addlienlac = new Addlienlac(this, manhom);

            addlienlac.Show();
        }
Пример #27
0
        private void toolStripButton_xoaLienLac_Click(object sender, EventArgs e)
        {
            LienLac lienLac = LienLac.ParseLienLac(bindingSource_lienLac.Current as DataRowView);

            if (MessageBox.Show("Bạn có muốn xóa liên lạc \"" + lienLac.TenLienLac + "\" không?", "Xóa liên lạc", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                bindingSource_lienLac.RemoveCurrent();
                Nhom.xoaLienHeDatabase(lienLac.MaLienLac);
            }
        }
Пример #28
0
        public bool delete(Nhom nhom)
        {
            string query = "Delete from Nhom" +
                           "Where GID=@GID";

            SqlParameter[] sqlParameters = new SqlParameter[1];
            sqlParameters[0]       = new SqlParameter("@GID", SqlDbType.Int);
            sqlParameters[0].Value = nhom.GID;
            return(executeDeleteQuery(query, sqlParameters));
        }
Пример #29
0
        private void toolStripButton_xoaNhom_Click(object sender, EventArgs e)
        {
            Nhom nhom = Nhom.ParseNhom(bindingSource_nhom.Current as DataRowView);

            if (MessageBox.Show("Bạn có muốn xóa nhóm \"" + nhom.TenNhom + "\" không?", "Xóa nhóm", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                bindingSource_nhom.RemoveCurrent();
                Nhom.xoaNhomDatabase(nhom.MaNhom);
            }
        }
Пример #30
0
        public QuanLiDanhBa()
        {
            InitializeComponent();
            dgvNhom.AutoGenerateColumns   = false;
            dgvDanhBa.AutoGenerateColumns = false;
            List <Nhom> listNhom = Nhom.getNhom();

            bdsNhom.DataSource = listNhom;
            dgvNhom.DataSource = bdsNhom;
        }
Пример #31
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var id = Request["ID"];
        var idNull = string.IsNullOrEmpty(id);
        var logged = Security.IsAuthenticated();
        if(!logged)
        {
            Response.Redirect(string.Format("~/login/?return={0}", Server.UrlEncode(Request.RawUrl)));
        }
        using (var con = DAL.con())
        {
            var item = NhomDal.SelectById(con, Convert.ToInt32(id), Security.Username);
            Item = item;
            var currentMember = NhomThanhVienDal.SelectByNhomIdUsername(con, item.Id.ToString(), Security.Username);
            if (currentMember.ModLoai != 5 || !currentMember.Admin)
            {
                Admin.Visible = false;
                AdminUnAuthorize.Visible = true;
                AdminUnAuthorize.Item = item;
                return;
            }

            Admin.Visible = true;
            AdminUnAuthorize.Visible = false;

            Admin.Item = item;
            Admin.Obj = ObjDal.SelectByRowId(con, item.RowId);
            Admin.CurrentMember = currentMember;
            var blogs = BlogDal.SelectTopForNhomByProwId(con, 100, item.RowId, 3, Security.Username, false.ToString());
            //blogs.ToList().ForEach(s => s.Nhom = item);

            Admin.Blogs = blogs;

            var nhomThanhVienPendding = NhomThanhVienDal.SelectByNhomId(con, id, false.ToString());
            Admin.NhomThanhVienPendding = nhomThanhVienPendding;

            var nhomThanhViens = NhomThanhVienDal.SelectByNhomId(con, id, true.ToString());
            Admin.NhomThanhVien = nhomThanhViens.Where(p => p.Username != Item.NguoiTao).ToList();

            //var topics = BlogDal.SelectTopForNhomByProwId(con, 20, item.RowId, 4, Security.Username, true.ToString());
            //topics.ToList().ForEach(s => s.Nhom = item);

            //NhomView.Blogs = blogs;
            //NhomView.Topics = topics;

        }
    }
Пример #32
0
 protected void Page_Load(object sender, EventArgs e)
 {
     var Id = Request["PID_ID"];
     var idNull = string.IsNullOrEmpty(Id);
     Item = new Nhom();
     using (var con = DAL.con())
     {
         if (!idNull)
         {
             Item = NhomDal.SelectById(con, Convert.ToInt32(Id), Security.Username);
             var pagerBlog = BlogDal.PagerByPRowIdLoaiFull(con, string.Empty, false, null, Item.RowId.ToString(),
                                                   Security.Username, 4, true.ToString());
             ListBlogForNhomFull1.Pager = pagerBlog;
             ListBlogForNhomFull1.Item = Item;
         }
     }
 }
Пример #33
0
 protected void Page_Load(object sender, EventArgs e)
 {
     var id = Request["ID"];
     var idNull = string.IsNullOrEmpty(id);
     var item = new Nhom()
                    {
                        RowId = Guid.NewGuid()
                    };
     using (var con = DAL.con())
     {
         if (!idNull)
         {
             item = NhomDal.SelectById(Convert.ToInt32(id));
         }
     }
     Add.Item = item;
 }
Пример #34
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var id = Request["ID"];
        var idNull = string.IsNullOrEmpty(id);
        using(var con =DAL.con())
        {
            var item = NhomDal.SelectById(con, Convert.ToInt32(id) , Security.Username);
            Item = item;
            NhomView.Item = item;

            var blogs = BlogDal.SelectTopForNhomByProwId(con, 20, item.RowId,  3, Security.Username, true.ToString());
            //blogs.ToList().ForEach(s => s.Nhom = item);

            var topics = BlogDal.SelectTopForNhomByProwId(con, 20, item.RowId, 4, Security.Username, true.ToString());
            //topics.ToList().ForEach(s => s.Nhom = item);

            NhomView.Blogs = blogs;
            NhomView.Topics = topics;

        }
    }
Пример #35
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var Id = Request["ID"];
        var idNull = string.IsNullOrEmpty(Id);
        Item = new Nhom();
        using (var con = DAL.con())
        {
            if (!idNull)
            {
                var blog = BlogDal.SelectById(con, Convert.ToInt64(Id), Security.Username);

                Item = NhomDal.SelectByRowId(con, blog.PID_ID, Security.Username);

                //blog.Anhs = AnhDal.SelectByPId(con, blog.RowId.ToString(), 20);
                //blog.Nhom = Item;

                View.Pager = BinhLuanDal.PagerByPRowId(con, "", true, blog.RowId.ToString(), 20);
                View.Blog = blog;
                View.Item = Item;
            }
        }
    }
Пример #36
0
        protected override void Render(HtmlTextWriter writer)
        {
            StringBuilder sb = new StringBuilder();
            ClientScriptManager cs = this.Page.ClientScript;
            #region Tham số
            string _ID = Request["ID"];
            string _Ten = Request["Ten"];
            string _DM_ID = Request["DM_ID"];
            string _ThuTu = Request["ThuTu"];
            string _Active = Request["Active"];
            string _Hot = Request["Hot"];
            string _Hot1 = Request["Hot1"];
            string _Hot2 = Request["Hot2"];
            string _Hot3 = Request["Hot3"];
            Nhom ItemSave;
            List<jgridRow> ListRow = new List<jgridRow>();
            #endregion

            switch (subAct)
            {
                case "get":
                    #region lấy dữ liệu cho grid
                    if (string.IsNullOrEmpty(jgrsidx)) jgrsidx = "BAO_ID";
                    if (string.IsNullOrEmpty(jgrsord)) jgrsord = "asc";

                    List<Nhom> List = NhomDal.SelectAll();
                    ListRow = new List<jgridRow>();
                    foreach (Nhom dm in List)
                    {
                        ListRow.Add(new jgridRow(dm.ID.ToString(), new string[] {
                              dm.ID.ToString()
                            , dm._DanhMuc.Ten
                            , dm.Ten
                            , dm.ThuTu.ToString()
                            , dm.Active.ToString()
                            , dm.Hot.ToString()
                            , dm.Hot1.ToString()
                            , dm.Hot2.ToString()
                            , dm.Hot3.ToString()
                        }));
                    }
                    jgrid grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, List.Count.ToString(), List.Count.ToString(), ListRow);
                    sb.Append(JavaScriptConvert.SerializeObject(grid));
                    break;
                    #endregion
                case "del":
                    #region xóa
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        NhomDal.DeleteById(Convert.ToInt32(_ID));
                    }
                    break;
                    #endregion
                case "edit":
                    #region chỉnh sửa
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        sb.Append("(" + JavaScriptConvert.SerializeObject(NhomDal.SelectById(Convert.ToInt32(_ID))) + ")");
                    }
                    break;
                    #endregion
                case "save":
                    #region lưu
                    ItemSave = new Nhom();
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        ItemSave = NhomDal.SelectById(Convert.ToInt32(_ID));
                    }
                    else
                    {
                        ItemSave = new Nhom();
                    }
                    ItemSave.Ten = _Ten;
                    ItemSave.ThuTu = Convert.ToInt32(_ThuTu);
                    ItemSave.Active = Convert.ToBoolean(_Active);
                    ItemSave.Hot = Convert.ToBoolean(_Hot);
                    ItemSave.Hot1 = Convert.ToBoolean(_Hot1);
                    ItemSave.Hot2 = Convert.ToBoolean(_Hot2);
                    ItemSave.Hot3 = Convert.ToBoolean(_Hot3);
                    if (!string.IsNullOrEmpty(_DM_ID))
                    {
                        ItemSave.DM_ID = Convert.ToInt32(_DM_ID);
                    }
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        ItemSave = NhomDal.Update(ItemSave);
                    }
                    else
                    {
                        ItemSave = NhomDal.Insert(ItemSave);
                    }
                    sb.Append("1");
                    break;
                    #endregion
                case "getautoComplete":
                    #region Lấy danh sách danh mục
                    sb.Append(JavaScriptConvert.SerializeObject(NhomDal.SelectAll()));
                    break;
                    #endregion
                case "getSubTin":
                    #region getSubTin: Lấy tin theo topic
                    NhomTinCollection List1 = NhomTinDal.SelectByNhomId(_ID);
                    foreach (NhomTin dm in List1)
                    {
                        ListRow.Add(new jgridRow(dm.ID.ToString(), new string[] {
                             string.Format("{0}",dm.ID)
                            , string.Format("<img src=\"http://tintuc.me/lib/up/{0}\" />", linh.common.Lib.imgSize(dm._Tin.Anh,"100x100"))
                            , dm._Tin.Ten
                            , dm._Tin.MoTa
                            , dm._Tin.Url
                            , dm._Tin.NgayTao.ToString("hh:mm - dd/MM/yyyy")
                        }));
                    }
                    grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, List1.Count.ToString(), List1.Count.ToString(), ListRow);
                    sb.Append(JavaScriptConvert.SerializeObject(grid));
                    break;
                    #endregion
                case "addSubTin":
                    #region addSubTin: Thêm tin vào topic
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        NhomTinDal.Insert(new NhomTin(null
                            , Convert.ToInt32(_ID)
                            , Convert.ToInt32(Request["N_ID"])
                            ));
                    }
                    break;
                    #endregion
                case "delSubTin":
                    #region delSubTin:Xóa bỏ tin
                    if (!string.IsNullOrEmpty(_ID))
                    {
                        NhomTinDal.DeleteTinListByNid(_ID, Request["IDs"]);
                    }
                    break;
                    #endregion
                case "scpt":
                    #region Nạp js
                    sb.AppendFormat(@"{0}"
                        , cs.GetWebResourceUrl(typeof(Class1), "plugin.rss.nhom.JScript1.js"));
                    break;
                    #endregion
                default:
                    #region nạp
                    FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
                    sb.Append(@"
            <div class=""mdl-head"">
            <span class=""mdl-head-searchPnl ui-state-default ui-corner-all"">
            <a href=""javascript:;"" class=""mdl-head-clearSearch""></a>
            <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-nhomMdl"" />
            </span>
            <a class=""mdl-head-btn mdl-head-add"" id=""nhomMdl-addBtn"" href=""javascript:nhomFn.add();"">Thêm</a>
            <a class=""mdl-head-btn mdl-head-edit"" id=""nhomMdl-editBtn"" href=""javascript:nhomFn.edit();"">Sửa</a>
            <a class=""mdl-head-btn mdl-head-del"" id=""nhomMdl-delBtn"" href=""javascript:nhomFn.del();"">Xóa</a>
            </div>
            <table id=""nhomMdl-List"" class=""mdl-list""></table>
            <div id=""nhomMdl-Pager""></div>

            <div class=""sub-mdl"">
            <ul>
            <li><a id=""nhomMdl-subTinMdl-Btn"" href=""#nhomMdl-subTinMdl-Box"">Tin</a></li>
            </ul>
            <div>
            <div class=""mdl-submdl-panel"" id=""nhomMdl-subTinMdl-Box"">
            <div class=""mdl-head"">
            <span class=""mdl-head-searchPnl ui-state-default ui-corner-all"">
            <a href=""javascript:;"" class=""mdl-head-clearSearch""></a>
            <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-subTinMdl-nhomMdl"" />
            </span>
            <a class=""mdl-head-btn mdl-head-del"" id=""nhomMdl-subTinMdl-delBtn"" href=""javascript:nhomFn.delSubTin();"">Xóa</a>
            <span class=""mdl-head-filterPnl ui-state-default ui-corner-all"">
                <a href=""javascript:;"" class=""mdl-head-clearSearch""></a>
                <input type=""text"" _value="""" class=""mdl-head-filter mdl-head-nhomMdlSearchTin""/>
            </span>
            <a class=""mdl-head-btn mdl-head-del"" id=""nhomMdl-subTinMdl-addBtn"" _id="""" href=""javascript:;"">Thêm</a>
            </div>
            <table id=""nhomMdl-subTinMdl-List"" class=""mdl-list""></table>
            <div  id=""nhomMdl-subTinMdl-Pager""></div>
            </div>
            </div>
            </div>
            ");
                    sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
                        , cs.GetWebResourceUrl(typeof(Class1), "plugin.rss.nhom.JScript1.js")
                        , "{nhomFn.loadgrid();}");
                    sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn));
                    break;
                    #endregion
            }
            writer.Write(sb.ToString());
            base.Render(writer);
        }
Пример #37
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var pooledClientManager = new PooledRedisClientManager("localhost");
        var client = pooledClientManager.GetClient();
        var Ten = Request["Ten"];
        var PID_ID = Request["PID_ID"];
        var Loai = Request["Loai"];
        var Id = Request["Id"];
        var cUrl = Request["cUrl"];
        var rowId = Request["RowId"];
        var noiDung = Request["NoiDung"];
        var approved = Request["approved"];
        var logged = Security.IsAuthenticated();
        var idNull = string.IsNullOrEmpty(Id) || Id == "0";
        var blogRedis = new BlogRedis(client);
        var memberRedis = new MemberRedis(client);
        var nhomRedis = new NhomRedis(client);
        var xeRedis = new XeRedis(client);
        switch (subAct)
        {
            case "save":
                #region save blog
                if (logged && !string.IsNullOrEmpty(PID_ID) && !string.IsNullOrEmpty(Loai))
                {
                    var item = idNull ? new Blog() : BlogDal.SelectById(Convert.ToInt64(Id));
                    var member = new Member();
                    var xe = new Xe();
                    var nhom = new Nhom();
                    var nguoiTao = new Member();
                    item.NoiDung = noiDung;
                    item.Ten = Ten;
                    if (!string.IsNullOrEmpty(Loai))
                    {
                        item.Loai = Convert.ToInt32(Loai);
                    }
                    if (!string.IsNullOrEmpty(PID_ID))
                    {
                        item.PID_ID = new Guid(PID_ID);
                    }
                    if (!string.IsNullOrEmpty(rowId))
                    {
                        item.RowId = new Guid(rowId);
                    }

                    item.MoTa = Lib.Rutgon(Lib.NoHtml(item.NoiDung), 400);
                    var anhs = AnhDal.SelectByPId(DAL.con(), item.RowId.ToString(), 20).OrderByDescending(x => x.AnhBia).ToList();

                    if (anhs.Count > 0)
                    {
                        var sb = new StringBuilder();
                        foreach (var anhItem in anhs)
                        {
                            sb.AppendFormat(@"<a href=""{1}""><img alt=""{0}"" src=""/lib/up/car/{0}?w=75"" /></a>" , anhItem.FileAnh, item.Url);
                            item.AnhList.Add(anhItem.Id);
                        }
                        item.AnhStr = sb.ToString();

                    }
                    switch (item.Loai)
                    {
                        case 1:
                            member = memberRedis.GetByRowId(item.PID_ID);
                            break;
                        case 2:
                            xe = xeRedis.GetByRowId(item.PID_ID);
                            break;
                        case 3:
                        case 4:
                        case 5:
                            //item.Nhom = NhomDal.SelectByRowId(DAL.con(), item.PID_ID, Security.Username);
                            nhom = nhomRedis.GetByRowId(item.PID_ID);
                            break;
                    }
                    if (idNull)
                    {
                        item.NguoiTao = Security.Username;
                        item.NgayTao = DateTime.Now;
                        var insert = BlogDal.Insert(item);
                        item.Id = insert.Id;
                        item.NguoiThich.Insert(0, item.NguoiTao);
                        nguoiTao = memberRedis.GetByUsername(item.NguoiTao);
                        switch (item.Loai)
                        {
                            case 1:
                                if(member!= null)
                                {
                                    member.TotalBlog += 1;
                                    member.BlogIds.Insert(0, item.Id);
                                    memberRedis.Save(member);
                                    MemberDal.Update(member);
                                }
                                break;
                            case 2:
                                if (xe != null)
                                {
                                    xe.BlogIds.Insert(0, item.Id);
                                    xe.TotalBlog += 1;
                                    xeRedis.Save(xe);
                                    XeDal.Update(xe);
                                }
                                CacheHelper.Remove(string.Format(XeDal.CacheItemKey,item.Id));
                                systemMessageDal.Insert(new systemMessage()
                                {
                                    NoiDung = string.Format("<strong>{0}</strong> viết bài mới", nguoiTao.Ten)
                                    ,
                                    HeThong = false
                                    ,
                                    Id = Guid.NewGuid()
                                    ,
                                    PRowId = item.PID_ID
                                    ,
                                    NgayTao = DateTime.Now
                                    ,
                                    Active = true
                                    ,
                                    Loai = 1
                                    ,
                                    Url = string.Format("{0}", item.Url)
                                    ,
                                    Ten = string.Empty
                                    ,
                                    ThanhVienMoi = false
                                    ,
                                    Username = Security.Username
                                    ,
                                    ThuTu = 0
                                });
                                break;
                            case 3:
                            case 4:
                            case 5:
                                nhom.TotalBlog += 1;
                                if(item.Loai==3)
                                {
                                    nhom.BlogIds.Insert(0, item.Id);
                                }
                                else
                                {
                                    nhom.ForumBlogIds.Insert(0, item.Id);
                                }
                                nhomRedis.Save(nhom);
                                if (nhom.NhomMo)
                                {
                                    item.Publish = true;
                                }
                                systemMessageDal.Insert(new systemMessage()
                                {
                                    NoiDung = string.Format("<strong>{0}</strong> viết bài mới", nguoiTao.Ten)
                                    ,
                                    HeThong = false
                                    ,
                                    Id = Guid.NewGuid()
                                    ,
                                    PRowId = item.PID_ID
                                    ,
                                    NgayTao = DateTime.Now
                                    ,
                                    Active = true
                                    ,
                                    Loai = 1
                                    ,
                                    Url = string.Format("{0}", item.Url)
                                    ,
                                    Ten = string.Empty
                                    ,
                                    ThanhVienMoi = false
                                    ,
                                    Username = Security.Username
                                    ,
                                    ThuTu = 0
                                });
                                NhomDal.Update(nhom);
                                BlogDal.Update(item);
                                break;
                        }
                        ObjMemberDal.Insert(new ObjMember()
                        {
                            PRowId = item.RowId
                            ,
                            Username = Security.Username
                            ,
                            Owner = true
                            ,
                            NgayTao = DateTime.Now
                            ,
                            RowId = Guid.NewGuid()
                        });
                        var obj = ObjDal.Insert(new Obj()
                        {
                            Id = Guid.NewGuid()
                            ,
                            Kieu = typeof(Blog).FullName
                            ,
                            NgayTao = DateTime.Now
                            ,
                            RowId = item.RowId
                            ,
                            Url = string.Format("{0}", item.Url)
                            ,
                            Username = Security.Username
                        });

                    }
                    else
                    {
                        nguoiTao = memberRedis.GetByUsername(item.NguoiTao);
                        BlogDal.Update(item);

                    }
                    switch (item.Loai)
                    {
                        case 1:
                            if (member != null)
                            {
                                item.Url = string.Format("{0}/blogs/{1}/", member.Url, item.Id);
                                item.UrlEdit = string.Format("{0}/blogs/edit/{1}/", member.Url, item.Id);
                            }
                            break;
                        case 2:
                            if (xe != null)
                            {
                                item.Url = string.Format("{0}blogs/{1}/", xe.XeUrl, item.Id);
                                item.UrlEdit = string.Format("{0}blogs/edit/{1}/", xe.XeUrl, item.Id);
                            }
                            break;
                        case 3:
                            if (nhom != null)
                            {
                                item.Url = string.Format("{0}blogs/{1}/", nhom.Url, item.Id);
                                item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
                            }
                            break;
                        case 4:
                            if (nhom != null)
                            {
                                item.Url = string.Format("{0}forum/{1}/", nhom.Url, item.Id);
                                item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
                            }
                            break;
                        case 5:
                            if (nhom != null)
                            {
                                item.Url = string.Format("{0}qa/{1}/", nhom.Url, item.Id);
                                item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
                            }
                            break;
                    }
                    blogRedis.Save(item);
                    SearchManager.Add(item.Ten, string.Format("{0} {1}", item.Ten, item.NoiDung), string.Empty, item.RowId.ToString(), item.Url, typeof(Blog).Name);
                    rendertext(item.Url);
                }
                rendertext("0");
                break;
                #endregion
            case "remove":
                #region remove blog
                if(!string.IsNullOrEmpty(Id) && logged)
                {
                    var item = BlogDal.SelectById(Convert.ToInt64(Id));
                    if(item.NguoiTao==Security.Username)
                    {
                        SearchManager.Remove(item.RowId);
                        ObjDal.DeleteByRowId(item.RowId);
                        ObjMemberDal.DeleteByPRowId(item.RowId.ToString());
                        ThichDal.DeleteByPId(item.RowId);
                        CacheHelper.Remove(string.Format(BlogDal.CacheItemKey, item.Id));
                        BlogDal.DeleteById(item.Id);
                        blogRedis.Remove(item.Id);
                        rendertext("1");
                    }
                }
                break;
                #endregion
            case "nhomDuyetBlog":
                #region duyet blog of Nhom
                if (!string.IsNullOrEmpty(Id) && logged && !string.IsNullOrEmpty(approved))
                {
                    var Approved = approved == "1";

                    var item = blogRedis.GetById(Convert.ToInt64(Id));
                    if(Approved)
                    {
                        item.Publish = true;
                        BlogDal.Update(item);
                        blogRedis.Save(item);
                    }
                    else
                    {
                        blogRedis.Save(item);
                        BlogDal.DeleteById(item.Id);
                    }

                }
                break;
                #endregion
        }
    }
Пример #38
0
    public void InitBlog(SqlConnection con, IRedisClient redis)
    {
        const string itemKey = "urn:blog:{0}";
        const string itemList = "urn:blog:list:{0}";

        var blogRedis = new BlogRedis(redis);
        var memberRedis = new MemberRedis(redis);
        var nhomRedis = new NhomRedis(redis);
        var xeRedis = new XeRedis(redis);
        var member = new Member();
        var xe = new Xe();
        var nhom = new Nhom();
        var nguoiTao = new Member();

        //STEP:1
        //var blog = BlogDal.SelectAll().FirstOrDefault();
        //redis.Set(string.Format(itemKey,blog.Id), blog);

        //STEP:2
        var list = BlogDal.SelectAll();

        var all = redis.Lists[string.Format(itemList, "all")];
        var approved = redis.Lists[string.Format(itemList, "approved")];
        var unApproved = redis.Lists[string.Format(itemList, "unApproved")];
        var topNhatKy = redis.Lists[string.Format(itemList, "blog")];
        var topHanhTrinh = redis.Lists[string.Format(itemList, "hanhTrinh")];
        var topNhomBlog = redis.Lists[string.Format(itemList, "nhomBlog")];
        var topNhomForum = redis.Lists[string.Format(itemList, "nhomForum")];
        foreach (var item in list)
        {
            var key = string.Format(itemKey, item.Id);
            var thich = ThichDal.SelectByPidLoai(item.RowId, 3);
            foreach (var thich1 in thich)
            {
                item.NguoiThich.Insert(0, thich1.Username);
            }
            var anhs = AnhDal.SelectByPId(DAL.con(), item.RowId.ToString(), 100);
            foreach (var anh in anhs)
            {
                item.AnhList.Insert(0, anh.Id);
            }

            var binhLuanList = BinhLuanDal.PagerByPRowId(con, "a", false, item.RowId.ToString(), 1000).List;
            foreach (var binhLuan in binhLuanList)
            {
                item.BinhLuanIds.Insert(0, binhLuan.Id);
            }

            switch (item.Loai)
            {
                case 1:
                    member = memberRedis.GetByRowId(item.PID_ID);
                    topHanhTrinh.Push(item.Id.ToString(CultureInfo.InvariantCulture));
                    if (member != null)
                    {
                        item.Url = string.Format("{0}/blogs/{1}/", member.Url, item.Id);
                        item.UrlEdit = string.Format("{0}/blogs/edit/{1}/", member.Url, item.Id);
                    }
                    break;
                case 2:
                    xe = xeRedis.GetByRowId(item.PID_ID);
                    if (xe != null)
                    {
                        item.Url = string.Format("{0}blogs/{1}/", xe.XeUrl, item.Id);
                        item.UrlEdit = string.Format("{0}blogs/edit/{1}/", xe.XeUrl, item.Id);
                    }
                    topNhatKy.Push(item.Id.ToString());
                    break;
                case 3:
                    nhom = nhomRedis.GetByRowId(item.PID_ID);
                    if (nhom != null)
                    {
                        item.Url = string.Format("{0}blogs/{1}/", nhom.Url, item.Id);
                        item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
                    }
                    topNhomBlog.Push(item.Id.ToString());
                    break;
                case 4:
                    nhom = nhomRedis.GetByRowId(item.PID_ID);
                    if (nhom != null)
                    {
                        item.Url = string.Format("{0}forum/{1}/", nhom.Url, item.Id);
                        item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
                    }
                    topNhomForum.Push(item.Id.ToString());
                    break;
            }
            redis.Set(key, item);
            redis.Set(string.Format(itemKey, item.RowId), item.Id);
            all.Push(item.Id.ToString());
            if (item.Publish)
            {
                approved.Push(item.Id.ToString());
            }
            else
            {
                unApproved.Push(item.Id.ToString());
            }

        }
    }