public static ServerHardware Load(Guid Id)
{
bool success = false;
ServerHardware result = new ServerHardware ();
QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select);
qb.Table (DatabaseTableName);
qb.Columns
(
"id",
"type",
"data"
);
qb.AddWhere ("id", "=", Id);
Query query = Runtime.DBConnection.Query (qb.QueryString);
if (query.Success)
{
if (query.NextRow ())
{
result._id = query.GetGuid (qb.ColumnPos ("id"));
result._type = query.GetEnum<qnaxLib.Enums.ServerHardwareType> (qb.ColumnPos ("type"));
result._data = query.GetString (qb.ColumnPos ("data"));
success = true;
}
}
query.Dispose ();
query = null;
qb = null;
if (!success)
{
throw new Exception (string.Format (Strings.Exception.CountryCodeLoad, Id));
}
return result;
}
public static ServerHardware FromXmlDocument(XmlDocument xmlDocument)
{
Hashtable item = (Hashtable)SNDK.Convert.FromXmlDocument (xmlDocument);
ServerHardware result;
if (item.ContainsKey ("id"))
{
try
{
result = ServerHardware.Load (new Guid ((string)item["id"]));
}
catch
{
result = new ServerHardware (SNDK.Convert.StringToEnum<qnaxLib.Enums.ServerHardwareType> ((string)item["type"]));
result._id = new Guid ((string)item["id"]);
}
}
else
{
throw new Exception ("SERVERHARDWARE1");
}
if (item.ContainsKey ("type"))
{
result._type = SNDK.Convert.StringToEnum<qnaxLib.Enums.ServerHardwareType> ((string)item["type"]);
}
if (item.ContainsKey ("data"))
{
result._data = (string)item["data"];
}
return result;
}
