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