public object ListOne(string IntermediaryCode) { SubscriptionsResponse bdr = new SubscriptionsResponse(); try { using (var context = new DepContextSC()) { var parameters = new[] { new SqlParameter("@IntermediaryCode", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = IntermediaryCode } }; bdr.subscriptiondata = context.SubscriptionsFull.FromSqlRaw <SubscriptionsFull>("SP_ListSubscriptions @IntermediaryCode", parameters).ToList(); } } catch (Exception e) { Serilog.Log.Information("ListSubscriptionsError: " + e.Message); bdr.error = e.Message; //throw new Exception(); } return(bdr); }
public IEnumerable <Subscriptions> ListAll() { SubscriptionsResponse bdr = new SubscriptionsResponse(); using (var context = new DepContextSC()) { return(context.Subscriptions.Where(sub => sub.Status != "active").ToList()); } }
public object UpdateSubscriptions(int SubscriptionID, [FromBody] SubscriptionsRequest bus) { SubscriptionsResponse bdr = new SubscriptionsResponse(); try { using (var context = new DepContextSC()) { string tokenforCall = ""; Subscriptions bd = context.Subscriptions.Where(bus => bus.Id == SubscriptionID).FirstOrDefault(); bd.Serviceid = bus.Serviceid; bd.IntermediaryCode = bus.IntermediaryCode; bd.Status = bus.Status; context.SaveChanges(); if (bd.Status.ToLower() != "active") { if (context.TempCache.Any(o => o.keyitem == "notificationtoken")) { TempCache scr = context.TempCache.Where(bus => bus.keyitem == "notificationtoken").FirstOrDefault(); tokenforCall = scr.valueitem; } else { tokenforCall = GetNewNotificationToken(); }; string msg = "A subscription status was changed - IntermediaryCode: " + bd.IntermediaryCode + " with ServiceID: " + bd.Serviceid.ToString(); if (SendEmailNotification(tokenforCall, msg, "Subscription cancellation") == "valadationfail") { tokenforCall = GetNewNotificationToken(); SendEmailNotification(tokenforCall, msg, "Subscription cancellation"); } ; } bdr.subscriptiondata = context.Subscriptions.Where(bus => bus.Id == SubscriptionID).ToList(); } } catch (Exception e) { Serilog.Log.Information("UpdateSubscriptionsError: " + e.Message); bdr.error = e.Message; // throw new Exception(); } return(bdr); }
public SubscriptionsResponse GetSubscriptions() { var result = new SubscriptionsResponse(); var request = CreateCoreRequest("getsubscriptions"); request.Params.Add("session", SessionID); result.RequestTime = DateTime.Now; var response = request.GetResponse(); result.ResponseTime = DateTime.Now; result.Parse(response); return(result); }