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