private async Task GetGroupsEntities(SqlConnection connection1, String userId, Dictionary <string, LoadRightsModel> rightModel) { SqlCommand cmd = new SqlCommand(); string cmdString = "SELECT m.entitie, gm.isquery, gm.isedit, gm.isnew, gm.isdelete, m.id FROM UsersGroups ug " + "left join groups g on ug.idgroup = g.id " + "left join groupsmenu gm on ug.idgroup = gm.idgroup " + "left join menu m on gm.idmenu = m.id " + "where ug.iduser = @iduser and ug.isChecked = 1 and g.status = 1 and m.status = 1"; 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()) { LoadRightsModel model = new LoadRightsModel(); model.identitie = reader.GetString(0); model.isquery = reader.GetInt32(1); model.isedit = reader.GetInt32(2); model.isnew = reader.GetInt32(3); model.isdelete = reader.GetInt32(4); model.idmenu = reader.GetString(5); if (rightModel.ContainsKey(model.identitie)) { if (rightModel[model.identitie].isquery < model.isquery) { rightModel[model.identitie].isquery = model.isquery; } if (rightModel[model.identitie].isedit < model.isedit) { rightModel[model.identitie].isedit = model.isedit; } if (rightModel[model.identitie].isnew < model.isnew) { rightModel[model.identitie].isnew = model.isnew; } if (rightModel[model.identitie].isdelete < model.isdelete) { rightModel[model.identitie].isdelete = model.isdelete; } } else { rightModel.Add(model.identitie, model); } } reader.Close(); }
private async Task <int> AddUsersEntities(SqlConnection connection1, String userId, LoadRightsModel model) { SqlCommand cmd = new SqlCommand(); string cmdString = "insert into UserRights (iduser, idmenu, entitie, isquery, isedit, isnew, isdelete) " + "Values(@iduser, @idmenu, @entitie, @isquery, @isedit, @isnew, @isdelete)"; cmd.CommandText = cmdString; cmd.Connection = connection1; SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar); parameter.Value = userId; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@idmenu", SqlDbType.VarChar); parameter.Value = model.idmenu; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@entitie", SqlDbType.VarChar); parameter.Value = model.identitie; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isquery", SqlDbType.Int); parameter.Value = model.isquery; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isedit", SqlDbType.Int); parameter.Value = model.isedit; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isnew", SqlDbType.Int); parameter.Value = model.isnew; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isdelete", SqlDbType.Int); parameter.Value = model.isdelete; cmd.Parameters.Add(parameter); return(await cmd.ExecuteNonQueryAsync()); }
private async Task <int> UpdateUsersEntities(SqlConnection connection1, String userId, LoadRightsModel model) { SqlCommand cmd = new SqlCommand(); string cmdString = "update UserRights set isquery = @isquery, isedit = @isedit, isnew = @isnew, isdelete = @isdelete " + "where iduser = @iduser and entitie = @entitie"; cmd.CommandText = cmdString; cmd.Connection = connection1; SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar); parameter.Value = userId; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@entitie", SqlDbType.VarChar); parameter.Value = model.identitie; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isquery", SqlDbType.Int); parameter.Value = model.isquery; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isedit", SqlDbType.Int); parameter.Value = model.isedit; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isnew", SqlDbType.Int); parameter.Value = model.isnew; cmd.Parameters.Add(parameter); parameter = new SqlParameter("@isdelete", SqlDbType.Int); parameter.Value = model.isdelete; cmd.Parameters.Add(parameter); return(await cmd.ExecuteNonQueryAsync()); }