public AzureStoreSubscription[] GetAzureStoreSubscriptionsByEmail(string email) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return(AccountDataProvider.RetryPolicy.ExecuteAction <AzureStoreSubscription[]>(() => { return context.AzureStoreSubscriptions.Where(subscription => subscription.nvc_Email == email).ToArray(); })); } }
public AzureStoreSubscription GetAzureStoreSubscriptionBySubscriptionId(string subscriptionId) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return(AccountDataProvider.RetryPolicy.ExecuteAction <AzureStoreSubscription>(() => { return context.AzureStoreSubscriptions.FirstOrDefault(subscription => subscription.nvc_SubscriptionId == subscriptionId); })); } }
public void DeleteAzureStoreResource(AzureStoreResource resource) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { context.AzureStoreResources.Attach(resource); context.AzureStoreResources.Remove(resource); AccountDataProvider.RetryPolicy.ExecuteAction(() => { context.SaveChanges(); }); } }
public AzureStoreResource[] GetAzureStoreResources(string subscriptionId, string cloudServiceName) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return(AccountDataProvider.RetryPolicy.ExecuteAction <AzureStoreResource[]>(() => { return context.AzureStoreResources.Where(subscription => subscription.nvc_SubscriptionId == subscriptionId && subscription.nvc_CloudServiceName == cloudServiceName ).ToArray(); })); } }
public AzureStoreResource GetAzureStoreResource(string subscriptionId, string cloudServiceName, string resourceType, string resourceName) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return(AccountDataProvider.RetryPolicy.ExecuteAction <AzureStoreResource>(() => { return context.AzureStoreResources.FirstOrDefault(subscription => subscription.nvc_SubscriptionId == subscriptionId && subscription.nvc_CloudServiceName == cloudServiceName && subscription.nvc_ResourceType == resourceType && subscription.nvc_ResourceName == resourceName ); })); } }
public void CreateOrUpdateAzureStoreResource(AzureStoreResource resource) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { if (resource.id_AzureStoreResourceId == Guid.Empty) { context.Entry(resource).State = EntityState.Added; resource.dt_CreatedTime = DateTime.UtcNow; resource.dt_ChangedTime = DateTime.UtcNow; } else { context.Entry(resource).State = EntityState.Modified; resource.dt_ChangedTime = DateTime.UtcNow; } AccountDataProvider.RetryPolicy.ExecuteAction(() => { context.SaveChanges(); }); } }
public void CreateOrUpdateAzureStoreSubscription(AzureStoreSubscription subscription) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { if (subscription.id_AzureStoreSubscriptionId == Guid.Empty) { context.Entry(subscription).State = EntityState.Added; subscription.dt_CreatedTime = DateTime.UtcNow; subscription.dt_ChangedTime = DateTime.UtcNow; } else { context.Entry(subscription).State = EntityState.Modified; subscription.dt_ChangedTime = DateTime.UtcNow; } AccountDataProvider.RetryPolicy.ExecuteAction(() => { context.SaveChanges(); }); } }
public AzureStoreSubscription[] GetAzureStoreSubscriptionsByEmail(string email) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return AccountDataProvider.RetryPolicy.ExecuteAction<AzureStoreSubscription[]>(() => { return context.AzureStoreSubscriptions.Where(subscription => subscription.nvc_Email == email).ToArray(); }); } }
public AzureStoreSubscription GetAzureStoreSubscriptionBySubscriptionId(string subscriptionId) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return AccountDataProvider.RetryPolicy.ExecuteAction<AzureStoreSubscription>(() => { return context.AzureStoreSubscriptions.FirstOrDefault(subscription => subscription.nvc_SubscriptionId == subscriptionId); }); } }
public AzureStoreResource[] GetAzureStoreResources(string subscriptionId, string cloudServiceName) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return AccountDataProvider.RetryPolicy.ExecuteAction<AzureStoreResource[]>(() => { return context.AzureStoreResources.Where(subscription => subscription.nvc_SubscriptionId == subscriptionId && subscription.nvc_CloudServiceName == cloudServiceName ).ToArray(); }); } }
public AzureStoreResource GetAzureStoreResource(string subscriptionId, string cloudServiceName, string resourceType, string resourceName) { using (AccountDataContext context = new AccountDataContext(ConfigurationDataProvider.AccountDataProviderConnectionString)) { return AccountDataProvider.RetryPolicy.ExecuteAction<AzureStoreResource>(() => { return context.AzureStoreResources.FirstOrDefault(subscription => subscription.nvc_SubscriptionId == subscriptionId && subscription.nvc_CloudServiceName == cloudServiceName && subscription.nvc_ResourceType == resourceType && subscription.nvc_ResourceName == resourceName ); }); } }