public static string addCatalogBike(CatalogBike cb) { return("INSERT INTO `bv_catalog` (`id`,`name`,`PriceMul`,`picture`) VALUES (" + cb.getId().ToString() + ",'" + cb.getName() + "'," + cb.getPriceMul().ToString() + ", 'Bike0.jpg')"); }
public static string updateCatalogBike(CatalogBike kt) { return("UPDATE `bv_catalog` SET `name` = '" + kt.getName() + "' , `PriceMul` = '" + kt.getPriceMul().ToString() + "' WHERE `id` = " + kt.getId().ToString()); }
public static int unlinkKTCB(CatalogBike cb, KitTemplate kt) { string q = DatabaseQuery.delCompatibleKit(cb.getId(), kt.getId()); return(Database.setData(q)); }