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