function AddRow()
{
global $conn, $Language, $Security, $bookpost;
$rsnew = array();
// name
$bookpost->name->SetDbValueDef($rsnew, $bookpost->name->CurrentValue, "", FALSE);
// cata
$bookpost->cata->SetDbValueDef($rsnew, $bookpost->cata->CurrentValue, "", FALSE);
// author
$bookpost->author->SetDbValueDef($rsnew, $bookpost->author->CurrentValue, NULL, FALSE);
// publisher
$bookpost->publisher->SetDbValueDef($rsnew, $bookpost->publisher->CurrentValue, NULL, FALSE);
// info
$bookpost->info->SetDbValueDef($rsnew, $bookpost->info->CurrentValue, "", FALSE);
// code
$bookpost->code->SetDbValueDef($rsnew, $bookpost->code->CurrentValue, NULL, FALSE);
// pic
$bookpost->pic->SetDbValueDef($rsnew, $bookpost->pic->CurrentValue, NULL, FALSE);
// useremail
$bookpost->useremail->SetDbValueDef($rsnew, $bookpost->useremail->CurrentValue, "", FALSE);
// price
$bookpost->price->SetDbValueDef($rsnew, $bookpost->price->CurrentValue, 0, FALSE);
// datatime
$bookpost->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate());
$rsnew['datatime'] =& $bookpost->datatime->DbValue;
// hidden
$bookpost->hidden->SetDbValueDef($rsnew, $bookpost->hidden->CurrentValue, NULL, FALSE);
// Call Row Inserting event
$bInsertRow = $bookpost->Row_Inserting($rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($bookpost->InsertSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($bookpost->CancelMessage != "") {
$this->setMessage($bookpost->CancelMessage);
$bookpost->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
$bookpost->bookid->setDbValue($conn->Insert_ID());
$rsnew['bookid'] = $bookpost->bookid->DbValue;
// Call Row Inserted event
$bookpost->Row_Inserted($rsnew);
}
return $AddRow;
}
function AddRow()
{
global $conn, $Language, $Security, $order;
$rsnew = array();
// bookid
$order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE);
// orderstatus
$order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE);
// email
$order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE);
// datatime
$order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate());
$rsnew['datatime'] =& $order->datatime->DbValue;
// Call Row Inserting event
$bInsertRow = $order->Row_Inserting($rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($order->InsertSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($order->CancelMessage != "") {
$this->setMessage($order->CancelMessage);
$order->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
$order->orderid->setDbValue($conn->Insert_ID());
$rsnew['orderid'] = $order->orderid->DbValue;
// Call Row Inserted event
$order->Row_Inserted($rsnew);
}
return $AddRow;
}
function EditRow()
{
global $conn, $Security, $Language, $userinfo;
$sFilter = $userinfo->KeyFilter();
$userinfo->CurrentFilter = $sFilter;
$sSql = $userinfo->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// email
$userinfo->zemail->SetDbValueDef($rsnew, $userinfo->zemail->CurrentValue, "", FALSE);
// firstname
$userinfo->firstname->SetDbValueDef($rsnew, $userinfo->firstname->CurrentValue, "", FALSE);
// lastname
$userinfo->lastname->SetDbValueDef($rsnew, $userinfo->lastname->CurrentValue, "", FALSE);
// password
$userinfo->password->SetDbValueDef($rsnew, $userinfo->password->CurrentValue, "", FALSE);
// facebook
$userinfo->facebook->SetDbValueDef($rsnew, $userinfo->facebook->CurrentValue, 0, FALSE);
// logintime
$userinfo->logintime->SetDbValueDef($rsnew, ew_CurrentDateTime(), NULL);
$rsnew['logintime'] =& $userinfo->logintime->DbValue;
// block
$userinfo->block->SetDbValueDef($rsnew, $userinfo->block->CurrentValue, NULL, FALSE);
// Call Row Updating event
$bUpdateRow = $userinfo->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$EditRow = $conn->Execute($userinfo->UpdateSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($userinfo->CancelMessage != "") {
$this->setMessage($userinfo->CancelMessage);
$userinfo->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$userinfo->Row_Updated($rsold, $rsnew);
}
$rs->Close();
return $EditRow;
}
function EditRow()
{
global $conn, $Security, $Language, $order;
$sFilter = $order->KeyFilter();
$order->CurrentFilter = $sFilter;
$sSql = $order->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// bookid
$order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE);
// orderstatus
$order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE);
// email
$order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE);
// datatime
$order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate());
$rsnew['datatime'] =& $order->datatime->DbValue;
// Call Row Updating event
$bUpdateRow = $order->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$EditRow = $conn->Execute($order->UpdateSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($order->CancelMessage != "") {
$this->setMessage($order->CancelMessage);
$order->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$order->Row_Updated($rsold, $rsnew);
}
$rs->Close();
return $EditRow;
}
function EditRow()
{
global $conn, $Security, $Language, $bookpost;
$sFilter = $bookpost->KeyFilter();
$bookpost->CurrentFilter = $sFilter;
$sSql = $bookpost->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// name
$bookpost->name->SetDbValueDef($rsnew, $bookpost->name->CurrentValue, "", FALSE);
// cata
$bookpost->cata->SetDbValueDef($rsnew, $bookpost->cata->CurrentValue, "", FALSE);
// author
$bookpost->author->SetDbValueDef($rsnew, $bookpost->author->CurrentValue, NULL, FALSE);
// publisher
$bookpost->publisher->SetDbValueDef($rsnew, $bookpost->publisher->CurrentValue, NULL, FALSE);
// info
$bookpost->info->SetDbValueDef($rsnew, $bookpost->info->CurrentValue, "", FALSE);
// code
$bookpost->code->SetDbValueDef($rsnew, $bookpost->code->CurrentValue, NULL, FALSE);
// pic
$bookpost->pic->SetDbValueDef($rsnew, $bookpost->pic->CurrentValue, NULL, FALSE);
// useremail
$bookpost->useremail->SetDbValueDef($rsnew, $bookpost->useremail->CurrentValue, "", FALSE);
// price
$bookpost->price->SetDbValueDef($rsnew, $bookpost->price->CurrentValue, 0, FALSE);
// datatime
$bookpost->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate());
$rsnew['datatime'] =& $bookpost->datatime->DbValue;
// hidden
$bookpost->hidden->SetDbValueDef($rsnew, $bookpost->hidden->CurrentValue, NULL, FALSE);
// Call Row Updating event
$bUpdateRow = $bookpost->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$EditRow = $conn->Execute($bookpost->UpdateSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($bookpost->CancelMessage != "") {
$this->setMessage($bookpost->CancelMessage);
$bookpost->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$bookpost->Row_Updated($rsold, $rsnew);
}
$rs->Close();
return $EditRow;
}
function AddRow()
{
global $conn, $Language, $Security, $userinfo;
$rsnew = array();
// email
$userinfo->zemail->SetDbValueDef($rsnew, $userinfo->zemail->CurrentValue, "", FALSE);
// firstname
$userinfo->firstname->SetDbValueDef($rsnew, $userinfo->firstname->CurrentValue, "", FALSE);
// lastname
$userinfo->lastname->SetDbValueDef($rsnew, $userinfo->lastname->CurrentValue, "", FALSE);
// password
$userinfo->password->SetDbValueDef($rsnew, $userinfo->password->CurrentValue, "", FALSE);
// facebook
$userinfo->facebook->SetDbValueDef($rsnew, $userinfo->facebook->CurrentValue, 0, TRUE);
// logintime
$userinfo->logintime->SetDbValueDef($rsnew, ew_CurrentDateTime(), NULL);
$rsnew['logintime'] =& $userinfo->logintime->DbValue;
// block
$userinfo->block->SetDbValueDef($rsnew, $userinfo->block->CurrentValue, NULL, FALSE);
// Call Row Inserting event
$bInsertRow = $userinfo->Row_Inserting($rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($userinfo->InsertSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($userinfo->CancelMessage != "") {
$this->setMessage($userinfo->CancelMessage);
$userinfo->CancelMessage = "";
} else {
$this->setMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
$userinfo->zuserid->setDbValue($conn->Insert_ID());
$rsnew['userid'] = $userinfo->zuserid->DbValue;
// Call Row Inserted event
$userinfo->Row_Inserted($rsnew);
}
return $AddRow;
}
