public static async Task <bool> IsEmployeeExists(string empNum, CosmosDBRepository <User> client) { var results = await client.GetItemsAsync((u) => u.AccountId == empNum && u.AccountType == "Employee" && u.IsActive); if (results.Count() > 0) { return(true); } return(false); }
public static async Task <User> GetEmployeeById(string empId, CosmosDBRepository <User> client) { var results = await client.GetItemsAsync((u) => u.Id == empId && u.AccountType == "Employee" && u.IsActive); if (results.Count() > 0) { return(results.ElementAt(0)); } return(null); }
private async Task <ODMWorkspace> GetOrCreateWorkspaceAsync(string ownerId) { List <ODMWorkspace> workspaceLockup = await workspaceRepo.GetItemsAsync(x => x.OwnerId == ownerId) as List <ODMWorkspace>; //No workspace found for OwnerId if (workspaceLockup.Count == 0) { activeWorkspace = await CreateWorkspaceAsync(ownerId, new ModelPolicy()); } else { //TODO: Add logic to handle multiple workspaces for same owner. for now only a single workspace for owner is supported. activeWorkspace = workspaceLockup[0]; } filesBlobContainer = new AzureBlobStorageRepository(blobStorageName, blobStorageKey, activeWorkspace.FilesCotainerUri); modelsBlobContainer = new AzureBlobStorageRepository(blobStorageName, blobStorageKey, activeWorkspace.ModelCotainerUri); return(activeWorkspace); }
public async Task <IActionResult> Search([FromQuery] string q) { if (string.IsNullOrEmpty(q)) { return(BadRequest()); } var querySql = this.context.GenerateQuery(q).Trim(); var result = await repository.GetItemsAsync(querySql); return(Ok(result)); }
public static async Task <string> Run( [HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req, ILogger log) { // Get CosmosDB Connection var Repository = new CosmosDBRepository("VMManagement", "VM_Power_State", log); log.LogInformation("RUN-MESSAGE 1 (GW 1103): Got CosmosDB Connection"); // Get CosmosDB Data var CosmosItems = await Repository.GetItemsAsync(); log.LogInformation("RUN-MESSAGE 2: Got CosmosDB Items", CosmosItems); var jsonCosmosItems = JsonConvert.SerializeObject(CosmosItems, Formatting.Indented); return(jsonCosmosItems); }
public static async void Run([TimerTrigger("0/20 * * * * *")] TimerInfo myTimer, ILogger log) { try { // Get Connections var Repository = new CosmosDBRepository("VMManagement", "VM_Power_State", log); var Connection = new AzureConnection("11c4bafa-00bb-43f4-a42d-ed6f2663fbaf", "92c95553-455f-4b53-8bcf-e2dfe4dbcb0b", "A4LbQRKmqT:2x4Iu/h=yM=pDBuu9VVA1", log); log.LogInformation("RUN-MESSAGE 1 (AW 0903): Got Connections"); // Get Data var CosmosItems = await Repository.GetItemsAsync(); log.LogInformation($"RUN-MESSAGE 2: Got {CosmosItems.Count} items from CosmosDB."); var AzureMachines = Connection.VirtualMachines; log.LogInformation($"RUN-MESSAGE 3: Got {AzureMachines.Count} items from Azure VMs."); // Check if any data needs updating var toBeUpdated = CompareItems(CosmosItems, AzureMachines, log); if (toBeUpdated.Any()) { log.LogInformation($"RUN-MESSAGE 5: Got {toBeUpdated.Count} items to be updated."); foreach (var cosmosItem in toBeUpdated) { // Update any data requiring updates await Repository.UpdateItemAsync(cosmosItem); } } } catch (Exception ex) { log.LogError(ex, $"ERROR-RUN in Function. Message: {ex.Message}; InnerException: {ex.InnerException}"); } }
private void FillInitialData() { DoctorManager doctorManager; PatientManager patientManager; var list = _doctorContext.GetItemsAsync(y => y.Name != "").Result.ToList(); if (list.Count < 3) { doctorManager = new DoctorManager(_doctorContext); var x = doctorManager.CreateAsync(new Doctor() { Name = "Mikael Seström", Email = "*****@*****.**", ItemId = "201012-1425", Speciality = new Speciality() { Id = "3", Name = "Clinical radiology" }, Description = "" }); x = doctorManager.CreateAsync(new Doctor() { Name = "Carina Axel", Email = "*****@*****.**", ItemId = "200911-1758", Speciality = new Speciality() { Id = "2", Name = "Anaesthesia" }, Description = "" }); x = doctorManager.CreateAsync(new Doctor() { Name = "Martin Eriksson", Email = "*****@*****.**", ItemId = "199005-1875", Speciality = new Speciality() { Id = "1", Name = "Clinical oncology" }, Description = "" }); } var list2 = _patientContext.GetItemsAsync(y => y.Name != "").Result.ToList(); if (list2.Count < 3) { patientManager = new PatientManager(_patientContext); var x = patientManager.CreateAsync(new Patient() { Name = "Henrik Karlsson", Email = "*****@*****.**", ItemId = "19860813-1111", Address = new Address() { ItemId = "111", ZipCode = "121211" }, Description = "" }); x = patientManager.CreateAsync(new Patient() { Name = "Erik Henriksson", Email = "*****@*****.**", ItemId = "19750612-2222", Address = new Address() { ItemId = "112", ZipCode = "121211" }, Description = "" }); x = patientManager.CreateAsync(new Patient() { Name = "Cecilia Eliasson", Email = "*****@*****.**", ItemId = "19600519-3333", Address = new Address() { ItemId = "113", ZipCode = "122122" }, Description = "" }); } }
public async Task <IEnumerable <Book> > Get() { var result = await CosmosDBRepository <Book> .GetItemsAsync(CollectionId); return(result); }