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