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