private void btnAdd_Click(object sender, EventArgs e) { if (CheckData()) { ClsNhanVien nv = new ClsNhanVien(); nv.MaCanBo = txtMacanbo.Text; nv.HoTen = txtHoten.Text; nv.ChuyenMon = cbChuyenmon.Text; nv.TrinhDo = cbtrinhdo.Text; nv.HesoLuong = int.Parse(txtHesoluong.Text); nv.XepLoai = cbXeploai.Text; nv.GioiTinh = cbGioitinh.Text; nv.NamSinh = dtNamsinh.Text; nv.NamTanLuong = dtNamtanluong.Text; if (clsbill.AddNhanVien(nv)) { MessageBox.Show("Them Cán Bộ thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ShowAllNhanVien(); } else { MessageBox.Show("Them Cán Bộ không thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
// phuong thuc Update public bool UpdateNhanCanBo(ClsNhanVien nv) { string sql = "usp_Update_CanBo"; SqlConnection conn = cndb.getConnect(); try { conn.Open(); var cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@macanbo", SqlDbType.NVarChar).Value = nv.MaCanBo; cmd.Parameters.Add("@hoten", SqlDbType.NVarChar).Value = nv.HoTen; cmd.Parameters.Add("@namsinh", SqlDbType.DateTime).Value = Convert.ToDateTime(nv.NamSinh); cmd.Parameters.Add("@chuyenmon", SqlDbType.NVarChar).Value = nv.ChuyenMon; cmd.Parameters.Add("@trinhdo", SqlDbType.NVarChar).Value = nv.TrinhDo; cmd.Parameters.Add("@hesoluong", SqlDbType.Int).Value = nv.HesoLuong; cmd.Parameters.Add("@namtanluong", SqlDbType.DateTime).Value = Convert.ToDateTime(nv.NamTanLuong); cmd.Parameters.Add("@xeploai", SqlDbType.NVarChar).Value = nv.XepLoai; cmd.Parameters.Add("@gioitinh", SqlDbType.NVarChar).Value = nv.GioiTinh; cmd.ExecuteNonQuery(); conn.Close(); } catch { return(false); } return(true); }
private void btnDelete_Click(object sender, EventArgs e) { ClsNhanVien nv = new ClsNhanVien(); nv.MaCanBo = txtMacanbo.Text; if (clsbill.DeleteCanBo(nv)) { MessageBox.Show("Delete Cán Bộ thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ShowAllNhanVien(); } else { MessageBox.Show("Delete Cán Bộ không thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// phuong thuc tim kiem lao động public DataTable FindLoaiLaoDong(ClsNhanVien nv) { string sql = "usp_Select_CanBo_Gioi"; SqlConnection con = cndb.getConnect(); con.Open(); var cmd = new SqlCommand(sql, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@xeploai", SqlDbType.NVarChar).Value = nv.XepLoai; da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); return(dt); }
// phuong thuc tim kiem gioi tinh public DataTable FindGIoiTinh(ClsNhanVien nv) { string sql = "usp_getgioitinh"; SqlConnection con = cndb.getConnect(); con.Open(); var cmd = new SqlCommand(sql, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@gioitinh", SqlDbType.NVarChar).Value = nv.GioiTinh; da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); return(dt); }
// phuong thuc xoa can bo public bool DeleteCanBo(ClsNhanVien nv) { string sql = "usp_Delete_CanBo"; SqlConnection conn = cndb.getConnect(); try { conn.Open(); var cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@macanbo", SqlDbType.NVarChar).Value = nv.MaCanBo; cmd.ExecuteNonQuery(); conn.Close(); } catch { return(false); } return(true); }
private void btnXem_Click(object sender, EventArgs e) { ClsNhanVien nv = new ClsNhanVien(); nv.GioiTinh = cbgioitinh.Text; nv.ChuyenMon = cbChuyenMon.Text; nv.XepLoai = cbXepLoai.Text; if (!string.IsNullOrEmpty(cbgioitinh.Text)) { DataTable dt = clsbill.FindGIoiTinh(nv); dtgtracuu.DataSource = dt; } if (!string.IsNullOrEmpty(cbChuyenMon.Text)) { DataTable dt = clsbill.FindChuyenMon(nv); dtgtracuu.DataSource = dt; } if (!string.IsNullOrEmpty(cbXepLoai.Text)) { DataTable dt = clsbill.FindLoaiLaoDong(nv); dtgtracuu.DataSource = dt; } }
public bool DeleteCanBo(ClsNhanVien nv) { return(clsdal.DeleteCanBo(nv)); }
public bool UpdateNhanCanBo(ClsNhanVien nv) { return(clsdal.UpdateNhanCanBo(nv)); }
public bool AddNhanVien(ClsNhanVien nv) { return(clsdal.AddNhanVien(nv)); }
public DataTable FindLoaiLaoDong(ClsNhanVien nv) { return(clsdal.FindLoaiLaoDong(nv)); }
public DataTable FindChuyenMon(ClsNhanVien nv) { return(clsdal.FindChuyenMon(nv)); }
public DataTable FindGIoiTinh(ClsNhanVien nv) { return(clsdal.FindGIoiTinh(nv)); }