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));
}
