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