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