public GetBuildBotStatusResponse GetBuildBotStatus (WebServiceLogin login) { GetBuildBotStatusResponse response = new GetBuildBotStatusResponse (); using (DB db = new DB ()) { Authenticate (db, login, null, true); response.Status = new List<DBBuildBotStatus> (); response.Hosts = new List<DBHost> (); response.Releases = new List<DBRelease> (); using (IDbCommand cmd = db.CreateCommand ()) { cmd.CommandText = "SELECT * FROM BuildBotStatus; SELECT * FROM Host; SELECT * FROM Release;"; using (IDataReader reader = cmd.ExecuteReader ()) { while (reader.Read ()) { response.Status.Add (new DBBuildBotStatus (reader)); } if (reader.NextResult ()) { while (reader.Read ()) { response.Hosts.Add (new DBHost (reader)); } if (reader.NextResult ()) { while (reader.Read ()) { response.Releases.Add (new DBRelease (reader)); } } } } } } return response; }
public GetBuildBotStatusResponse GetBuildBotStatus (WebServiceLogin login) { GetBuildBotStatusResponse response = new GetBuildBotStatusResponse (); try { using (DB db = new DB ()) { VerifyUserInRole (db, login, Roles.Administrator, true); response.Status = new List<DBBuildBotStatus> (); response.Hosts = new List<DBHost> (); response.Releases = new List<DBRelease> (); using (IDbCommand cmd = db.CreateCommand ()) { cmd.CommandText = "SELECT * FROM BuildBotStatus; SELECT * FROM Host; SELECT * FROM Release;"; using (IDataReader reader = cmd.ExecuteReader ()) { while (reader.Read ()) { response.Status.Add (new DBBuildBotStatus (reader)); } if (reader.NextResult ()) { while (reader.Read ()) { response.Hosts.Add (new DBHost (reader)); } if (reader.NextResult ()) { while (reader.Read ()) { response.Releases.Add (new DBRelease (reader)); } } } } } } } catch (Exception ex) { response.Exception = new WebServiceException (ex); } return response; }