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)); }