public static string wmGetAWSObjectList(string sCloudID, string sObjectType)
{
awsMethods acAWS = new awsMethods();
string sHTML = "";
string sErr = "";
DataTable dt = acAWS.GetCloudObjectsAsDataTable(sCloudID, sObjectType, ref sErr);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
GetAssociatedEcosystems(ref dt, sObjectType);
sHTML = DrawTableForType(sObjectType, dt);
}
else
{
sHTML = "No data returned from the Cloud Provider.";
}
}
else
{
sHTML += "<div class=\"ui-widget\" style=\"margin-top: 10px;\">";
sHTML += "<div style=\"padding: 10px;\" class=\"ui-state-highlight ui-corner-all\">";
sHTML += "<span style=\"float: left; margin-right: .3em;\" class=\"ui-icon ui-icon-info\"></span>";
sHTML += "<p>" + sErr + "</p>";
sHTML += "</div>";
sHTML += "</div>";
}
return(sHTML);
}
public static string wmGetEcosystemObjectByType(string sEcosystemID, string sType)
{
dataAccess dc = new dataAccess();
awsMethods acAWS = new awsMethods();
acUI.acUI ui = new acUI.acUI();
try
{
string sHTML = "";
string sErr = "";
//So, we'll first get a distinct list of all clouds represented in this set
//then for each cloud we'll get the objects.
string sSQL = "select distinct cloud_id" +
" from ecosystem_object" +
" where ecosystem_id ='" + sEcosystemID + "'" +
" and ecosystem_object_type = '" + sType + "'";
DataTable dtClouds = new DataTable();
if (!dc.sqlGetDataTable(ref dtClouds, sSQL, ref sErr))
{
return(sErr);
}
if (dtClouds.Rows.Count > 0)
{
foreach (DataRow drCloud in dtClouds.Rows)
{
string sCloudID = drCloud["cloud_id"].ToString();
//get the cloud object rows
sSQL = "select eo.ecosystem_object_id, eo.ecosystem_object_type" +
" from ecosystem_object eo" +
" where eo.ecosystem_id ='" + sEcosystemID + "'" +
" and eo.ecosystem_object_type = '" + sType + "'" +
" and eo.cloud_id = '" + sCloudID + "'" +
" order by eo.ecosystem_object_type";
DataTable dtObjects = new DataTable();
if (!dc.sqlGetDataTable(ref dtObjects, sSQL, ref sErr))
{
return(sErr);
}
if (dtObjects.Rows.Count > 0)
{
//we only need to hit the API once... this result will contain all the objects
//and our DrawProperties will filter the DataTable on the ID.
DataTable dtAPIResults = acAWS.GetCloudObjectsAsDataTable(sCloudID, sType, ref sErr);
foreach (DataRow drObject in dtObjects.Rows)
{
//look up the cloud and get the name
Cloud c = new Cloud(sCloudID);
if (c.ID != null)
{
//giving each section a guid so we can delete it on the client side after the ajax call.
//not 100% the ecosystem_object_id will always be suitable as a javascript ID.
string sGroupID = ui.NewGUID();
sHTML += "<div class=\"ui-widget-content ui-corner-all ecosystem_item\" id=\"" + sGroupID + "\">";
string sObjectID = drObject["ecosystem_object_id"].ToString();
string sLabel = "Cloud: " + c.Name + " - " + sObjectID;
sHTML += "<div class=\"ui-widget-header ecosystem_item_header\">";
sHTML += "<div class=\"ecosystem_item_header_title\"><span>" + sLabel + "</span></div>";
sHTML += "<div class=\"ecosystem_item_header_icons\">";
sHTML += "<span class=\"ui-icon ui-icon-close ecosystem_item_remove_btn pointer\"" +
" id_to_delete=\"" + drObject["ecosystem_object_id"].ToString() + "\"" +
" id_to_remove=\"" + sGroupID + "\">";
sHTML += "</span>";
sHTML += "</div>";
sHTML += "</div>";
//the details section
sHTML += "<div class=\"ecosystem_item_detail\">";
if (dtAPIResults != null)
{
if (dtAPIResults.Rows.Count > 0)
{
sHTML += DrawAllProperties(dtAPIResults, sObjectID);
}
}
//end detail section
sHTML += "</div>";
//end block
sHTML += "</div>";
}
}
}
else
{
sHTML += "<span>This ecosystem does not contain any Cloud Objects.</span>";
}
}
}
return(sHTML);
}
catch (Exception ex)
{
return(ex.Message);
}
}