public void _AddNhanVien(object parameter) { ThemNhanVien themNhanVien = new ThemNhanVien(); themNhanVien.ShowDialog(); Refresh(); }
private void button2_Click(object sender, EventArgs e) { if (txbMaNhanVien.Text.Length == 0) { MessageBox.Show("Mã nhân viên không được trống"); return; } ThemNhanVien temp = new ThemNhanVien(); if (txbMaNhanVien.Text != "") { temp.MaNhanVien = Int32.Parse(txbMaNhanVien.Text); } temp.HoTen = txbHoTen.Text; temp.NgaySinh = DateTime.Parse(dateTimePicker1.Text); temp.SDT = Int32.Parse(txbSDT.Text); temp.Email = txbEmail.Text; temp.MaChucVu = Int32.Parse(txbMaCV.Text); if (NVBLL.ThemNhanVien(temp)) { MessageBox.Show("Thêm nhân viên thành công"); ThemThanhCong = true; this.Dispose(); } else { MessageBox.Show("Thêm nhân viên thất bại"); } }
public bool ThemNhanVien(ThemNhanVien nhanVien) { try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Ho", nhanVien.Ho); parameters.Add("@Ten", nhanVien.Ten); parameters.Add("@GioiTinh", nhanVien.GioiTinh); parameters.Add("@NgaySinh", nhanVien.NgaySinh); parameters.Add("@SoChungMinh", nhanVien.SoChungMinh); parameters.Add("@SoDienThoai", nhanVien.SoChungMinh); parameters.Add("@Email", nhanVien.Email); parameters.Add("@DiaChi", nhanVien.DiaChi); parameters.Add("@MaSoThue", nhanVien.MaSoThue); parameters.Add("@HinhAnh", nhanVien.HinhAnh); parameters.Add("@QuyenId", nhanVien.QuyenId); parameters.Add("@ChucVuId", nhanVien.ChucVuId); parameters.Add("@BoPhanId", nhanVien.BoPhanId); parameters.Add("@MatKhau", nhanVien.MatKhau); SqlMapper.Execute(con, "sp_ThemNhanVien", parameters, commandType: System.Data.CommandType.StoredProcedure); return(true); } catch (Exception exp) { throw exp; } }
private void BTThemNV_Click(object sender, EventArgs e) { ThemNhanVien themNV = new ThemNhanVien(); this.Hide(); themNV.ShowDialog(); this.Show(); }
public ThemNhanVien LayThongTinNhanVien(int MaNV) { ThemNhanVien nv = new ThemNhanVien(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM dbo.LayThongTiNhanVien(@maNhanVien)"; command.Connection = conn; command.Parameters.Add("@maNhanVien", SqlDbType.Int).Value = MaNV; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { nv.MaNhanVien = reader.GetInt32(0); if (!reader.IsDBNull(1)) { nv.HoTen = reader.GetString(1); } else { nv.HoTen = "Chưa có thông tin"; } if (!reader.IsDBNull(2)) { nv.NgaySinh = reader.GetDateTime(2); } else { nv.NgaySinh = DateTime.Now; } if (!reader.IsDBNull(3)) { nv.SDT = reader.GetInt32(3); } else { nv.SDT = 0; } if (!reader.IsDBNull(4)) { nv.Email = reader.GetString(4); } else { nv.Email = "Chưa có thông tin"; } if (!reader.IsDBNull(5)) { nv.MaChucVu = reader.GetInt32(5); } } reader.Close(); return(nv); }
private void SuaNhanVien_Load(object sender, EventArgs e) { ThemNhanVien temp = NVBLL.LayThongTinNhanVien(MaNV); lbMaNV.Text = temp.MaNhanVien.ToString(); txbHoTen.Text = temp.HoTen; pickDateTimeNV.Text = temp.NgaySinh.ToString(); txbSDT.Text = temp.SDT.ToString(); txbEmail.Text = temp.Email.ToString(); txbMaCV.Text = temp.MaChucVu.ToString(); }
private void btnThem_Click(object sender, EventArgs e) { infoNhanVien infoNhanVien = new infoNhanVien() { ConQuanLy = true }; ThemNhanVien frm = new ThemNhanVien(true, infoNhanVien); frm.ShowDialog(); hienThi(); }
public IActionResult ThemNhanVien(ThemNhanVien nhanVien) { var files = HttpContext.Request.Form.Files; foreach (var Image in files) { if (Image != null && Image.Length > 0) { var file = Image; var upload = Path.Combine(_dir, "wwwroot\\Upload\\Images"); if (file.Length > 0) { var fileName = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(file.FileName); using (var fileStream = new FileStream(Path.Combine(upload, fileName), FileMode.Create)) { file.CopyTo(fileStream); nhanVien.HinhAnh = $"{fileName}"; } } } } var createResult = false; var httpWebRequest = (HttpWebRequest)WebRequest.Create($"{Common.Common.ApiUrl}/nhansu/themnhanvien"); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { var json = JsonConvert.SerializeObject(nhanVien); streamWriter.Write(json); } var response = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(response.GetResponseStream())) { var result = streamReader.ReadToEnd(); createResult = bool.Parse(result); } if (createResult) { TempData["Success"] = " created successfully"; } else { TempData["Error"] = " create fail , please try again !"; } ViewBag.ChucVu = ChucVuViewBag(); ViewBag.BoPhan = BoPhanViewBag(); ViewBag.QuyenTruyCap = QuyenTruyCapViewBags(); ModelState.Clear(); return(View(new ThemNhanVien())); }
private void button2_Click(object sender, EventArgs e) { ThemNhanVien nv = new ThemNhanVien(); nv.MaNhanVien = Int32.Parse(lbMaNV.Text); nv.HoTen = txbHoTen.Text; nv.NgaySinh = DateTime.Parse(pickDateTimeNV.Text); nv.SDT = Int32.Parse(txbSDT.Text); nv.Email = txbEmail.Text; nv.MaChucVu = Int32.Parse(txbMaCV.Text); if (NVBLL.SuaNhanVien(nv)) { MessageBox.Show("Sửa thành công"); } }
public bool SuaNhanVien(ThemNhanVien nv) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "UpdateDL"; command.Connection = conn; command.Parameters.Add("@MaNhanVien", SqlDbType.Int).Value = nv.MaNhanVien; command.Parameters.Add("@HoTen", SqlDbType.NVarChar).Value = nv.HoTen; command.Parameters.Add("@NgaySinh", SqlDbType.Date).Value = nv.NgaySinh; command.Parameters.Add("@SDT", SqlDbType.Int).Value = nv.SDT; command.Parameters.Add("@email", SqlDbType.NChar).Value = nv.Email; command.Parameters.Add("@MaChucVu", SqlDbType.Int).Value = nv.MaChucVu; int kq = command.ExecuteNonQuery(); return(kq > 0); }
private void btnSua_Click(object sender, EventArgs e) { _currentRowIndex = gridView1.FocusedRowHandle; if (_currentRowIndex < 0) { return; } infoNhanVien infoNhanVien = new infoNhanVien() { MaNV = int.Parse(gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["MaNV"]).ToString()), TenNV = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["TenNV"]).ToString(), DiaChiNV = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["DiaChiNV"]).ToString(), DTNV = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["DTNV"]).ToString(), EmailNV = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["EmailNV"]).ToString(), ConQuanLy = bool.Parse(gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["ConQuanLy"]).ToString()), }; ThemNhanVien frm = new ThemNhanVien(false, infoNhanVien); frm.ShowDialog(); hienThi(); }
public bool ThemNhanVien(ThemNhanVien temp) { return(NVA.ThemNhanVien(temp)); }
public bool ThemNhanVien(ThemNhanVien nhanVien) { return(_nhanSuRepo.ThemNhanVien(nhanVien)); }
private void Them_Click(object sender, RoutedEventArgs e) { var window = new ThemNhanVien(); window.ShowDialog(); }
public bool SuaNhanVien(ThemNhanVien temp) { return(NVA.SuaNhanVien(temp)); }
public bool ThemNhanVien(ThemNhanVien nhanVien) { return(_nhanSuService.ThemNhanVien(nhanVien)); }
private void btnThenNV_Click(object sender, EventArgs e) { ThemNhanVien formthennv = new ThemNhanVien(provider); formthennv.Show(); }