public static function InsertUser($UserObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "INSERT INTO `user` (`user_name`, `user_pass`, `user_email`,`date_time`) VALUES ('" . $UserObject->getUserName() . "','" . $UserObject->getPass() . "', '" . $UserObject->getEmail() . "','" . $UserObject->getDate() . "')";
echo $sql;
return $DataBaseHelper->ExecuteInsertReturnID($sql);
}
public static function InsertProducts($ProductsObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "INSERT INTO `product` (`product_id`,`product_details_url`) VALUES ('" . NULL . "','" . safe($ProductsObject->product_details_url) . "')";
echo $sql . "<br/>";
return $DataBaseHelper->ExecuteInsertReturnID($sql);
}
public static function InsertShop($ShopObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "INSERT INTO `shop` (`shop_name`, `shop_address`, `shop_description`,`shop_type_id`,`date_time`,`user_id`) VALUES ('" . $ShopObject->getShopName() . "','" . $ShopObject->getSAddress() . "', '" . $ShopObject->getSDesc() . "','" . $ShopObject->getSTid() . "','" . $ShopObject->getDate() . "','" . $ShopObject->getUserID() . "')";
// You have to write a insert query for MySQL using the Data from $UserObject;
echo $sql;
return $DataBaseHelper->ExecuteInsertReturnID($sql);
}
public static function InsertProducts($ProductsObject)
{
// echo '<pre>';
// print_r($ProductsObject);
// echo '</pre>';
//echo "i am here";
$DataBaseHelper = new DataAccessHelper();
$sql = "INSERT INTO `products` (`product_id`,`product_name`, `product_price`, `dis_percentange`,`before_dis_price`,`emi_availablity`,`emi_rate`,`features`,`img_url`,`category_name`,`sub_category_name`,`product_details_url`,`product_rating`) VALUES ('" . NULL . "','" . safe($ProductsObject->GetProductName()) . "','" . safe($ProductsObject->GetProductPrice()) . "', '" . safe($ProductsObject->GetDiscountDetails()) . "','" . safe($ProductsObject->GetProductBeforeDiscounePrice()) . "','" . safe($ProductsObject->GetEmi()) . "','" . safe($ProductsObject->GetEmiDetails()) . "','" . safe($ProductsObject->GetProductFeatures()) . "','" . safe($ProductsObject->GetImgUrl()) . "','" . safe($ProductsObject->GetProductCategory()) . "','" . safe($ProductsObject->GetProductSubCategory()) . "','" . safe($ProductsObject->GetProductDetailUrl()) . "','" . safe($ProductsObject->GetProductRating()) . "')";
//echo $sql."<br/>";
return $DataBaseHelper->ExecuteInsertReturnID($sql);
}
public static function InsertProducts($ProductsObject, $table)
{
// echo '<pre>';
// print_r($ProductsObject);
// echo '</pre>';
//echo "i am here";
$DataBaseHelper = new DataAccessHelper();
$sql = "INSERT INTO `product_spec` (`id`,`product_id`, `product_spec_type`, `product_data`,`table_name`) VALUES ('" . NULL . "','" . safe($ProductsObject->GetProductID()) . "','" . safe($ProductsObject->GetProductSpecType()) . "', '" . safe($ProductsObject->GetProductData()) . "','" . safe($table) . "')";
//echo $sql."<br/>";
return $DataBaseHelper->ExecuteInsertReturnID($sql);
}
