public async Task <IEnumerable <HouseKeepers> > GetAllHouseKeepers()
{
AwsAccessHelper awsAccessHelper = new AwsAccessHelper(configuration);
var awsDb = awsAccessHelper.AwsConnecttion();
var request = new ScanRequest
{
TableName = tableName,
Limit = 1,
};
var allHouseKeepers = new List <HouseKeepers>();
ScanResponse response = null;
try
{
do
{
if (response != null)
{
request.ExclusiveStartKey = response.LastEvaluatedKey;
}
response = await awsDb.ScanAsync(request);
foreach (var item in response.Items)
{
var houseKeepers = new HouseKeepers
{
Id = Convert.ToInt32(item["Id"].N),
Name = item["Name"].S,
Point = item["Point"].S,
CheckDate = Convert.ToDateTime(item["CheckDate"].S, CultureInfo.InvariantCulture)
};
allHouseKeepers.Add(houseKeepers);
}
} while (response.LastEvaluatedKey != null && response.LastEvaluatedKey.Count > 0);
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
_context.HouseKeeper.ToList();
_context.BaseMaterial.ToList();
return(allHouseKeepers);
}
public async Task <IEnumerable <BaseMaterials> > GetAllBaseMaterials()
{
AwsAccessHelper awsAccessHelper = new AwsAccessHelper(configuration);
var awsDb = awsAccessHelper.AwsConnecttion();
var request = new ScanRequest
{
TableName = tableName,
Limit = 1,
};
var allBaseMaterials = new List <BaseMaterials>();
ScanResponse response = null;
try
{
do
{
if (response != null)
{
request.ExclusiveStartKey = response.LastEvaluatedKey;
}
response = await awsDb.ScanAsync(request);
foreach (var item in response.Items)
{
var BaseMaterials = new BaseMaterials
{
Id = Convert.ToInt32(item["Id"].N),
Name = item["Name"].S,
Status = Convert.ToInt16(item["Status"].N)
};
allBaseMaterials.Add(BaseMaterials);
}
} while (response.LastEvaluatedKey != null && response.LastEvaluatedKey.Count > 0);
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
_context.BaseMaterial.ToList();
_context.BaseMaterial.ToList();
return(allBaseMaterials);
}
public async Task <IEnumerable <Rooms> > GetAllRooms()
{
AwsAccessHelper awsAccessHelper = new AwsAccessHelper(configuration);
var awsDb = awsAccessHelper.AwsConnecttion();
var request = new ScanRequest
{
TableName = tableName,
Limit = 1,
};
var allRooms = new List <Rooms>();
ScanResponse response = null;
try
{
do
{
if (response != null)
{
request.ExclusiveStartKey = response.LastEvaluatedKey;
}
response = await awsDb.ScanAsync(request);
foreach (var item in response.Items)
{
var room = new Rooms
{
Id = Convert.ToInt32(item["Id"].N),
RoomNumber = Convert.ToInt32(item["RoomNumber"].N),
Status = Convert.ToInt32(item["Status"].N),
Note = item["Note"].S,
CheckDate = Convert.ToDateTime(item["CheckDate"].S, CultureInfo.InvariantCulture),
BaseMaterial = new BaseMaterials
{
Id = Convert.ToInt32(item["BaseMaterials"].M["Id"].N),
Name = item["BaseMaterials"].M["Name"].S,
Status = Convert.ToInt16(item["BaseMaterials"].M["Status"].N)
},
HouseKeeper = new HouseKeepers
{
Id = Convert.ToInt32(item["HouseKeepers"].M["Id"].N),
Name = item["HouseKeepers"].M["Name"].S,
Point = item["HouseKeepers"].M["Point"].S,
CheckDate = Convert.ToDateTime(item["HouseKeepers"].M["CheckDate"].S, CultureInfo.InvariantCulture)
},
creator = Convert.ToInt32(item["creator"].N) == 1 ? Creator.Admin : Creator.Personel
};
allRooms.Add(room);
}
} while (response.LastEvaluatedKey != null && response.LastEvaluatedKey.Count > 0);
}
catch (AmazonDynamoDBException e) { Console.WriteLine(e.Message); }
catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
catch (Exception e) { Console.WriteLine(e.Message); }
_context.HouseKeeper.ToList();
_context.BaseMaterial.ToList();
//reponse null control yap
return(allRooms);
}
