Beispiel #1
0
        public List <string> GetEmployee(string name)
        {
            var table = GetConnectionTable2();
            var lists = new List <string>();

            if (name == "" || name == string.Empty)
            {
                var query = new Microsoft.Azure.Cosmos.Table.TableQuery <EmployeeEntity>();
                var lst   = table.ExecuteQuery(query).ToList();
                foreach (var item in lst)
                {
                    lists.Add(item.PartitionKey);
                }
                return(lists);
            }
            else
            {
                var condition = Microsoft.Azure.Cosmos.Table.TableQuery.GenerateFilterCondition("PartitionKey", Microsoft.Azure.Cosmos.Table.QueryComparisons.Equal, name);
                var query     = new Microsoft.Azure.Cosmos.Table.TableQuery <EmployeeEntity>().Where(condition);

                var lst = table.ExecuteQuery(query).ToList();
                foreach (var item in lst)
                {
                    lists.Add(item.PartitionKey);
                }
                return(lists);
            }
        }
Beispiel #2
0
        public async Task LogoutAllUser(string user)
        {
            var table = GetConnectionTable2();
            await table.CreateIfNotExistsAsync();

            Microsoft.Azure.Cosmos.Table.TableQuery <EmployeeEntity> query = new Microsoft.Azure.Cosmos.Table.TableQuery <EmployeeEntity>()
                                                                             .Where(Microsoft.Azure.Cosmos.Table.TableQuery.GenerateFilterCondition("PartitionKey", Microsoft.Azure.Cosmos.Table.QueryComparisons.Equal, user));
            foreach (var item in table.ExecuteQuery(query))
            {
                var oper = Microsoft.Azure.Cosmos.Table.TableOperation.Delete(item);
                table.Execute(oper);
            }
            //Microsoft.Azure.Cosmos.Table.TableOperation Remove = Microsoft.Azure.Cosmos.Table.TableOperation.Delete(new EmployeeEntity() { PartitionKey = user });
            //await table.ExecuteAsync(Remove);
        }