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