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()); }
public async Task <ActionResult <Nhom> > PostNhom(Nhom nhom) { _context.Nhoms.Add(nhom); await _context.SaveChangesAsync(); return(CreatedAtAction("GetNhom", new { id = nhom.Id }, nhom)); }
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")); }
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); } }
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(); }
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(); } } }
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(); } }
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); } }
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); } }
//============= 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); }
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; } }
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); }
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); } }
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")); }
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(); }
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); }
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 }); }
void loadNhom() { listNhom = Nhom.getListNhom(pathDataGroup); bindingSource_nhom.DataSource = listNhom; dataGridView_nhom.DataSource = bindingSource_nhom; }
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")); }
//============= 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); } }
//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(); }
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); } }
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)); }
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); } }
public QuanLiDanhBa() { InitializeComponent(); dgvNhom.AutoGenerateColumns = false; dgvDanhBa.AutoGenerateColumns = false; List <Nhom> listNhom = Nhom.getNhom(); bdsNhom.DataSource = listNhom; dgvNhom.DataSource = bdsNhom; }
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; } }
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; } } }
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; }
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; } }
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; } } }
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); }
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 } }
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()); } } }