public Battlemech(int ridDesign, int ridArmy)
        {
            battleMechTable = new Battle.Domain.Concrete.BattleMechContext();
            designTable = new Battle.Domain.Concrete.DesignContext();

            int maxid = 0;
            try
            {
                maxid = battleMechTable.Database.SqlQuery<int>("Select max(id) from Battlemechs").FirstOrDefault<int>();
            }
            catch
            {
                maxid = 0;
            }
            maxid++;

            string designName = designTable.Database.SqlQuery<string>(
                "Select name from Design where rid = " + ridDesign.ToString()).FirstOrDefault<string>();

            this.name = "Mech-" + maxid.ToString() + " " + designName;

            int i = battleMechTable.Database.ExecuteSqlCommand(
                "Insert into Battlemechs(id,name,riddesign,ridarmy,qnt) Values(' "
                + maxid.ToString() + "','" + this.name + "','" + ridDesign.ToString() + "','" + ridArmy.ToString() + "','" + 1.ToString() + "')");

            // Получить rid меха
            int ridBattleMech = battleMechTable.Database.SqlQuery<int>(
                "Select rid from Battlemechs where id=" + maxid.ToString()).FirstOrDefault<int>();

            this.id = maxid;
            this.rid = ridBattleMech;
            this.qnt = 1;
        }
 public Design GetDesign()
 {
     designTable = new Battle.Domain.Concrete.DesignContext();
     return designTable.Designes.SqlQuery(
             "Select * from Design where rid = '" + this.riddesign.ToString() + "'").FirstOrDefault();
 }