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