public static bool InsertSubscriber(InsertSubscriberRequest request)
{
Service client = new Service();
bool response = client.InsertSubscriber(request);
return(response);
}
public static bool InsertSubscriber(InsertSubscriberRequest request)
{
bool result = false;
using (SqlConnection con = new SqlConnection(Variables.PaymentSystemDBConnection))
{
try
{
con.Open();
using (SqlCommand cmd = new SqlCommand(SQLConstants.SP_INSERT_SUBSCRIBER, con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SUBSCRIBER_TYPE_ID", request.SubscriberTypeId);
cmd.Parameters.AddWithValue("@IDENTIFICATION_TAX_NUMBER", request.IdentificationTaxNumber);
cmd.Parameters.AddWithValue("@USER_PASSWORD", request.UserPassword);
cmd.Parameters.AddWithValue("@NAME", request.Name);
cmd.Parameters.AddWithValue("@SURNAME", request.Surname);
cmd.Parameters.AddWithValue("@SUBSCRIPTION_ID", request.SubscriptionId);
cmd.Parameters.AddWithValue("@INSERT_USER", request.InsertUser);
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 InsertSubscriber(InsertSubscriberRequest request)
{
return(DBLayer.InsertSubscriber(request));
}
