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(); }