public IAlertsDalRemoveAccountSubscrResult RemoveAlertSubscription(IAlertsDalRemoveAccountSubscrParams remSubscrParams)
{
IAlertsDalRemoveAccountSubscrResult result = new MSSQL.AlertsDalRemoveAccountSubscrResult();
string spName = "[SP_Remove_Account_Subscription]";
SqlConnection conn = OpenConnection(connName);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = schema + "." + spName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
try
{
if (remSubscrParams.SubscriptionIds != null)
{
foreach (var id in remSubscrParams.SubscriptionIds)
{
cmd.Parameters.Clear();
SqlParameter paramId = new SqlParameter("@Alert_Subscription_Id", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, id);
cmd.Parameters.Add(paramId);
cmd.ExecuteNonQuery();
}
}
result.Success = true;
}
catch (Exception ex)
{
result.Success = false;
result.Errors.Add(new Interfaces.Error()
{
Code = Interfaces.EErrorCodes.AlertsSourceFail,
Type = Interfaces.EErrorType.Error,
Message = ex.Message
});
}
conn.Close();
return(result);
}
public void RemoveAlertSubscription_Success()
{
RunInitSql("030.RemoveAccountSubscription_Success", _conn);
IAlertsDal dal = PrepareAlertsDal();
IAlertsDalGetAccountSubscriptionsParams getGetSubsParams = dal.CreateGetAccountSubscrParams();
getGetSubsParams.AccountKey = ConfigurationManager.AppSettings["AccountKey"];
var getSubsResult = dal.GetAccountSubscriptions(getGetSubsParams);
IAlertsDalRemoveAccountSubscrParams remSubParam = dal.CreateRemoveAccountSubscrParams();
remSubParam.SubscriptionIds.Add(getSubsResult.Subscriptions[0].Id);
IAlertsDalRemoveAccountSubscrResult updSubsResult = dal.RemoveAlertSubscription(remSubParam);
RunFinalizeSql("030.RemoveAccountSubscription_Success", _conn);
Assert.IsTrue(updSubsResult.Success);
}
