/// <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);
     }
 }
Пример #4
0
        /// <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());
            }
        }