protected void ChucVuGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
//nếu bấm nút xóa ==>xóa ngay
if (e.CommandName == "xoa")
{
string macv = (e.CommandArgument).ToString();
if (chucvuBUS.XoaChucVu(macv) == true)
{
chucvuBUS.XoaChucVu(macv);
NapDuLieu();
}
else
{
ThongBaoPopup.Show();
}
}
//nếu bấm nút sửa ==>bật popup sửa
else if (e.CommandName == "sua")
{
//lấy danh sach ChucVu
ChucVuCollection cvColl = new ChucVuCollection();
cvColl = chucvuBUS.TimDSChucVu(TimTextbox.Text);
//Lấy index dòng đang chọn
int index = Convert.ToInt32(e.CommandArgument.ToString());
ViewState["macv"] = cvColl.Index(index).MaCV;
string tencv = cvColl.Index(index).TenCV;
SuaPopup.Show();
SuaTextBox.Text = tencv;
}
}
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;
}
