internal Response DynamoDbSearchPositions(PositionFilterCriteria positionCriteria)
{
if ((null == positionCriteria.TotalPLV || "" == positionCriteria.TotalPLV) && (null == positionCriteria.Website || "" == positionCriteria.Website))
{
return(new Response(false, "First enter Search String"));
}
Dictionary <string, Condition> filter = new Dictionary <string, Condition>();
if (null != positionCriteria.TotalPLV && "" != positionCriteria.TotalPLV)
{
filter.Add("TotalPLV", new Condition
{
ComparisonOperator = "CONTAINS",
AttributeValueList = new List <AttributeValue>()
{
new AttributeValue {
S = positionCriteria.TotalPLV.ToLower()
}
}
});
}
if (null != positionCriteria.Website && "" != positionCriteria.Website)
{
filter.Add("PositionWebsite", new Condition
{
ComparisonOperator = "CONTAINS",
AttributeValueList = new List <AttributeValue>()
{
new AttributeValue {
S = positionCriteria.Website.ToLower()
}
}
});
}
ScanRequest request = new ScanRequest
{
TableName = _tablename,
AttributesToGet = new List <string> {
"TotalPLV", "PositionWebsite"
},
ScanFilter = filter
};
ScanResponse response = AmazonDynamoDBClientConnection.Client.Scan(request);
List <PositionData> positionList = CovertresponseIntoJSON(response);
return(new Response(true, "Search data found", positionList));
}
internal Response DynamoDbSearchTasks(PositionFilterCriteria positionCriteria)
{
if ((null == positionCriteria.PositionLabel || "" == positionCriteria.PositionLabel) && (null == positionCriteria.Website || "" == positionCriteria.Website) &&
(null == positionCriteria.Status || "" == positionCriteria.Status))
{
return(new Response(false, "First enter Search String"));
}
Dictionary <string, Condition> filter = new Dictionary <string, Condition>();
if (null != positionCriteria.PositionLabel && "" != positionCriteria.PositionLabel)
{
filter.Add("PositionLabel", new Condition
{
ComparisonOperator = "CONTAINS",
AttributeValueList = new List <AttributeValue>()
{
new AttributeValue {
S = positionCriteria.PositionLabel.ToLower()
}
}
});
}
if (null != positionCriteria.Website && "" != positionCriteria.Website)
{
filter.Add("PositionWebsite", new Condition
{
ComparisonOperator = "CONTAINS",
AttributeValueList = new List <AttributeValue>()
{
new AttributeValue {
S = positionCriteria.Website.ToLower()
}
}
});
}
if (null != positionCriteria.Status && "" != positionCriteria.Status)
{
filter.Add("Status", new Condition
{
ComparisonOperator = "CONTAINS",
AttributeValueList = new List <AttributeValue>()
{
new AttributeValue {
S = positionCriteria.Status.ToLower()
}
}
});
}
ScanRequest request = new ScanRequest
{
TableName = _tablename,
AttributesToGet = new List <string> {
"PositionLabel", "PositionWebsite", "SelectSelection", "StartDateTime", "EndDateTime", "StartDate", "EndDate", "TotalDateTime", "SelectTasks", "SelectCountries", "SelectedIdentities", "Note"
},
ScanFilter = filter
};
ScanResponse response = AmazonDynamoDBClientConnection.Client.Scan(request);
List <PositionData> positionList = CovertresponseIntoJSON(response);
return(new Response(true, "Search data found", positionList));
}