public async Task <IActionResult> Edit(int id, [Bind("ID,Ma,SoHieu,HoTen,TenGoiKhac,GioiTinh,NgaySinh,DanTocID,TonGiaoID,DonViID,TrangThai,DienThoai,Email,CMTND,NgayCapCMT,NoiCapCMT,NoiSinhID,QueQuanID,HKTT,NoiO,TDPhoThongID,HochamID,HinhAnh,NgheNghiepID,CoquanTuyenDung,NgayTuyen,NgayVeCQ,HinhThucThiTuyenID,KieuCanBo,NgayHetHanHD,CongViecDuocGiao,SoTruongCongTac,NgayVaoDang,NgayChinhThuc,NgayNhapNgu,NgayXuatNgu,QuanHamCaoNhatID,HangThuongBinhID,GiaDinhCSID,SucKhoeID,ChieuCao,CanNang,NhomMauID,SoBHXH,NoiCapSoBHXH,SoBHYT,LichSuBanThan,GhiChu,NhanXetDanhGia")] CanBo canBo, IFormFile ImageFile) { if (id != canBo.ID) { return(NotFound()); } //await TryUpdateModelAsync(canBo); if (ModelState.IsValid) { try { if (ImageFile != null) { string day = DateTime.Now.ToString(); var filename = ContentDispositionHeaderValue.Parse(ImageFile.ContentDisposition).FileName.Trim('"'); var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "images", ImageFile.FileName); using (System.IO.Stream stream = new FileStream(path, FileMode.Create)) { await ImageFile.CopyToAsync(stream); } canBo.HinhAnh = filename; } _context.Update(canBo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CanBoExists(canBo.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } if (ImageFile != null) { ViewData["Image_Notif"] = "Vui lòng chọn lại ảnh đại diện"; } ViewData["DanTocID"] = new SelectList(_context.dmDanTocs, "ID", "TenDanToc"); ViewData["TonGiaoID"] = new SelectList(_context.dmTonGiaos, "ID", "TenTonGiao"); ViewData["TDPhoThongID"] = new SelectList(_context.dmTrinhDoPTs, "ID", "TenTrinhDo"); ViewData["HocHamID"] = new SelectList(_context.dmHocHams, "ID", "TenHocHam"); ViewData["NgheNghiepID"] = new SelectList(_context.dmNgheNghieps, "ID", "TenNgheNghiep"); ViewData["TDPhoThongID"] = new SelectList(_context.dmTrinhDoPTs, "ID", "TenTrinhDo"); ViewData["NgheNghiepID"] = new SelectList(_context.dmNgheNghieps, "ID", "TenNgheNghiep"); ViewData["HinhThucThiTuyenID"] = new SelectList(_context.dmHinhThucThiTuyens, "ID", "TenHinhThucTT"); ViewData["QuanHamCaoNhatID"] = new SelectList(_context.dmQuanHams, "ID", "TenQuanHam"); ViewData["HangThuongBinhID"] = new SelectList(_context.dmHangThuongBinhs, "ID", "TenHangThuongBinh"); ViewData["GiaDinhCSID"] = new SelectList(_context.dmGiaDinhCSs, "ID", "TenGiaDinhCS"); ViewData["SucKhoeID"] = new SelectList(_context.dmTinhTrangSucKhoes, "ID", "TenTTSK"); ViewData["DonViID"] = new SelectList(_context.dmDonVis, "ID", "TenDonVi"); ViewData["KieuCanBo"] = new SelectList(_context.dmKieuCanBo, "ID", "TenKieuCanBo"); return(View(canBo)); }
public bool addCanBo(CanBo canBo) { using (var db = new QLHTGTEntities()) { CanBo cbo = this.findByUsername(canBo.username); if (cbo != null) { return(false); } try { db.CanBoes.Add(canBo); if (db.SaveChanges() > 0) { return(true); } else { return(false); } } catch { return(false); } } }
public List <CanBo> GetAll() { this.sqlHelper.CommandType = CommandType.StoredProcedure; SqlDataReader dt = this.sqlHelper.ExecuteReader("GetAllCanBo"); List <CanBo> dscanbo = new List <CanBo>(); while (dt.Read()) { CanBo cb = new CanBo(); cb.BangCap = dt["BangCap"].ToString(); cb.CapBac = dt["CapBac"].ToString(); cb.ChucVu = dt["ChucVu"].ToString(); cb.DiaChi = dt["DiaChi"].ToString(); cb.FileAnh = dt["Image"].ToString(); cb.GioiTinh = Convert.ToInt32(dt["GioiTinh"].ToString()); cb.Khoa = Convert.ToBoolean(dt["KhoaChungTu"].ToString())?1:0; cb.KhoaChungTu = Convert.ToBoolean(dt["KhoaChungTu"].ToString()); cb.MaCB = dt["MaCanBo"].ToString(); cb.MaKP = Convert.ToInt32(dt["MaPhongBan"].ToString()); cb.MaDT = dt["MaDanToc"].ToString(); cb.SoDT = dt["SoDienThoai"].ToString(); cb.TenCB = dt["TenCanBo"].ToString(); cb.TenKP = dt["TenPhongBan"].ToString(); cb.TenDT = dt["TenDanToc"].ToString(); dscanbo.Add(cb); } return(dscanbo); }
public bool doiMatKhau(string username, string oldPassword, string newPassword) { using (var db = new QLHTGTEntities()) { try { CanBo canBo = db.CanBoes.Where(n => n.username == username).FirstOrDefault(); if (canBo == null || canBo.password != oldPassword) { return(false); } canBo.password = newPassword; if (db.SaveChanges() > 0) { return(true); } else { return(false); } } catch { return(false); } } }
public bool updateCanBo(CanBo canBo) { using (var db = new QLHTGTEntities()) { try { CanBo canBoUpdate = db.CanBoes.Where(n => n.username == canBo.username).FirstOrDefault(); if (canBoUpdate == null) { return(false); } canBoUpdate.Ten = canBo.Ten; canBoUpdate.Bac = canBo.Bac; canBoUpdate.username = canBo.username; canBoUpdate.password = canBo.password; if (db.SaveChanges() > 0) { return(true); } else { return(false); } } catch { return(false); } } }
public CanBo LayCB(string Ma) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MACANBO, SqlDbType.NVarChar, 30) }; parm[0].Value = Ma; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblCanBo_Lay1", parm); CanBo cb = new CanBo(); if (d.Read()) { cb.MaCanBo = d[0].ToString(); cb.HoVaTen = d[1].ToString(); cb.QueQuan = d[2].ToString(); cb.NgaySinh = DateTime.Parse(d[3].ToString()); cb.UrlPhoto = d[4].ToString(); cb.MaDonVi = d[5].ToString(); cb.GioiTinh = bool.Parse(d[6].ToString()); cb.SoDienThoai = d[7].ToString(); cb.DiaChiEMail = d[8].ToString(); cb.GhiChu = d[9].ToString(); cb.MatKhau = d[10].ToString(); cb.TrangThai = bool.Parse(d[11].ToString()); } return(cb); }
public bool XoaDangVien(string username, string password, int MaCB) { try { authen a1 = new authen(); bool bAuthen = a1.fAuthen(username, password); if (bAuthen) { CanBo dv = (from c in db.CanBoes where c.ID == MaCB select c).FirstOrDefault(); dv.KhongLaDangVien = 1; db.SaveChanges(); return(true); } else { return(bAuthen); } } catch (Exception ex) { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { CanBo cb = new CanBo(); cb.HoVaTen = txtHovaTen.Text; cb.QueQuan = txtQuequan.Text; cb.NgaySinh = DateTime.Parse(txtNgaysinh.Text); cb.MaDonVi = ddlDonVi.SelectedValue; cb.GioiTinh = rdbNam.Checked; cb.SoDienThoai = txtDienthoai.Text; cb.DiaChiEMail = txtEmail.Text; cb.GhiChu = txtGhichu.Text; cb.MatKhau = txtMatKhau.Text; cb.TrangThai = rdHD.Checked; if (filAnh.HasFile) { cb.UrlPhoto = Up(filAnh); } if (editType.Value == "add") { cb.MaCanBo = txtMaCB.Text; int t = cbbll.Them(cb); EditState.Value = "hide"; LoadCB(); } else { cb.MaCanBo = txtMaCB.Text; cbbll.Sua(cb); LoadCB(); EditState.Value = "hide"; } }
public bool addYeuCauDangKyXe(YeuCauDangKyXe yeuCauDangKyXe) { using (var db = new QLHTGTEntities()) { NguoiDung nguoiDung = db.NguoiDungs.Where(n => n.ID == yeuCauDangKyXe.NguoiDung_id).FirstOrDefault(); LoaiXe loaiXe = db.LoaiXes.Where(n => n.ID == yeuCauDangKyXe.LoaiXe_id).FirstOrDefault(); MucPhiTruocBa mucPhiTruocBa = db.MucPhiTruocBas.Where(n => n.ID == yeuCauDangKyXe.MPTruocBa_id).FirstOrDefault(); MucPhiCapBien mucPhiCapBien = db.MucPhiCapBiens.Where(n => n.ID == yeuCauDangKyXe.MPCapBien_id).FirstOrDefault(); CanBo canBo = db.CanBoes.Where(n => n.ID == yeuCauDangKyXe.CanBo_id).FirstOrDefault(); if (nguoiDung != null && loaiXe != null && mucPhiTruocBa != null && mucPhiCapBien != null && canBo != null ) { try { yeuCauDangKyXe.NguoiDung = nguoiDung; db.YeuCauDangKyXes.Add(yeuCauDangKyXe); db.SaveChanges(); return(true); } catch { return(false); } } } return(false); }
private void btnThongKe_Click(object sender, EventArgs e) { CanBo canBo = new CanBo(); canBo.CanBoID = 7; string picke1 = fromDateSticker.Value.ToString("yyyy/M/d"); string picke2 = toDateSticker.Value.ToString("yyyy/M/d"); string query = string.Format("SELECT * from YeuCau where NgayTruc between '{0}' and '{1}'", picke1, picke2); List <YeuCau> lstYeuCau = db.YeuCau.SqlQuery(query).ToList(); List <YeuCau> yeuCaus = new List <YeuCau>(); foreach (YeuCau yeuCau in lstYeuCau) { yeuCaus.Add(db.YeuCau.SingleOrDefault(x => x.YeuCauID == yeuCau.YeuCauID)); } List <PhanCong> lstCongViec = new List <PhanCong>(); foreach (YeuCau yeuCau in yeuCaus) { List <PhanCong> p = yeuCau.PhanCong.ToList().FindAll(x => x.CanBoID == canBo.CanBoID); lstCongViec.AddRange(p); } dtGridTKCanBo.DataSource = lstCongViec; }
public async Task <IActionResult> Edit(int id, CanBo requestData) { if (id != requestData.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(requestData); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CanBoExists(requestData.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(requestData)); }
public List <CanBo> DSCB() { SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblCanBo_DS", null); List <CanBo> mylist = new List <CanBo>(); while (d.Read()) { CanBo cb = new CanBo(); cb.MaCanBo = d[0].ToString(); cb.HoVaTen = d[1].ToString(); cb.QueQuan = d[2].ToString(); cb.NgaySinh = DateTime.Parse(d[3].ToString()); cb.UrlPhoto = d[4].ToString(); cb.MaDonVi = d[5].ToString(); cb.GioiTinh = bool.Parse(d[6].ToString()); cb.SoDienThoai = d[7].ToString(); cb.DiaChiEMail = d[8].ToString(); cb.GhiChu = d[9].ToString(); cb.MatKhau = d[10].ToString(); cb.TrangThai = bool.Parse(d[11].ToString()); mylist.Add(cb); } d.Dispose(); return(mylist); }
public IActionResult OnGet(int id) { CanBo = _CanBoService.GetCanBo(id); if (CanBo == null) { return(NotFound()); } return(Page()); }
public void UpdateCanBo(int id, CanBo CanBo) { var _CanBo = _unitOfWork.DanhSachCanBo.GetBy(id); _CanBo.MaCanBo = CanBo.MaCanBo; _CanBo.Ten = CanBo.Ten; _CanBo.TrangThai = CanBo.TrangThai; _unitOfWork.Complete(); }
//UpdateYeuCau //DeleteCanBo public void DeleteCanBo(CanBo canBo) { CanBo CanBo = db.CanBo.SingleOrDefault(x => x.CanBoID == canBo.CanBoID); if (canBo == null) { } else { db.CanBo.Remove(canBo); } }
public CanBo findById(int id) { using (var db = new QLHTGTEntities()) { CanBo canBo = db.CanBoes.Where(b => b.ID == id).FirstOrDefault(); if (canBo != null) { return(canBo); } } return(null); }
public CanBo findByUsername(string username) { using (var db = new QLHTGTEntities()) { CanBo canBo = db.CanBoes.Where(b => b.username == username).FirstOrDefault(); if (canBo != null) { return(canBo); } } return(null); }
protected void grvCanBo_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvr; try { gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); } catch { return; } int index = gvr.RowIndex; if (e.CommandName == "Sua") { CanBo cb = new CanBo(); GridViewRow gvrow = grvCanBo.Rows[index]; txtMaCB.Text = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString(); txtMaCB.Enabled = false; cb = cbbll.LayCB(txtMaCB.Text); txtHovaTen.Text = cb.HoVaTen; txtDienthoai.Text = cb.SoDienThoai; ddlDonVi.SelectedValue = cb.MaDonVi; txtNgaysinh.Text = cb.NgaySinh.ToShortDateString(); txtQuequan.Text = cb.QueQuan; if (cb.GioiTinh) { rdbNam.Checked = true; } else { rdbNu.Checked = true; } txtEmail.Text = cb.DiaChiEMail; txtGhichu.Text = cb.GhiChu; if (cb.TrangThai) { rdHD.Checked = true; } else { rdKHD.Checked = true; } EditState.Value = "edit"; editType.Value = "edit"; } else if (e.CommandName == "Xoa") { GridViewRow gvrow = grvCanBo.Rows[index]; string id = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString(); idDelete.Value = id; EditState.Value = "delete"; } }
public CanBo auth(string username, string password) { using (var db = new QLHTGTEntities()) { CanBo canBo = db.CanBoes.Where(c => c.username == username && c.password == password).FirstOrDefault(); if (canBo != null) { return(canBo); } } return(null); }
private void btnPhai_Click(object sender, EventArgs e) { if (caTrucEdit == null) { MessageBox.Show("Ấn Nút 'Xem' Ca Chực Để Chọn Ca"); return; } for (int i = dtGridTrai.RowCount - 1; i >= 0; i--) { int? SoViec = yeuCauEdit.PhanCong.Count; DataGridViewRow row = dtGridTrai.Rows[i]; if (Convert.ToBoolean(row.Cells["Chon"].Value)) { if (lstCBDuocChon.Count <= yeuCauEdit.SoLuongNguoi && SoViec + 1 < yeuCauEdit.SoLuongCa) { CanBo canBo = (CanBo)row.DataBoundItem; List <PhanCong> lstPhancong = canBo.PhanCong.ToList().FindAll(x => x.YeuCau.NgayTruc == yeuCauEdit.NgayTruc); if (lstPhancong.Count > 0) { foreach (PhanCong phanCong in lstPhancong) { int c = DateTime.Compare((DateTime)phanCong.CaTruc.BatDau, (DateTime)caTrucEdit.BatDau); int b = DateTime.Compare((DateTime)phanCong.CaTruc.KetThuc, (DateTime)caTrucEdit.BatDau); if (DateTime.Compare((DateTime)phanCong.CaTruc.BatDau, (DateTime)caTrucEdit.BatDau) == 0 && DateTime.Compare((DateTime)caTrucEdit.BatDau, (DateTime)phanCong.CaTruc.KetThuc) == -1) { MessageBox.Show("Cán bộ " + canBo.HoTen + "trùng ca trực"); } else { canBoBindingSource1.Add((CanBo)row.DataBoundItem); canBoBindingSource2.RemoveAt(row.Index); lstCBDuocChon.Add(canBo); lstCBPhanCong.Add(canBo); } } } else { canBoBindingSource1.Add((CanBo)row.DataBoundItem); canBoBindingSource2.RemoveAt(row.Index); lstCBDuocChon.Add((CanBo)row.DataBoundItem); lstCBPhanCong.Add(canBo); } } else { MessageBox.Show("Số người chọn đã đủ hoặc đã vượt quá số ca yêu cầu"); return; } } } }
//PostCanBo public void PostCanBo(CanBo canBo) { if (canBo == null) { //return92 } else { db.CanBo.Add(canBo); db.SaveChanges(); } //return }
//PostYeuCau //UpdateCanBo public void UpdateCanBo(CanBo canBo) { CanBo CanBo = db.CanBo.SingleOrDefault(x => x.CanBoID == canBo.CanBoID); if (canBo == null) { } else { CanBo.HoTen = canBo.HoTen; CanBo.NgaySinh = canBo.NgaySinh; CanBo.DonVi = canBo.DonVi; canBo.ChuVu = canBo.ChuVu; } }
public async Task <IActionResult> Create(CanBo requestData) { if (string.IsNullOrEmpty(requestData.TenCanBo)) { throw new Exception(); } if (ModelState.IsValid) { _context.Add(requestData); await _context.SaveChangesAsync(); return(Redirect("/CanBo/Index")); } return(View(requestData)); }
public bool deleteCanBo(string username) { using (var db = new QLHTGTEntities()) { try { CanBo canBoDel = db.CanBoes.Where(n => n.username == username).FirstOrDefault(); db.CanBoes.Remove(canBoDel); db.SaveChanges(); return(true); } catch { return(false); } } }
private void btnXoa_Click(object sender, EventArgs e) { if (MessageBox.Show("Ban Co Chac Muon Xoa Khong?", "Mesage", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int rowId = dtGridQLCanBo.SelectedCells[0].RowIndex; int id = int.Parse(dtGridQLCanBo.Rows[rowId].Cells[0].Value.ToString()); CanBo canBo = db.CanBo.SingleOrDefault(x => x.CanBoID == id); db.CanBo.Remove(canBo); try { db.SaveChanges(); }catch (Exception ex) { } canBoBindingSource.DataSource = db.CanBo.ToList(); } }
public frmCanBoAdd(CanBo obj = null) { InitializeComponent(); _baseService = new BaseService <CanBo>(); SetFormat(); _obj = obj; if (obj != null) { txtID.Text = obj.ID.ToString(); txtMa.Text = obj.Ma.ToString(); txtTen.Text = obj.HoTen.ToString(); dateNgaySinh.Text = obj.NgaySinh.ToString(); txtQueQuan.Text = obj.QueQuan.ToString(); txtHoKhau.Text = obj.HoKhau.ToString(); txtCapBac.Text = obj.CapBac.ToString(); txtChucVuDang.Text = obj.ChucVuDang.ToString(); txtChucVuChinhQuyen.Text = obj.ChucVuChinhQuyen.ToString(); dateNgayVaoDang.Text = obj.NgayVaoDang.ToString(); dateNgayVaoDangChinhThuc.Text = obj.NgayVaoDangChinhThuc.ToString(); dateNgayVaoDoan.Text = obj.NgayVaoDoan.ToString(); dateNgayVaoNganh.Text = obj.NgayVaoNganh.ToString(); txtTrinhDoChuyenMon.Text = obj.TrinhDoChuyenMon.ToString(); if (!string.IsNullOrEmpty(obj.Anh)) { try { var assemblyPath = System.Reflection.Assembly.GetExecutingAssembly().Location; var assemblyParentPath = Path.GetDirectoryName(assemblyPath); var imageDir = Path.Combine(assemblyParentPath, "Assests/images"); imgAva.Image = new Bitmap($"{imageDir}/{obj.Anh}"); } catch (Exception ex) { } } rtbCacLoaiBangCap.Text = obj.CacLoaiBangCap; getListGD(); getListCV(); getListKT(); } else { EnableOrDisable(false); } }
public override object GetModel() { CanBo canbo = new CanBo(); canbo.MaCB = txtID.Text; canbo.TenCB = txtName.Text; canbo.NgaySinh = txtDate.DateTime; canbo.GioiTinh = rdgGender.SelectedIndex == 1 ? 0 : 1; canbo.MaKP = DataConverter.ToInt(cmbDepartment.EditValue.ToString()); canbo.MaDT = cmbEthnic.EditValue.ToString(); canbo.ChucVu = txtPosition.Text; canbo.CapBac = txtRank.Text; canbo.Khoa = ckbLock.Checked ? 1 : 0; canbo.KhoaChungTu = ckbLock.Checked; canbo.SoDT = txtPhone.Text; canbo.DiaChi = txtAddress.Text; canbo.BangCap = txtCertificate.Text; return(canbo); }
public CanBo Login(string Ma, string pass) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MACANBO, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30) }; parm[0].Value = Ma; parm[1].Value = pass; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblCB_Login", parm); CanBo tt = new CanBo(); if (d.Read()) { tt.MaCanBo = d[0].ToString(); tt.HoVaTen = d[1].ToString(); tt.UrlPhoto = d[2].ToString(); } return(tt); }
private void BindingModel() { this.isUpdated = false; this.isEdited = false; CanBo canbo = (CanBo)this.Model; txtID.Text = canbo.MaCB; txtName.Text = canbo.TenCB; txtDate.DateTime = DateTime.Now; rdgGender.SelectedIndex = canbo.GioiTinh == 1 ? 0 : 1; cmbDepartment.EditValue = canbo.MaKP; cmbEthnic.EditValue = canbo.MaDT; txtPosition.Text = canbo.ChucVu; txtRank.Text = canbo.CapBac; ckbLock.CheckState = canbo.Khoa == 1? CheckState.Checked: CheckState.Unchecked; txtPhone.Text = canbo.SoDT; txtAddress.Text = canbo.DiaChi; txtCertificate.Text = canbo.BangCap; txtID.ReadOnly = true; this.isUpdated = true; }
public int Sua(CanBo cb) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MACANBO, SqlDbType.NVarChar, 30), new SqlParameter(PARM_HOVATEN, SqlDbType.NVarChar, 30), new SqlParameter(PARM_QUEQUAN, SqlDbType.NVarChar, 150), new SqlParameter(PARM_NGAYSINH, SqlDbType.Date), new SqlParameter(PARM_URLPHOTO, SqlDbType.NVarChar, 300), new SqlParameter(PARM_MADONVI, SqlDbType.NVarChar, 30), new SqlParameter(PARM_GIOITINH, SqlDbType.Bit), new SqlParameter(PARM_SODIENTHOAI, SqlDbType.NVarChar, 30), new SqlParameter(PARM_DIACHIEMAIL, SqlDbType.NVarChar, 30), new SqlParameter(PARM_GHICHU, SqlDbType.NVarChar, 100), new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30), new SqlParameter(PARM_TRANGTHAI, SqlDbType.Bit) }; parm[0].Value = cb.MaCanBo; parm[1].Value = cb.HoVaTen; parm[2].Value = cb.QueQuan; parm[3].Value = cb.NgaySinh; if (cb.UrlPhoto == "" || cb.UrlPhoto == null) { parm[4].Value = DBNull.Value; } else { parm[4].Value = cb.UrlPhoto; } parm[5].Value = cb.MaDonVi; parm[6].Value = cb.GioiTinh; parm[7].Value = cb.SoDienThoai; parm[8].Value = cb.DiaChiEMail; parm[9].Value = cb.GhiChu; parm[10].Value = cb.MatKhau; parm[11].Value = cb.TrangThai; return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblCanBo_Sua", parm)); }