public static NavbarEditRow NewLink(Default page) { int id; using (SqlCommand cmd = DatabaseManager.Current.CreateCommand("INSERT INTO NavbarLinks (Text, URL, Scope) OUTPUT INSERTED.Id VALUES ('Example', 'http://www.example.com/', NULL)")) { id = (int)cmd.ExecuteScalar(); } using (SqlCommand cmd = DatabaseManager.Current.CreateCommand("SELECT * FROM NavbarLinks WHERE Id=@id")) { cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader r = cmd.ExecuteReader()) { if (r.Read()) return new NavbarEditRow(r, page); else return null; } } }
public NavbarEditRow(SqlDataReader r, Default page) { _id = (int)r["Id"]; _text = (string)r["Text"]; _url = (string)r["URL"]; _scope = (r["Scope"] is DBNull) ? 0 : (int)r["Scope"]; _saveButton = new LinkButton() { Text = "OK", CssClass = "linkbutton linkbutton-small", ID = "btn_save_" + _id }; _saveButton.Click += page.NavbarSave_Click; _deleteButton = new LinkButton() { Text = "-", CssClass = "linkbutton linkbutton-small", ID = "btn_del_" + _id }; _deleteButton.Click += page.NavbarDelete_Click; }