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; }