public CcGetSubscriptionResponse GetSubscription(CcGetSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
CcGetSubscriptionResponse response = new CcGetSubscriptionResponse();
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.SubscriptionId).FirstOrDefault();
if (subscription != null)
{
Subscription subscription_ = TransformSubscription(subscription);
response.Subscription = subscription_;
}
return response;
}
public CcQuerySubscriptionsResponse QuerySubscriptions(CcQuerySubscriptionsRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
CcQuerySubscriptionsResponse response = new CcQuerySubscriptionsResponse();
List<Subscription> list = new List<Subscription>();
foreach (PersistenceStorage.Subscription item in context.Subscription)
{
list.Add(TransformSubscription(item));
}
response.Subscriptions = list;
return response;
}
public CcGetSubscriptionResponse GetSubscription(CcGetSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
CcGetSubscriptionResponse response = new CcGetSubscriptionResponse();
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.SubscriptionId).FirstOrDefault();
if (subscription != null)
{
Subscription subscription_ = TransformSubscription(subscription);
response.Subscription = subscription_;
}
return(response);
}
public CcQuerySubscriptionsResponse QuerySubscriptions(CcQuerySubscriptionsRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
CcQuerySubscriptionsResponse response = new CcQuerySubscriptionsResponse();
List <Subscription> list = new List <Subscription>();
foreach (PersistenceStorage.Subscription item in context.Subscription)
{
list.Add(TransformSubscription(item));
}
response.Subscriptions = list;
return(response);
}
public CcRemoveSubscriptionResponse RemoveSubscription(CcRemoveSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.SubscriptionId).FirstOrDefault();
if (subscription != null)
{
context.Subscription.DeleteOnSubmit(subscription);
context.SubmitChanges();
}
CcRemoveSubscriptionResponse response = new CcRemoveSubscriptionResponse();
return(response);
}
public CcAddSubscriptionResponse AddSubscription(CcAddSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = new PersistenceStorage.Subscription();
subscription.Type = request.Subscription.Type;
subscription.AccessKey = request.Subscription.AccessKey;
subscription.SecretKey = request.Subscription.SecretKey;
subscription.State = request.Subscription.State;
subscription.CreatedDate = request.Subscription.CreatedDate;
List<PersistenceStorage.SubscriptionItem> items = TransformSubscriptionItems(request.Subscription.Items);
subscription.SubscriptionItem.AddRange(items);
context.Subscription.InsertOnSubmit(subscription);
context.SubmitChanges();
CcAddSubscriptionResponse response = new CcAddSubscriptionResponse();
return response;
}
public CcUpdateSubscriptionResponse UpdateSubscription(CcUpdateSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.Subscription.Id).FirstOrDefault();
if (subscription != null)
{
subscription.Type = request.Subscription.Type;
subscription.AccessKey = request.Subscription.AccessKey;
subscription.SecretKey = request.Subscription.SecretKey;
subscription.State = request.Subscription.State;
subscription.CreatedDate = request.Subscription.CreatedDate;
context.SubmitChanges();
}
CcUpdateSubscriptionResponse response = new CcUpdateSubscriptionResponse();
return(response);
}
public CcAddSubscriptionResponse AddSubscription(CcAddSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = new PersistenceStorage.Subscription();
subscription.Type = request.Subscription.Type;
subscription.AccessKey = request.Subscription.AccessKey;
subscription.SecretKey = request.Subscription.SecretKey;
subscription.State = request.Subscription.State;
subscription.CreatedDate = request.Subscription.CreatedDate;
List <PersistenceStorage.SubscriptionItem> items = TransformSubscriptionItems(request.Subscription.Items);
subscription.SubscriptionItem.AddRange(items);
context.Subscription.InsertOnSubmit(subscription);
context.SubmitChanges();
CcAddSubscriptionResponse response = new CcAddSubscriptionResponse();
return(response);
}
public CcRemoveSubscriptionResponse RemoveSubscription(CcRemoveSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.SubscriptionId).FirstOrDefault();
if (subscription != null)
{
context.Subscription.DeleteOnSubmit(subscription);
context.SubmitChanges();
}
CcRemoveSubscriptionResponse response = new CcRemoveSubscriptionResponse();
return response;
}
public CcUpdateSubscriptionResponse UpdateSubscription(CcUpdateSubscriptionRequest request)
{
var connection = new SqliteConnection(Settings.SQLiteConnectionString);
PersistenceStorage.PersistentDataContext context = new PersistenceStorage.PersistentDataContext(connection);
PersistenceStorage.Subscription subscription = context.Subscription.Where(x => x.ID == request.Subscription.Id).FirstOrDefault();
if (subscription != null)
{
subscription.Type = request.Subscription.Type;
subscription.AccessKey = request.Subscription.AccessKey;
subscription.SecretKey = request.Subscription.SecretKey;
subscription.State = request.Subscription.State;
subscription.CreatedDate = request.Subscription.CreatedDate;
context.SubmitChanges();
}
CcUpdateSubscriptionResponse response = new CcUpdateSubscriptionResponse();
return response;
}
