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);
}
