Work Performance

Jassim Rahma

Hi, How can I have a regex for my .NET app's user password with the following: Password MUST be a minimum of 10 AND maximum of 50 It should NOT contain space. It should be MIXED alphabet (upper + lower), numeric and following special characters !@#$%^&*-_+=~ Thanks, Jassim

www.softnames.com

Jassim Rahma

oh sorry how do I open it again?

www.softnames.com

Jassim Rahma

Hi, Why my question was closed here? [[Grabbing website title is too slow](https://www.codeproject.com/Questions/5259657/Grabbing-website-title-is-too-slow)](https://www.codeproject.com/Questions/5259657/Grabbing-website-title-is-too-slow) Thanks, Jassim

www.softnames.com

Jassim Rahma

Yes Yes Yes Thank you so much

www.softnames.com

Jassim Rahma

double bearing4 = (-1.779406909 + 2 * Math.PI) % Math.PI;

It returns 1.362 which is different that Excel

www.softnames.com

Jassim Rahma

I tried that.. Excel returns 4.503778398 This is the figure I am trying to achieve But... double bearing4 = Math.Floor(-1.7794 / (2 * Math.PI)); returns -1 and this: double bearing4 = -1.779406909 % (2 * Math.PI); returns: -1.779406909

www.softnames.com

Jassim Rahma

How can I do this Excel's MOD formula in C#:

=MOD(-1.779406909, 2 * PI())

Thanks, Jassim

www.softnames.com

Jassim Rahma

Hi, I am using Syncfusion in my project and I am showing this ListView:

Jassim Rahma

I have a webhook from fastSpring. The webhook sends something like below and I want to know how can I create a webhook listener to use the inflammation passed by the webhook? How can I create the listener to capture below information please?

{
"order":"yzaP3EQAQtCOBLhYP2ZN-Q",
"id":"yzaP3EQAQtCOBLhYP2ZN-Q",
"reference":"MyDomain190418-3737-54184",
"buyerReference":null,
"completed":true,
"changed":1555598658633,
"changedValue":1555598658633,
"changedInSeconds":1555598658,
"changedDisplay":"4/18/19",
"language":"en",
"live":false,
"currency":"USD",
"payoutCurrency":"USD",
"invoiceUrl":"https://MyDomain.test.onfastspring.com/account/order/MyDomain190418-3737-54184/invoice",
"account":{
"id":"qjY3pex6TH6rj6A2f71vVg",
"account":"qjY3pex6TH6rj6A2f71vVg",
"contact":{
"first":"Jassim",
"last":"Al Rahma",
"email":"myemail@gmail.com",
"company":null,
"phone":"123456789"
},
"language":"en",
"country":"AE",
"lookup":{
"global":"XNpsaeO3QLO906bY9HcusA"
},
"url":"https://MyDomain.test.onfastspring.com/account"
},
"total":29.99,
"totalDisplay":"USD 29.99",
"totalInPayoutCurrency":29.99,
"totalInPayoutCurrencyDisplay":"USD 29.99",
"tax":0.0,
"taxDisplay":"USD 0.00",
"taxInPayoutCurrency":0.0,
"taxInPayoutCurrencyDisplay":"USD 0.00",
"subtotal":29.99,
"subtotalDisplay":"USD 29.99",
"subtotalInPayoutCurrency":29.99,
"subtotalInPayoutCurrencyDisplay":"USD 29.99",
"discount":0.0,
"discountDisplay":"USD 0.00",
"discountInPayoutCurrency":0.0,
"discountInPayoutCurrencyDisplay":"USD 0.00",
"discountWithTax":0.0,
"discountWithTaxDisplay":"USD 0.00",
"discountWithTaxInPayoutCurrency":0.0,
"discountWithTaxInPayoutCurrencyDisplay":"USD 0.00",
"billDescriptor":"FS* fsprg.com",
"payment":{
"type":"test",
"cardEnding":"4242"
},
"customer":{
"first":"Jassim",
"last":"Al Rahma",
"email":"myemail@gmail.com",
"company":null,
"phone":"123456789"
},
"address":{
"country":"AE",
"display":"AE"
},
"r

Jassim Rahma

Hi, I have a web project for customers database which will send bulk emails twice a week. Most of hosting won't allow that because I have around 35,000 emails (increasing) to be sent every time. Which web hosting you recommend for this? what's your advise? Thanks, [Jassim](https://www.softnames.com)

www.softnames.com

Jassim Rahma

Hi, I have the following SQL:

SELECT customers_address.customer_address_id, address_category.address_category_name, customers_address.address_name,
address_details.address_details_id,
address_details.address_details_text
FROM customers_address
JOIN address_category ON address_category.address_category_id = customers_address.address_category_id
LEFT JOIN address_details ON address_details.customer_address_id = customers_address.customer_address_id
WHERE customer_id = param_customer;

I want to show this output in JSON:

CustomerAddress:
{
customer_address_id
address_category_name
address_name
}
Details:
{
address_details_id
address_details_text
}

my current php is:

$mysql_query = $mysql_connection->prepare('CALL sp_populate_customer_addresses(:param_customer)');
$mysql_query->bindParam(':param_customer', $customer_id, PDO::PARAM_STR);
$mysql_query->execute();

if ($mysql_query->rowCount() <= 0) { echo "false"; }
else
{
$jsonData = array();

while($mysql_row = $mysql_query->fetch())
{
$jsonData[] = $mysql_row;
}

echo json\_encode($jsonData);

}

Thanks, [Jassim](https://www.softnames.com)

Technology News @ www.JassimRahma.com

Jassim Rahma

Hi, I am developing a mobile app and need to have PHP webservice for it to return JSON result. If I am going to make the service and copy it on my host then connect to it then I will achieve what I want but how about the security of the webservice? and how can I make sure it won't be indexed in Google and also how can I make sure no one will be able to access it with a kind of security? Kindly advise... Thanks, [Jassim](https://www.softnames.com)

Technology News @ www.JassimRahma.com

Jassim Rahma

I tried below code but getting: SELECT is not an array although my html output is showing correct result like this:

Work Performance

Efficient execution of duties.

    <select name="cboRating\[4613\]" id="cboRating\[4613\]" data-native-menu="false" required>
        <option value="">\[Select..\]</option>
                    <option value="1">Outstanding</option>
                    <option value="2">Exceeds Expectations</option>
                    <option value="3">Meets Expectations</option>
                    <option value="4">Needs Improvement</option>
                    <option value="5">Unsatisfactory</option>
                </select>

Technical Knowledge and Skill

Mastery of job knowledge and skills required to perform the duties of the position.

    <select name="cboRating\[4614\]" id="cboRating\[4614\]" data-native-menu="false" required>
        <option value="">\[Select..\]</option>
                    <option value="1">Outstanding</option>
                    <option value="2">Exceeds Expectations</option>
                    <option value="3">Meets Expectations</option>
                    <option value="4">Needs Improvement</option>
                    <option value="5">Unsatisfactory</option>
                </select>

here is my code:

if (is_array( $_POST['cboRating']))
{
foreach($_POST['cboRating'] as $key=>$value)
{
echo "Key : " . $key . "

";
echo "value : " . $value . "

";
}
}
else
{
echo "SELECT is not an array";
}

Technology News @ www.JassimRahma.com

Jassim Rahma

Hi, I have employee evaluation for and it's populating the data from database and for every element of the evaluation there is a to choose the employee rating. I want to know how can I implement this? How to name it? will all have same name? here is my code: prepare('CALL sp_web_get_employee_evaluation_elements_by_guid(:param_employee_evaluation_guid)'); $mysql_query->bindParam(':param_employee_evaluation_guid', $evaluation_guid, PDO::PARAM_STR); $mysql_query->execute(); if ($mysql_query->rowCount() <= 0) { exit(header("Location: index.php")); } while($mysql_row = $mysql_query->fetch()) { ?> ID: Element Rating : <select name="cboRating" id="cboRating" data-native-menu="false" required> <option value="">[Select..]</option> prepare($mysql_rating_category_command); $mysql_rating_category_query->execute(); while($mysql_rating_category_row = $mysql_rating_category_query->fetch()) { ?> <option value=""></option> </select> Thanks, [Jassim](https://www.softnames.com) Technology News @ www.JassimRahma.com

Jassim Rahma

In employees table: 1. employee_number 2. first_name 3. last_name In employee_job 1. employee_number 2. reporting_to (refers to employees->employee_number)

Technology News @ www.JassimRahma.com

Jassim Rahma

Hi, I have a Marketing & Sales Director, the Marketing & Sales Director has one Marketing Manager and Sales Manager reporting to him. The Sales Manager has two Sales Executives and the Marketing Manager has two Marketing coordinators reporting to them. I can make a SELECT to list staff reporting to the Sales Manager and staff reporting to the Marketing Manager. I can also make a SELECT to list staff reporting to the Marketing & Sales Director (which are Marketing Manager and Sales Manager). Now I want to make a SELECT to list all staff reporting directly on indirectly to the Marketing & Sales Director including staff reporting to managers under the Marketing & Sales Director so the query should list the below when I query for staff reporting to the Marketing & Sales Director: 1. Marketing Manager 2. Sales Manager 3. Sales Executive 1 4. Sales Executive 2 5. Marketing Coordinator 1 6. Marketing Coordinator 2 How can I do this please? Thanks, Jassim[^]

Technology News @ www.JassimRahma.com

Jassim Rahma

how can I convert this to MySQL's PL/SQL?

Technology News @ www.JassimRahma.com

Jassim Rahma

I tried:

CALL sp_populate_memo_country_companies("BH, US")

but returns no rows when BH alone returns 5 rows.

Technology News @ www.JassimRahma.com

Jassim Rahma

this part:

CREATE DEFINER=`root`@`127.0.0.1` PROCEDURE `sp_populate_memo_country_companies`(IN param_country varchar(255))

there is only argument which is param_country which I am passing but maybe in the wrong way.. I mean in my above case, how can I pass an IN parameter for:

WHERE country_code IN (param_country)

Technology News @ www.JassimRahma.com

Jassim Rahma

It's northing to do with param_country because I am getting the problem when I run the stored procedure on MySQL Server console as well (without any C#) For example, if I run:

CALL sp_populate_memo_country_companies("BH")

it works fine but when I run:

CALL sp_populate_memo_country_companies("BH", "US")

I get:

[SQL] CALL sp_populate_memo_country_companies("BH", "US")

[Err] 1318 - Incorrect number of arguments for PROCEDURE bluefile.sp_populate_memo_country_companies; expected 1, got 2

Technology News @ www.JassimRahma.com

Jassim Rahma

Posts

Work Performance

Technical Knowledge and Skill