public void LogQso(QsoModel qso) { using (MySqlCommand cmd = m_Connection.CreateCommand()) { cmd.CommandText = "INSERT INTO qsos (session, date, band, mode, callsign, rsttx, rstrx) VALUES (?session, ?date, ?band, ?mode, ?callsign, ?rsttx, ?rstrx);"; cmd.Parameters.AddWithValue("?session", 0); cmd.Parameters.AddWithValue("?date", DateTime.Parse(qso.Date)); cmd.Parameters.AddWithValue("?band", qso.Band); cmd.Parameters.AddWithValue("?mode", qso.Mode); cmd.Parameters.AddWithValue("?callsign", qso.Callsign); cmd.Parameters.AddWithValue("?rsttx", qso.RstTx); cmd.Parameters.AddWithValue("?rstrx", qso.RstRx); cmd.ExecuteNonQuery(); } }
public ActionResult AddQso(QsoModel qso) { new DataStore().LogQso(qso); return Json(qso); }