public async Task <ProspectSearchCriteria> GetProspectSearchCriteriaAsync(ProspectSearchCriteria prospectSearchCriteria)
{
IDBRepository dbObejct = FactoryClass.CreateDBRepositoryObject();
IEnumerable <ProspectSearchCriteria> prospectSearchCriteriaList = await dbObejct.GetExisitingProspectSearchCriteriaAsync(prospectSearchCriteria);
return(prospectSearchCriteriaList.FirstOrDefault());
}
public async Task <ProspectSearchCriteria> GetProspectSearchCriteriaAsync(string id)
{
ProspectDataSearchCriteria prospectDataSearchCriteria = await prospectDBContext.ProspectDataSearchCriterias.FindAsync(int.Parse(id));
ProspectSearchCriteria prospectsearchCriteria = Mapper.Map <ProspectDataSearchCriteria, ProspectSearchCriteria>(prospectDataSearchCriteria);
return(prospectsearchCriteria);
}
public async Task <ProspectSearchCriteria> GetProspectSearchCriteriaAsync(int id, string rowKey)
{
IDBRepository dbObejct = FactoryClass.CreateDBRepositoryObject();
string key = string.IsNullOrEmpty(rowKey) ? id.ToString() : rowKey;
ProspectSearchCriteria prospectSearchCriteria = await dbObejct.GetProspectSearchCriteriaAsync(key);
return(prospectSearchCriteria);
}
public async Task <bool> CreateProspectSearchDataAsync(ProspectSearchCriteria prospectSearchCriteria)
{
ProspectDataSearchCriteria prospectDataSearchCriteria = Mapper.Map <ProspectSearchCriteria, ProspectDataSearchCriteria>(prospectSearchCriteria);
prospectDBContext.ProspectDataSearchCriterias.Add(prospectDataSearchCriteria);
int result = await prospectDBContext.SaveChangesAsync();
return(result < 1 ? false : true);
}
public async Task <bool> UpdateProspectSearchDataAsync(ProspectSearchCriteria prospectSearchCriteria)
{
ProspectDataSearchCriteria prospectDataSearchCriteria = Mapper.Map <ProspectSearchCriteria, ProspectDataSearchCriteria>(prospectSearchCriteria);
prospectDBContext.Entry(prospectDataSearchCriteria).State = EntityState.Modified;
int result = await prospectDBContext.SaveChangesAsync();
return(result < 1 ? false : true);
}
public async Task <bool> UpdateProspectSearchDataAsync(ProspectSearchCriteria prospectSearchCriteria)
{
Document doc = await client.ReplaceDocumentAsync(UriFactory.CreateDocumentUri(DatabaseId, CollectionId, prospectSearchCriteria.Id.ToString()), prospectSearchCriteria);
if (doc == null)
{
return(false);
}
return(true);
}
public async Task <ActionResult> DeleteAsync(int id, string rowKey)
{
IDataAccess dataAccess = DataAccess.GetInstance();
ProspectSearchCriteria prospectSearchCriteria = await dataAccess.GetProspectSearchCriteriaAsync(id, rowKey);
if (prospectSearchCriteria == null)
{
return(HttpNotFound());
}
return(View(prospectSearchCriteria));
}
public async Task <bool> CreateProspectSearchDataAsync(ProspectSearchCriteria ProspectSearchCriteria)
{
Document doc = await client.CreateDocumentAsync(UriFactory.CreateDocumentCollectionUri(DatabaseId, CollectionId), ProspectSearchCriteria);
if (doc == null)
{
return(false);
}
return(true);
}
public async Task <bool> UpdateProspectSearchData(ProspectSearchCriteria prospectSearchCriteria)
{
try
{
IDBRepository dbObejct = FactoryClass.CreateDBRepositoryObject();
return(await dbObejct.UpdateProspectSearchDataAsync(prospectSearchCriteria));
}
catch
{
return(false);
}
}
public async Task <ActionResult> DeleteViewAsync(int id, string rowKey)
{
IDataAccess dataAccess = DataAccess.GetInstance();
ProspectSearchCriteria prospectSearchCriteria = await dataAccess.GetProspectSearchCriteriaAsync(id, rowKey);
if (prospectSearchCriteria == null)
{
return(HttpNotFound());
}
await dataAccess.DeleteProspectSearchData(prospectSearchCriteria);
return(RedirectToAction("Index"));
}
public async Task <bool> DeleteProspectSearchData(ProspectSearchCriteria prospectSearchCriteria)
{
try
{
IDBRepository dbObejct = FactoryClass.CreateDBRepositoryObject();
string key = string.IsNullOrEmpty(prospectSearchCriteria.RowKey) ? prospectSearchCriteria.Id.ToString() : prospectSearchCriteria.RowKey;
await dbObejct.DeleteProspectSearchDataAsync(key);
return(true);
}
catch
{
return(false);
}
}
public async Task <bool> UpdateProspectSearchDataAsync(ProspectSearchCriteria prospectSearchCriteria)
{
try
{
CloudTable table = GetTableManager(TABLENAME);
prospectSearchCriteria.ETag = "*";
TableOperation updateOperation = TableOperation.Replace(prospectSearchCriteria);
await table.ExecuteAsync(updateOperation);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <bool> CreateProspectSearchDataAsync(ProspectSearchCriteria prospectSearchCriteria)
{
try
{
CloudTable table = GetTableManager(TABLENAME);
prospectSearchCriteria.PartitionKey = "Prospects";
prospectSearchCriteria.RowKey = Guid.NewGuid().ToString();
TableOperation insertOperation = TableOperation.Insert(prospectSearchCriteria);
await table.ExecuteAsync(insertOperation);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <ActionResult> EditAsync(ProspectSearchCriteria prospectSearchCriteria)
{
IDataAccess dataAccess = DataAccess.GetInstance();
ProspectSearchCriteria existingProspectSearchCriteria = await dataAccess.GetProspectSearchCriteriaAsync(prospectSearchCriteria);
if (existingProspectSearchCriteria != null)
{
ModelState.AddModelError("SearchString", "Combination of Prospect Name and Search String already exist.");
}
if (ModelState.IsValid)
{
await dataAccess.UpdateProspectSearchData(prospectSearchCriteria);
return(RedirectToAction("Index"));
}
return(View(prospectSearchCriteria));
}
public async Task DeleteProspectSearchDataAsync(string rowKey)
{
try
{
CloudTable table = GetTableManager(TABLENAME);
string query = "RowKey eq '" + rowKey + "'";
IEnumerable <ProspectSearchCriteria> prospectSearchCriteriaList = await retrieveProspectSearchCriteriaDetails(query);
if (prospectSearchCriteriaList != null && prospectSearchCriteriaList.Count() > 0)
{
ProspectSearchCriteria prospectSearchCriteria = prospectSearchCriteriaList.FirstOrDefault();
TableOperation deleteOperation = TableOperation.Delete(prospectSearchCriteria);
await table.ExecuteAsync(deleteOperation);
}
}
catch (StorageException StorageExceptionObj)
{
throw StorageExceptionObj;
}
catch (Exception ExceptionObj)
{
throw ExceptionObj;
}
}
public async Task <IEnumerable <ProspectSearchCriteria> > GetExisitingProspectSearchCriteriaAsync(ProspectSearchCriteria prospectSearchCriteria)
{
try
{
string query = string.Empty;
if (prospectSearchCriteria != null)
{
query = "RowKey ne '" + prospectSearchCriteria.RowKey + "' and ProspectName eq '" + prospectSearchCriteria.ProspectName +
"' and SearchString eq '" + prospectSearchCriteria.SearchString + "'";
}
IEnumerable <ProspectSearchCriteria> prospectSearchCriteriaList = await retrieveProspectSearchCriteriaDetails(query);
return(prospectSearchCriteriaList);
}
catch
{
return(null);
}
}
public async Task <IEnumerable <ProspectSearchCriteria> > GetExisitingProspectSearchCriteriaAsync(ProspectSearchCriteria prospectSearchCriteria)
{
Expression <Func <ProspectSearchCriteria, bool> > predicate = null;
IDocumentQuery <ProspectSearchCriteria> query = null;
if (prospectSearchCriteria != null)
{
predicate = (p => p.ProspectName.ToLower() == prospectSearchCriteria.ProspectName.ToLower() &&
p.SearchString.ToLower() == prospectSearchCriteria.SearchString.ToLower() && p.Id != prospectSearchCriteria.Id);
query = client.CreateDocumentQuery <ProspectSearchCriteria>(
UriFactory.CreateDocumentCollectionUri(DatabaseId, CollectionId),
new FeedOptions {
MaxItemCount = -1, EnableCrossPartitionQuery = true
})
.Where(predicate)
.AsDocumentQuery();
}
else
{
query = client.CreateDocumentQuery <ProspectSearchCriteria>(
UriFactory.CreateDocumentCollectionUri(DatabaseId, CollectionId),
new FeedOptions {
MaxItemCount = -1, EnableCrossPartitionQuery = true
})
.AsDocumentQuery();
}
List <ProspectSearchCriteria> results = new List <ProspectSearchCriteria>();
while (query.HasMoreResults)
{
results.AddRange(await query.ExecuteNextAsync <ProspectSearchCriteria>());
}
return(results);
}
public async Task <IEnumerable <ProspectSearchCriteria> > GetExisitingProspectSearchCriteriaAsync(ProspectSearchCriteria prospectSearchCriteria)
{
Expression <Func <ProspectDataSearchCriteria, bool> > predicate = null;
IEnumerable <ProspectDataSearchCriteria> prospectDataSearchCriteria = null;
if (prospectSearchCriteria != null)
{
predicate = (p => p.ProspectName.ToLower() == prospectSearchCriteria.ProspectName.ToLower() &&
p.SearchString.ToLower() == prospectSearchCriteria.SearchString.ToLower() && p.Id != prospectSearchCriteria.Id);
prospectDataSearchCriteria = await prospectDBContext.ProspectDataSearchCriterias.Where(predicate).ToListAsync <ProspectDataSearchCriteria>();
}
else
{
prospectDataSearchCriteria = await prospectDBContext.ProspectDataSearchCriterias.ToListAsync <ProspectDataSearchCriteria>();
}
IEnumerable <ProspectSearchCriteria> prospectSearchCriteriaList = Mapper.Map <IEnumerable <ProspectDataSearchCriteria>, IEnumerable <ProspectSearchCriteria> >(prospectDataSearchCriteria);
return(prospectSearchCriteriaList.AsQueryable());
}
