/// <summary>
/// Updates a Firearm in the Database.
/// Returns the updated Firearm.
/// </summary>
/// <param name="firearm">The Firearm to update.</param>
/// <returns></returns>
public static Firearms UpdateFirearm(Firearms firearm)
{
using (var context = new SimpleGunShopDatabaseEntities())
{
try
{
context.Firearms.Add(firearm);
context.Entry(firearm).State = EntityState.Modified; // Tell EF it has been modified
context.SaveChanges();
return(firearm);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
/// <summary>
/// Deletes a Firearm from the Database.
/// </summary>
/// <param name="firearm"></param>
public static void DeleteFirearm(Firearms firearm)
{
using (var context = new SimpleGunShopDatabaseEntities())
{
context.Firearms.Add(firearm); // Track with EF
context.Entry(firearm).State = EntityState.Deleted; // Tell EF we are removing it
context.SaveChanges(); // Update on DB
}
}
/// <summary>
/// Adds a Firearm. Returns the newly added Firearm
/// with the FirearmID populated
/// </summary>
/// <param name="firearm">The Firearm to add.</param>
/// <returns></returns>
public static Firearms AddFirearm(Firearms firearm)
{
using (var context = new SimpleGunShopDatabaseEntities())
{
context.Firearms.Add(firearm);
context.SaveChanges();
context.Entry(firearm).State = EntityState.Added; // Tell EF firearm has been added
return(firearm);
}
}
/// <summary>
/// Returns all Firearms registered in the database
/// </summary>
/// <returns></returns>
public static List <Firearms> GetFirearms()
{
//Creates the instance of the DB contexte
var db = new SimpleGunShopDatabaseEntities();
//Using LINQ Method Syntax (returning all firearms in the database.
List <Firearms> firearms = db.Firearms.ToList();
return(firearms);
}
/// <summary>
/// Returns all Firearms registered in the database
/// </summary>
/// <returns></returns>
public static List <Firearms> GetFirearms()
{
//Creates the instance of the DB contexte
//var db = new SimpleGunShopDatabaseEntities();
using (SimpleGunShopDatabaseEntities context = new SimpleGunShopDatabaseEntities())
{
//This should allow the list to be grouped by manufacturer rather than showing duplicates
//Using LINQ Method Syntax (returning all firearms in the database.
//List<Firearms> firearms = context.Firearms.ToList();
return(context
.Firearms
.OrderBy(f => f.Manufacturer)
.ToList());
}
}