public function delete()
{
$iProID = $this->iProID;
$sql = "DELETE from products WHERE ProID =" . $iProID;
DataProvider::execNonQuery($sql);
}
public function delete()
{
$iStatusID = $this->iStatusID;
$sql = "DELETE from statuses WHERE StatusID =" . $iStatusID;
DataProvider::execNonQuery($sql);
}
public function updateLastLogon()
{
$id = $this->userID;
$str_LastLogon = date_format($this->lastLogon, 'Y-m-d H:i:s');
$sql = "update users set LastLogon = '{$str_LastLogon}' " . "where UserID = " . $id;
DataProvider::execNonQuery($sql);
return true;
}
public function insert()
{
$iOrderID = $this->oOrder->getOrderID();
$iProID = $this->oProduct->getProID();
$iQuantity = $this->iQuantity;
$fPrice = $this->fPrice;
$fAmount = $this->fAmount;
$sql = "INSERT INTO orderdetails (OrderID, ProID,Quantity ,Price , Amount) VALUES " . "('{$iOrderID}' , {$iProID}, {$iQuantity}, {$fPrice} , {$fAmount} )";
DataProvider::execNonQuery($sql);
}
public function delete()
{
$iDeviceID = $this->iDeviceID;
$sql = "DELETE from devices WHERE DeviceID =" . $iDeviceID;
DataProvider::execNonQuery($sql);
}
public function delete()
{
$CatProID = $this->iCatProID;
$sql = "DELETE FROM categories WHERE CatProID = " . $CatProID;
DataProvider::execNonQuery($sql);
}
public function delete()
{
$BraID = $this->iBraID;
$sql = "DELETE from brands WHERE BraID =" . $BraID;
DataProvider::execNonQuery($sql);
}
public function update()
{
$iOrderID = $this->iOrderID;
$iStatus = $this->oStatus->getStatusID();
$sql = sprintf("UPDATE orders SET StatusID = {$iStatus} " . "WHERE OrderID ={$iOrderID}");
DataProvider::execNonQuery($sql);
}
