// Получить параметры страны по коду // TODO: Переделать, возвращать объект типа Country public void GetByCod(string cod) { if (cod.Equals(null)) { cod = ""; rid = 0; id = 0; nameEng = ""; color = ""; ridgamer = 0; } else { var countryTable = new Battle.Domain.Concrete.CountryContext(); this.cod = cod; rid = countryTable.Database.SqlQuery<int>("Select rid from Country where cod = '" + cod + "'").FirstOrDefault<int>(); id = countryTable.Database.SqlQuery<int>("Select id from Country where cod = '" + cod + "'").FirstOrDefault<int>(); nameEng = countryTable.Database.SqlQuery<string>("Select name from Country where cod = '" + cod + "'").FirstOrDefault<string>(); color = countryTable.Database.SqlQuery<string>("Select color from Country where cod = '" + cod + "'").FirstOrDefault<string>(); mineral = countryTable.Database.SqlQuery<int>("Select mineral from Country where cod = '" + cod + "'").FirstOrDefault<int>(); ridgamer = countryTable.Database.SqlQuery<int>("Select ridgamer from Country where cod = '" + cod + "'").FirstOrDefault<int>(); } }
// Сменить владельца страны public void ChangeOwner(int ridGamer) { var countryTable = new Battle.Domain.Concrete.CountryContext(); int i = countryTable.Database.ExecuteSqlCommand( "Update Country set ridgamer = '" + ridGamer.ToString() + "' where id=" + this.id.ToString()); }