public Country() { ID = -1; Changed = false; UnionList = new CountryUnionList(); }
private void UpdateMirror() { if (mirror == null) { mirror = new CountryUnionList(); } mirror.Clear(); mirror.Load(); foreach (var cu in this) { mirror.RemoveAll(item => item.ID == cu.ID); } }
public void Load() { DBInterface.CommandText = "SELECT nameCountry, codeISO2, codeISO3, codeCitizen FROM `sellcontroller`.`country` WHERE `idCountry` = @id;"; DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DataTable tab = DBInterface.ExecuteSelection(); if (tab.Rows.Count == 1) { Name = Convert.ToString(tab.Rows[0]["nameCountry"]); ISO = Convert.ToString(tab.Rows[0]["codeISO2"]); ISO3 = Convert.ToString(tab.Rows[0]["codeISO3"]); Nationality = Convert.ToString(tab.Rows[0]["codeCitizen"]); } else if (tab.Rows.Count > 1) { throw new DuplicateNameException("Country table has rows with same id"); } UnionList.Load(this); mirror = UnionList.mirror; Changed = false; }