public AdminUrl[] RetrieveAdminURLs(DbConnection connection, int processAgentID)
{
// create sql command
// command executes the "RetrieveAdminURLs" stored procedure
DbCommand cmd = FactoryDB.CreateCommand("AdminURLs_Retrieve", connection);
cmd.CommandType = CommandType.StoredProcedure;
// populate parameters
cmd.Parameters.Add(FactoryDB.CreateParameter( "@processAgentID", processAgentID, DbType.Int32));
// read the result
ArrayList list = new ArrayList();
DbDataReader dataReader = cmd.ExecuteReader();
try
{
while (dataReader.Read())
{
int id = (int)dataReader.GetInt32(0);
processAgentID = (int)dataReader.GetInt32(1);
string url = dataReader.GetString(2).Trim();
string ticketType = dataReader.GetString(3);
list.Add(new AdminUrl(id, processAgentID, url, ticketType));
}
dataReader.Close();
}
catch (DbException e)
{
Console.WriteLine(e);
throw;
}
finally
{
// close the sql connection
connection.Close();
}
AdminUrl dummy = new AdminUrl();
AdminUrl[] urls = (AdminUrl[])list.ToArray(dummy.GetType());
return urls;
}
public void DeleteAdminURL(AdminUrl adminURL)
{
if (!TicketTypes.TicketTypeExists(adminURL.TicketType.name))
throw new Exception("\"" + adminURL.TicketType.name + "\" is not a valid ticket type.");
// create sql connection
DbConnection connection = FactoryDB.GetConnection();
try
{
connection.Open();
DeleteAdminURL(connection, adminURL.ProcessAgentId, adminURL.Url, adminURL.TicketType.name);
}
catch (DbException e)
{
writeEx(e);
throw;
}
finally
{
connection.Close();
}
}
protected void repAdminURLs_ItemBound(object source, RepeaterItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
// get the current grant
Object o = e.Item.DataItem;
curAdminURL = (AdminUrl)o;
Button curBtn = (Button)e.Item.FindControl("btnRemove");
curBtn.CommandArgument = ((AdminUrl)o).Id.ToString();
}
}
