public static void simpan(string x, string y) { // FIXED if (!string.IsNullOrEmpty(y)) { string insertQuery = "INSERT INTO parkir_masuk(`no_kendaraan`, `id_kendaraan`, `tanggal_Masuk`, `jam_Masuk`) VALUES ('" + x + "','" + int.Parse(y) + "', CURDATE(), curtime());"; DatabaseUtility.ExecuteMyQuery(insertQuery); } }
public static void UpdateData2(string y) { string updateQuery = @"UPDATE db_parkir.parkir_masuk a join biaya_parkir b SET a.tanggal_keluar = CURDATE(), a.jam_keluar = curtime(),a.Tarif = b.Tarif WHERE a.no_kendaraan = '" + y + "'"; var cmd = new MySqlCommand(updateQuery, new MySqlConnection(DatabaseUtility.ConnectionString)); cmd.CommandType = CommandType.Text; //cmd.Parameters.AddWithValue("@x", int.Parse(x)); DatabaseUtility.ExecuteMyQuery(updateQuery); }
public static void update(string decoded) { string updateQuery = "UPDATE parkir_masuk a join biaya_parkir b SET a.tanggal_keluar = CURDATE(), a.jam_keluar = curtime(),a.Tarif = b.Tarif WHERE a.no_masuk ='" + decoded + "'"; DatabaseUtility.ExecuteMyQuery(updateQuery); }