private void LoadFractions(string elmName, List <AttributeValue> list) { FractionInfo f = new FractionInfo(); string code = null; foreach (AttributeValue value in list) { switch (value.Name) { case "iso4217": code = value.Value; if (code == "DEFAULT") { return; } break; case "digits": byte.TryParse(value.Value, NumberStyles.Integer, CultureInfo.InvariantCulture, out f.Digits); break; case "rounding": byte.TryParse(value.Value, NumberStyles.Integer, CultureInfo.InvariantCulture, out f.Rounding); break; case "cashDigits": byte.TryParse(value.Value, NumberStyles.Integer, CultureInfo.InvariantCulture, out f.CashDigits); break; case "cashRounding": byte.TryParse(value.Value, NumberStyles.Integer, CultureInfo.InvariantCulture, out f.CashRounding); break; default: _loader.Warning("Invalid attribute " + value.Name); break; } } if (code.HasValue()) { _fractionInfos.Add(code, f); } }
private void GetFractionInfo(List <FractionInfo> FractionInfo) { string queryString = @"SELECT * FROM fractions"; MySqlCommand Command = new MySqlCommand(queryString, MySqlDB); using (MySqlDataReader dr = Command.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { FractionInfo inf = new FractionInfo(); inf.Name = dr["Name"].ToString(); inf.ID = (int)dr["ID"]; inf.Description = dr["Description"].ToString(); inf.ToImgPath = dr["ImagePath"].ToString(); FractionInfo.Add(inf); } } } }