public ChucVuCollection TimDSChucVu(string tencv)
{
ChucVuCollection cvColl = new ChucVuCollection();
SqlConnection cnn = new SqlConnection(cnnstr);
string query = "select * from ChucVu where tencv <> '' ";
query += "order by tencv";
SqlCommand cmd = new SqlCommand(query, cnn);
if (tencv != "")
{
query = "select * from ChucVu where tencv like @tencv and tencv <>''";
query += "order by tencv";
cmd = new SqlCommand(query, cnn);
cmd.Parameters.AddWithValue("@tencv", "%" + tencv + "%");
}
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ChucVuBO cvBO = new ChucVuBO();
cvBO.MaCV = dr["macv"].ToString();
cvBO.TenCV = dr["tencv"].ToString();
cvColl.Add(cvBO);
}
cnn.Close();
return cvColl;
}
public void SuaChucVu(ChucVuBO ChucVuBO)
{
SqlConnection cnn = new SqlConnection(cnnstr);
string query = "update ChucVu set tencv=@tencv where macv=@macv ";
SqlCommand cmd = new SqlCommand(query, cnn);
cmd.Parameters.AddWithValue("@tencv", ChucVuBO.TenCV);
cmd.Parameters.AddWithValue("@macv", ChucVuBO.MaCV);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
public bool SuaChucVu(string macv, string tencv)
{
try
{
ChucVuBO chucvuBO = new ChucVuBO();
chucvuBO.MaCV = macv;
chucvuBO.TenCV = tencv;
chucvuDAO.SuaChucVu(chucvuBO);
return true;
}
catch
{
return false;
}
}
public ChucVuBO Tim1ChucVu(string macv)
{
ChucVuBO chucvuBO = new ChucVuBO();
SqlConnection cnn = new SqlConnection(cnnstr);
string query = "select * from ChucVu where tencv <> '' and MaCV=@macv ";
SqlCommand cmd = new SqlCommand(query, cnn);
cmd.Parameters.AddWithValue("@macv", macv);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
chucvuBO.MaCV = dr["macv"].ToString();
chucvuBO.TenCV = dr["tencv"].ToString();
break;
}
return chucvuBO;
}
public void Add(ChucVuBO chucvuBO)
{
List.Add(chucvuBO);
}
