public static function Delete($id)
{
$strSQL = "delete from dichvu_tienich where id='{$id}'";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function Delete($id)
{
$strSQL = "update cart set Delete_Flag=1 where ID='{$id}' ";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function update($id, $loai, $khenthuong, $ngay)
{
$strSQL = "update khenthuong set loai={$loai},thuong='{$khenthuong}', ngay='{$ngay}' where id={$id}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function SetStatus($user_id, $status)
{
$strSQL = "update khanangban set status= '{$status}' where user_id={$user_id}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function setStatusTinDang($aid, $status)
{
$strSQL = "\tupdate dichvu set status={$status}\r\n\t\t\t\t\t\twhere id={$aid}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function Update($id, $hoten, $sdt, $email, $diachi, $noidung, $ngayguitin, $status)
{
$strSQL = "update lienhe set hoten='{$hoten}', sdt='{$sdt}',email='{$email}',diachi='{$diachi}',noidung='{$noidung}',ngayguitin='{$ngayguitin}',\r\n\t\t\t\t\t\tstatus= '{$status}' where id={$id}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function add($sotien, $donvi, $congviec, $ngay, $nhanvien, $loai)
{
$strSQL = "Insert into thuchi values (NULL,{$sotien},{$donvi},'{$congviec}','{$ngay}',{$nhanvien},{$loai})";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = mysql_insert_id();
}
DataProvider::Close($cn);
return $result;
}
public static function SetStatusTinVIP($iddv, $value)
{
$strSQL = "\tupdate dichvuvip set status={$value}\r\n\t\t\t\t\t\twhere iddichvu={$iddv}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function Delete($ID)
{
$strSQL = "update product_image set Delete_Flag=1\r\n where ID={$ID}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function Update($id, $chusohuu, $sdt, $email, $diachi, $sothang, $filename, $link)
{
$strSQL = "";
if ($filename != null) {
$strSQL = "\tupdate quangcao set chusohuu='{$chusohuu}', sdt='{$sdt}', email='{$email}', diachi='{$diachi}',\r\n\t\t\t\t\t\t\tsothang={$sothang}, hinhanh='{$filename}', link='{$link}'\r\n\t\t\t\t\t\t\twhere id={$id}";
} else {
$strSQL = "\tupdate quangcao set chusohuu='{$chusohuu}', sdt='{$sdt}', email='{$email}', diachi='{$diachi}',\r\n\t\t\t\t\t\t\tsothang={$sothang}, link='{$link}'\r\n\t\t\t\t\t\t\twhere id={$id}";
}
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function SetPassword($id, $password)
{
$password = md5($password);
$strSQL = "update user set Password='******' where ID='{$id}' ";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function delete($id)
{
$strSQL = "update dichvu set status=-1 where id={$id}";
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
public static function Update2($id, $hoten, $gioitinh, $diachi, $sdt1, $sdt2, $newpass, $ngaycapnhat)
{
$strSQL = "";
if ($newpass != -1) {
$strSQL = "\tupdate user set hoten='{$hoten}', gioitinh={$gioitinh}, diachi='{$diachi}',\r\n\t\t\t\t\t\t\t\tsdt1='{$sdt1}', sdt2='{$sdt2}', password='******', ngaycapnhat='{$ngaycapnhat}' \r\n\t\t\t\t\t\t\twhere id={$id}";
} else {
$strSQL = "\tupdate user set hoten='{$hoten}', gioitinh={$gioitinh}, diachi='{$diachi}',\r\n\t\t\t\t\t\t\t\tsdt1='{$sdt1}', sdt2='{$sdt2}', ngaycapnhat='{$ngaycapnhat}' \r\n\t\t\t\t\t\t\twhere id={$id}";
}
$cn = DataProvider::Open();
DataProvider::MoreQuery($strSQL, $cn);
if (mysql_affected_rows() == 0) {
$result = false;
} else {
$result = true;
}
DataProvider::Close($cn);
return $result;
}
