public void CreateLog(LogModel model) { using (MySqlCommand cmd = m_Connection.CreateCommand()) { cmd.CommandText = "INSERT INTO logs (name, userId, locator, wabSquare) VALUES (?name, ?userId, ?locator, ?wabSquare);"; cmd.Parameters.AddWithValue("?name", model.Name); cmd.Parameters.AddWithValue("?userId", model.UserID); cmd.Parameters.AddWithValue("?locator", model.Locator); cmd.Parameters.AddWithValue("?wabSquare", model.WabSquare); cmd.ExecuteNonQuery(); model.ID = (int)cmd.LastInsertedId; } }
private LogModel LoadLog(MySqlDataReader reader) { LogModel log = new LogModel(); log.ID = reader.GetInt32("id"); log.Name = reader.GetString("name"); log.UserID = reader.GetInt32("userId"); log.Locator = reader.GetString("locator"); log.WabSquare = reader.GetString("wabSquare"); return log; }
public ActionResult CreateNew(LogModel log) { log.UserID = 1; new DataStore().CreateLog(log); return Redirect("~/logs"); }