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