/// <summary> /// This class allows you to grab an army using its name, which is required in order to pull from list/comboboxes with string names /// </summary> /// <returns>An Army, identified by its name as a string</returns> public static Army GetArmy(string name) { AOEContext context = new AOEContext(); Army returner = (from a in context.Armies where a.ArmyName == name select a).FirstOrDefault(); return(returner); }
/// <summary> /// Deletes an army from the database by ArmyId /// </summary> /// <param name="a"></param> public static void Delete(Army a) { using (AOEContext context = new AOEContext()) { context.Armies.Attach(a); context.Entry(a).State = EntityState.Deleted; context.SaveChanges(); } }
/// <summary> /// Adds an army to the database /// </summary> /// <param name="army"></param> public static Army Add(Army army) { AOEContext context = new AOEContext(); context.Armies.Add(army); context.SaveChanges(); return(army); }
/// <summary> /// Returns a list of all the armies /// </summary> public static List <Army> GetAllArmies() { AOEContext context = new AOEContext(); List <Army> armies = (from a in context.Armies select a).ToList(); return(armies); }
/// <summary> /// Deletes a soldier from the database by SoldierId /// </summary> /// <param name="s"></param> public static void Delete(Soldier s) { using (AOEContext context = new AOEContext()) { context.Soldiers.Attach(s); context.Entry(s).State = EntityState.Deleted; context.SaveChanges(); } }
/// <summary> /// Adds a soldier to the database /// </summary> /// <param name="soldier"></param> public static Soldier Add(Soldier soldier) { AOEContext context = new AOEContext(); context.Soldiers.Add(soldier); context.SaveChanges(); return(soldier); }
/// <summary> /// Returns a list of all the soldiers /// </summary> public static List <Soldier> GetAllSoldiers() { AOEContext context = new AOEContext(); List <Soldier> soldiers = (from s in context.Soldiers select s).ToList(); return(soldiers); }
/// <summary> /// Updates all army data except for PK /// </summary> /// <param name="a"></param> public static Army Update(Army a) { using (AOEContext context = new AOEContext()) { context.Armies.Attach(a); context.Entry(a).State = EntityState.Modified; context.SaveChanges(); return(a); } }
/// <summary> /// Updates all soldier data except PK /// </summary> /// <param name="s"></param> public static Soldier Update(Soldier s) { using (AOEContext context = new AOEContext()) { context.Soldiers.Attach(s); context.Entry(s).State = EntityState.Modified; context.SaveChanges(); return(s); } }