private async Task InsertBingDataAsync(string bingSearchJsonResult, string prospectName, string searchString)
{
var allSearchResults = JObject.Parse(bingSearchJsonResult);
List <ExtractedBingSearchData> searchResultList = new List <ExtractedBingSearchData>();
ExtractedBingSearchData searchData = null;
foreach (var searchResult in allSearchResults["webPages"]["value"])
{
searchData = new ExtractedBingSearchData();
searchData.url = Convert.ToString(searchResult["url"]);
searchData.dateLastCrawled = Convert.ToDateTime(searchResult["dateLastCrawled"]).ToString("dd-MM-yyyy");
searchResultList.Add(searchData);
}
string jsonUrlString = JsonConvert.SerializeObject(searchResultList);
ProspectSummaryData prospectSummaryData = new ProspectSummaryData
{
ProspectName = prospectName,
SearchResult = jsonUrlString,
SearchString = prospectName + " + " + searchString,
BingSearchUpdates = true,
DataProcessedDate = null
};
IDataAccess dataAccess = DataAccess.GetInstance();
await dataAccess.InsertProspectData(prospectSummaryData);
}
public async Task <bool> CreateProspectDataAsync(ProspectSummaryData prospectSummaryData)
{
Document doc = await client.CreateDocumentAsync(UriFactory.CreateDocumentCollectionUri(DatabaseId, CollectionId), prospectSummaryData);
if (doc == null)
{
return(false);
}
return(true);
}
public async Task <bool> InsertProspectData(ProspectSummaryData prospectSummary)
{
try
{
IDBRepository dbObejct = FactoryClass.CreateDBRepositoryObject();
return(await dbObejct.CreateProspectDataAsync(prospectSummary));
}
catch
{
return(false);
}
}
public async Task ProcessEmailData(string fileName)
{
ProspectSummaryData prospectSummaryData = new ProspectSummaryData
{
ProspectName = "",
SearchResult = readBlobData(fileName),
SearchString = "",
EmailUpdates = true,
DataProcessedDate = null
};
IDataAccess dataAccess = DataAccess.GetInstance();
await dataAccess.InsertProspectData(prospectSummaryData);
}
public async Task <bool> CreateProspectDataAsync(ProspectSummaryData prospectSummaryData)
{
try
{
ProspectData prospectData = Mapper.Map <ProspectSummaryData, ProspectData>(prospectSummaryData);
prospectDBContext.ProspectDatas.Add(prospectData);
int result = await prospectDBContext.SaveChangesAsync();
return(result < 1 ? false : true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <bool> CreateProspectDataAsync(ProspectSummaryData prospectData)
{
try
{
CloudTable table = GetTableManager("ProspectData");
prospectData.PartitionKey = "ProspectSummary";
prospectData.RowKey = Guid.NewGuid().ToString();
TableOperation insertOperation = TableOperation.Insert(prospectData);
await table.ExecuteAsync(insertOperation);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
