public bool thanhvien_xoa(DOT_thanhvien tv)
{
using (SqlConnection conn = getConnect())
{
SqlCommand cmd = new SqlCommand("sp_delete_thanhvien", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@matv", tv.matv));
cmd.ExecuteNonQuery();
}
return(true);
}
public int thanhvien_them(DOT_thanhvien tv)
{
using (SqlConnection conn = getConnect())
{
SqlCommand cmd = new SqlCommand("sp_insert_thanhvien", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@manv", tv.manv));
cmd.Parameters.Add(new SqlParameter("@mada", tv.mada));
cmd.Parameters.Add(new SqlParameter("@chucvu", tv.chucvu));
cmd.Parameters.Add(new SqlParameter("@congviec", tv.congviec));
return(Convert.ToInt32(cmd.ExecuteScalar()));
}
}
public DataTable thanhvien_tim(DOT_thanhvien nv)
{
using (SqlConnection conn = getConnect())
{
SqlCommand cmd = new SqlCommand("thanhvien_tim", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@congviec", nv.congviec));
cmd.Parameters.Add(new SqlParameter("@chucvu", nv.chucvu));
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
}
public bool thanhvien_sua(DOT_thanhvien tv)
{
using (SqlConnection conn = getConnect())
{
SqlCommand cmd = new SqlCommand("sp_update_thanhvien", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@matv", tv.matv));
cmd.Parameters.Add(new SqlParameter("@manv", tv.manv));
cmd.Parameters.Add(new SqlParameter("@mada", tv.mada));
cmd.Parameters.Add(new SqlParameter("@chucvu", tv.chucvu));
cmd.Parameters.Add(new SqlParameter("@congviec", tv.congviec));
cmd.ExecuteNonQuery();
}
return(true);
}