public static RangeGroup Load(Guid Id) { bool success = false; RangeGroup result = new RangeGroup (); QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select); qb.Table (DatabaseTableName); qb.Columns ( "id", "createtimestamp", "updatetimestamp", "name", "rangeids", "countrycodeids", "costpriceids", "retailpriceids" ); 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._createtimestamp = query.GetInt (qb.ColumnPos ("createtimestamp")); result._updatetimestamp = query.GetInt (qb.ColumnPos ("updatetimestamp")); result._name = query.GetString (qb.ColumnPos ("name")); result._rangeids = SNDK.Convert.StringToList<Guid> (query.GetString (qb.ColumnPos ("rangeids"))); result._countrycodeids = SNDK.Convert.StringToList<Guid> (query.GetString (qb.ColumnPos ("countrycodeids"))); result._costpriceids = SNDK.Convert.StringToList<Guid> (query.GetString (qb.ColumnPos ("costpriceids"))); result._retailpriceids = SNDK.Convert.StringToList<Guid> (query.GetString (qb.ColumnPos ("retailpriceids"))); success = true; } } query.Dispose (); query = null; qb = null; if (!success) { throw new Exception (string.Format (Strings.Exception.RangeGroupLoad, Id)); } return result; }
public static RangeGroup FromXmlDocument(XmlDocument xmlDocument) { Hashtable item = (Hashtable)SNDK.Convert.FromXmlDocument (xmlDocument); RangeGroup result; if (item.ContainsKey ("id")) { try { result = RangeGroup.Load (new Guid ((string)item["id"])); } catch { result = new RangeGroup (); result._id = new Guid ((string)item["id"]); } } else { result = new RangeGroup (); } if (item.ContainsKey ("name")) { result._name = (string)item["name"]; } if (item.ContainsKey ("ranges")) { result._rangeids.Clear (); foreach (XmlDocument range in (List<XmlDocument>)item["ranges"]) { result._rangeids.Add (Range.FromXmlDocument (range).Id); } } if (item.ContainsKey ("countrycodes")) { result._countrycodeids.Clear (); foreach (XmlDocument countrycode in (List<XmlDocument>)item["countrycodes"]) { result._countrycodeids.Add (CountryCode.FromXmlDocument (countrycode).Id); } } if (item.ContainsKey ("costprices")) { result._temp_costprices = new List<RangePrice> (); foreach (XmlDocument rangeprice in (List<XmlDocument>)item["costprices"]) { result._temp_costprices.Add (RangePrice.FromXmlDocument (rangeprice)); } } if (item.ContainsKey ("retailprices")) { result._temp_retailprices = new List<RangePrice> (); foreach (XmlDocument rangeprice in (List<XmlDocument>)item["retailprices"]) { result._temp_retailprices.Add (RangePrice.FromXmlDocument (rangeprice)); } } return result; }