private void AddCounties()
{
MarkStadlerDel del = new MarkStadlerDel(GetUpdateStatus);
try
{
conn.Open();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
//set the commandText to the name of our stored procedure
command.CommandText = "[dbo].[GetRegions]";
//execute the command
reader = command.ExecuteReader();
// add each counrty to dropdown list
while (reader.Read())
{
dpCounty.Items.Add(reader.GetValue(0).ToString());
}
;
reader.Close();
}
catch
{
del("load", "counties", false);
}
finally
{
conn.Close();
}
}
private void LoadDeleteFields(string itemToDeleteField)
{
MarkStadlerDel del = new MarkStadlerDel(GetUpdateStatus);
try
{
conn.Open();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
if (itemToDeleteField == "Rivers")
{
//set the commandText to the name of our stored procedure
command.CommandText = "[dbo].[GetRivers]";
}
else if (itemToDeleteField == "Lakes")
{
command.CommandText = "[dbo].[GetLakes]";
}
else if (itemToDeleteField == "Species")
{
command.CommandText = "[dbo].[GetFishSpecies]";
}
//execute the command
reader = command.ExecuteReader();
LstItems.Items.Clear();
while (reader.Read())
{
LstItems.Items.Add(reader.GetValue(0).ToString());
}
;
reader.Close();
}
catch (Exception e)
{
// failed to get field from tabel --> output appropiate error msg.
del("load", itemToDeleteField, false);
}
finally
{
conn.Close();
}
}
protected void btnDeleteItem_Click(object sender, EventArgs e)
{
if (IsValid)
{
MarkStadlerDel del = new MarkStadlerDel(GetUpdateStatus);
try
{
conn.Open();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
if (dpFieldDelete.SelectedValue.ToString() == "Rivers")
{
command.CommandText = "[dbo].[DeleteRiver]";
}
else if (dpFieldDelete.SelectedValue.ToString() == "Lakes")
{
command.CommandText = "[dbo].[DeleteLake]";
}
else if (dpFieldDelete.SelectedValue.ToString() == "Species")
{
command.CommandText = "[dbo].[DeleteFishSpecie]";
}
command.Parameters.AddWithValue("@name", LstItems.SelectedValue.ToString());
//execute the command
command.ExecuteNonQuery();
del("delete", dpFieldDelete.SelectedValue.ToString(), true);
LstItems.Items.Remove(LstItems.SelectedValue.ToString());
}
catch (Exception ex)
{
del("delete", dpFieldDelete.SelectedValue.ToString(), false);
}
finally
{
conn.Close();
}
}
}
protected void btnAddItem_Click(object sender, EventArgs e)
{
if (IsValid)
{
MarkStadlerDel del = new MarkStadlerDel(GetUpdateStatus);
try
{
conn.Open();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
if (DpField.SelectedValue.ToString() == "River")
{
command.CommandText = "[dbo].[AddRiver]";
}
else if (DpField.SelectedValue.ToString() == "Lake")
{
command.CommandText = "[dbo].[AddLake]";
}
command.Parameters.AddWithValue("@name", txtNewData.Text);
command.Parameters.AddWithValue("@region", dpCounty.SelectedValue.ToString());
//execute the command
command.ExecuteNonQuery();
del("add", DpField.SelectedValue.ToString(), true);
}
catch
{
del("add", DpField.SelectedValue.ToString(), false);
}
finally
{
conn.Close();
}
}
}
