public static function PasswordRecovery_Execute()
 {
     $response = new WebServiceClass();
     try {
         $parameters = WebServiceClass::collectParameters();
         $account = da_account::GetAccountByID($parameters->AccountID);
         if ($account != NULL) {
             if ($account->email != "" && $parameters->Email == $account->email) {
                 if ($account->confirmation_guid == $parameters->ConfirmationCode) {
                     $accountModificationTime = new DateTime($account->modified_datetime);
                     $currentDateTime = new DateTime(DA_Helper::GetServerDate());
                     $difference = $currentDateTime->diff($accountModificationTime);
                     if ($difference->d == 0) {
                         $account->pwd_hash = sha1($parameters->Password);
                         $savedAccount = da_account::UpdateAccount($account);
                         if ($savedAccount != NULL && $savedAccount->account_id == $account->account_id) {
                             $response->status = "OK";
                             $response->message = "Contraseña Actualizada Satisfactoriamente";
                             WebServiceClass::sendPWRecoveryEmail($account);
                         } else {
                             $response->status = "ERROR";
                             $response->message = "Solicitud Inválida";
                         }
                     } else {
                         $response->status = "ERROR";
                         $response->message = "Solicitud Expirada";
                     }
                 } else {
                     $response->status = "ERROR";
                     $response->message = "Solicitud Inválida";
                 }
             } else {
                 $response->status = "ERROR";
                 $response->message = "Solicitud Inválida";
             }
         } else {
             $response->status = "ERROR";
             $response->message = "Solicitud Inválida";
         }
     } catch (Exception $ex) {
         $response->status = "EXCEPTION";
         $response->message = $ex->getMessage();
     }
     return $response;
 }
 /**
  * 
  * @param be_generic_value_entry $valueEntry
  * @return be_generic_value_entry
  */
 public static function AddNewEntry($valueEntry)
 {
     $created_datetime = DA_Helper::GetServerDate();
     $sqlCommand = "INSERT INTO generic_value_log (" . "app_id," . "value_label," . "value," . "value_type_code," . "captured_datetime," . "created_datetime " . ")" . " VALUES(?,?,?,?,?,?)";
     $mysqli = DA_Helper::mysqli_connect();
     if ($mysqli->connect_errno) {
         echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
     }
     if (!($stmt = $mysqli->prepare($sqlCommand))) {
         echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
     }
     if (!$stmt->bind_param("isssss", $valueEntry->app_id, $valueEntry->value_label, $valueEntry->value, $valueEntry->value_type_code, $valueEntry->captured_datetime, $created_datetime)) {
         echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
     }
     if (!$stmt->execute()) {
         echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
     }
     $insertedID = $mysqli->insert_id;
     $stmt->close();
     $retrievedValue = da_generic_value::GetEntry($insertedID);
     print_r($retrievedValue);
     return $retrievedValue;
 }