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); }
private static Subscription TransformSubscription(PersistenceStorage.Subscription subscription) { Subscription subscription_ = new Subscription(); subscription_.Id = subscription.ID; subscription_.Type = subscription.Type; subscription_.AccessKey = subscription.AccessKey; subscription_.SecretKey = subscription.SecretKey; subscription_.State = subscription.State; subscription_.CreatedDate = subscription.CreatedDate; if ((subscription.SubscriptionItem != null) && (subscription.SubscriptionItem.Count > 0)) { subscription_.Items = TransformSubscriptionItems(subscription.SubscriptionItem); } return(subscription_); }
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); }