public string XoaNhanVien(string manv)
{
string kq = "false";
try
{
string str = "XoaNhanVien";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@manv", manv);
cmd.Parameters["@manv"].Direction = ParameterDirection.Input;
SqlParameter para = new SqlParameter("@kq", SqlDbType.Int);
para.Direction = ParameterDirection.Output;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
kq = para.Value.ToString();
con.Close();
cmd.Dispose();
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
return(kq);
}
public string SuaNhanVien(string manv, string tennv, string ngaysinh, string gioitinh, string quequan, string luong, string macv, string mapb)
{
string str = "SuaNhanVien";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@manv", manv);
cmd.Parameters.AddWithValue("@ten", tennv);
cmd.Parameters.AddWithValue("@ns", Convert.ToDateTime(ngaysinh));
cmd.Parameters.AddWithValue("@gt", gioitinh);
cmd.Parameters.AddWithValue("@qq", quequan);
cmd.Parameters.AddWithValue("@l", luong);
cmd.Parameters.AddWithValue("@macv", macv);
cmd.Parameters.AddWithValue("@mapb", mapb);
SqlParameter para = new SqlParameter("@kq", SqlDbType.Int);
para.Direction = ParameterDirection.Output;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
string kq = para.Value.ToString();
cmd.Dispose();
con.Close();
return(kq);
}
public DataTable ShowMaNV()
{
string str = @"select MaNV as ma from tblNhanVien";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
SqlDataAdapter ad = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
public DataTable ShowPhongBan()
{
string str = @"select MaPB as [Mã Phòng Ban] from tblPhongBan";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
SqlDataAdapter ad = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
public DataTable ShowChucVu()
{
string str = @"select MaCV as [Mã Chức Vụ] from tblChucVu";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
SqlDataAdapter ad = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
private void connect()
{
try
{
con = new SqlConnection(ConnectDATA.getconnect());
con.Open();
}
catch (Exception)
{
MessageBox.Show("Không thể kết nối cơ sở dữ liệu");
}
}
public DataTable ShowNhanVien()
{
string str = @"select MaNV as [Mã Nhân Viên],TenNV as [Tên Nhân Viên],NgaySinh as [Ngày Sinh],
GioiTinh as [Giới tính],QueQuan as [Quê Quán],Luong as [Lương],MaCV as [Mã Chức Vụ],
MaPB as [Mã Phòng Ban] from tblNhanVien";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
SqlDataAdapter ad = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
public DataTable TimKiem(string manv, string tennv, string macv, int chose)
{
string str = "TimKiemNhanVien";
SqlConnection con = new SqlConnection(ConnectDATA.getconnect());
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@manv", manv);
cmd.Parameters["@manv"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("@ten", tennv);
cmd.Parameters["@ten"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("@macv", macv);
cmd.Parameters["@macv"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("@chose", chose);
cmd.Parameters["@chose"].Direction = ParameterDirection.Input;
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
