public static bool CloseSubscription(CloseSubscriptionRequest request)
{
Service client = new Service();
bool response = client.CloseSubscription(request);
return(response);
}
public static bool CloseSubscription(CloseSubscriptionRequest request)
{
bool result = false;
using (SqlConnection con = new SqlConnection(Variables.PaymentSystemDBConnection))
{
try
{
con.Open();
using (SqlCommand cmd = new SqlCommand(SQLConstants.SP_CLOSE_SUBSCRIPTION, con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SUBSCRIBER_ID", request.SubscriberId);
cmd.Parameters.AddWithValue("@UPDATE_USER", request.UpdateUser);
var ReturnParameter = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
ReturnParameter.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
result = Convert.ToInt32(ReturnParameter.Value) == 0 ? false : true;
}
}
catch (Exception ex)
{
throw;
}
}
return(result);
}
public bool CloseSubscription(CloseSubscriptionRequest request)
{
return(DBLayer.CloseSubscription(request));
}
