protected void Save_Click(object sender, EventArgs e)
{
if (_id < 1)
{
return;
}
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("update [Enviroment] set [Name]=@n, [Type]=@t, [Description]=@d, AddressId=@ai where Id=@id", conn);
cmd.Parameters.AddWithValue("n", EditName.Text);
cmd.Parameters.AddWithValue("t", EditType.SelectedValue);
cmd.Parameters.AddWithValue("d", EditDescription.Text);
cmd.Parameters.AddWithValue("e", DateTime.Now);
App_Code.Base.EnviromentAddress ea = _data.Find(delegate(App_Code.Base.EnviromentAddress i)
{
return(i.Address == AddAddress.SelectedValue);
});
if (ea != null)
{
cmd.Parameters.AddWithValue("ai", ea.Id);
}
else
{
return;
}
cmd.Parameters.AddWithValue("id", _id);
cmd.ExecuteNonQuery();
Response.Redirect("~/Journal.aspx");
}
}
protected void AddRecord_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into [Enviroment] " +
"([Name], [Type], AddressId, [Description]) " +
"values (@n, @t, @ai, @d)", conn);
cmd.Parameters.AddWithValue("n", AddName.Text);
cmd.Parameters.AddWithValue("t", AddType.SelectedValue);
App_Code.Base.EnviromentAddress ea = _data.Find(delegate(App_Code.Base.EnviromentAddress i)
{
return(i.Address == AddAddress.SelectedValue);
});
cmd.Parameters.AddWithValue("ai", ea.Id);
cmd.Parameters.AddWithValue("d", AddDescription.Text);
cmd.ExecuteNonQuery();
Response.Redirect("~/Enviroment.aspx");
}
}
