private void AddRight(string menu, List <MenuRightsModel> model)
{
MenuRightsModel modelRight = new MenuRightsModel();
modelRight.menu = menu;
modelRight.isquery = 1;
modelRight.isedit = 1;
modelRight.isnew = 1;
modelRight.isdelete = 1;
model.Add(modelRight);
}
private async Task GetMenuRights(SqlConnection connection1, string userId, List <MenuRightsModel> model, bool isAdmin)
{
SqlCommand cmd = new SqlCommand();
string cmdString = "SELECT m.menu, u.isquery, u.isedit, u.isnew, u.isdelete FROM UserRights u " +
"left join menu m on u.idmenu = m.id " +
"where iduser = @iduser and m.status = 1 " +
"order by m.menu";
cmd.CommandText = cmdString;
cmd.Connection = connection1;
SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar);
parameter.Value = userId;
cmd.Parameters.Add(parameter);
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
if (reader.GetInt32(1) == 1)
{
MenuRightsModel menu = new MenuRightsModel();
menu.menu = reader.GetString(0);
menu.isquery = reader.GetInt32(1);
menu.isedit = reader.GetInt32(2);
menu.isnew = reader.GetInt32(3);
menu.isdelete = reader.GetInt32(4);
model.Add(menu);
}
}
reader.Close();
}
