protected void btn_Save_Click(object sender, EventArgs e)
{
foreach (TreeNode nodeparent in trview_grant.Nodes)
{
DuyetCay(nodeparent);
}
foreach (ListItem item in lst_Box2.Items)
{
int User_ID = Int16.Parse(item.Value);
int Group_ID = Int16.Parse(drpd_NhomNguoi.SelectedValue);
SqlParameter[] prUSER_GROUP = { new SqlParameter("@User_ID", User_ID), new SqlParameter("@Group_ID", Group_ID) };
object User_Group_ID = cm.ExecuteScalarProcedure("[AddUserGroup]", prUSER_GROUP);
foreach (String itemModul in module)
{
String[] value = itemModul.Split('@');
int Parent_ID = Int16.Parse(value[0]);
int Module_ID = Int16.Parse(value[1]);
SqlParameter[] prUSER_GROUP_MODULE = { new SqlParameter("@User_Group_ID", User_Group_ID), new SqlParameter("@Module_ID", Module_ID), new SqlParameter("@Parent_ID", Parent_ID) };
cm.ExecuteProcedure("AddUSER_GROUP_MODULE", prUSER_GROUP_MODULE);
}
}
string script = "alert(\"Lưu thành công!\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
//SqlParameter[] pr = { new SqlParameter("@User_ID", DBNull.Value), new SqlParameter("@Group_ID", DBNull.Value) };
//for (int i = 0; i < lst_Box2.Items.Count; i++)
//{
// lst_Box2.DataSource = cm.getTableStoreprocedure("AddUserGroup", pr);
//}
//for (int i = 0; i < module.Count; i++)
//{
// string sql = "Select"
//}
}