public Boolean insertAward(Award obj)
        {
            using (BodyByKurtContext db = new BodyByKurtContext())
            {
                try
                {
                    db.Awards.Add(obj);
                    db.SaveChanges();
                    return true;
                }
                catch (Exception ex)
                {
                    return false;
                }

            }
        }
        public List<Award> searchAwards(Award obj)
        {
            BodyByKurtContext db = new BodyByKurtContext();

            try
            {
                IQueryable<Award> AwardList = from Award in db.Awards
                                                    where Award.Award_ID.StartsWith(obj.Award_ID)
                                                    || Award.First_Name.StartsWith(obj.First_Name)
                                                    || Award.Last_Name.StartsWith(obj.Last_Name)
                                                    orderby Award.Award_ID ascending
                                                    select Award;

                return AwardList.ToList();
            }
            catch (Exception ex)
            {
                return null;
            }
        }
        public Boolean deleteAward(Award obj)
        {
            using (BodyByKurtContext db = new BodyByKurtContext())
            {
                try
                {
                    IQueryable<Award> AwardList = from Award in db.Awards
                                                        where Award.Award_ID == obj.Award_ID
                                                        select Award;

                    if ((AwardList.ToArray().Length > 0))
                    {

                        db.Addresses.Remove((AwardList.ToArray())[0].Address);
                        db.Awards.Remove((AwardList.ToArray())[0]);
                        #region Database Submission

                        try
                        {
                            db.SaveChanges();
                            return true;
                        }
                        catch (Exception ex)
                        {
                            return false;
                        }

                        #endregion
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    return false;
                }
            }
        }
        public Boolean updateAward(Award obj)
        {
            using (BodyByKurtContext db = new BodyByKurtContext())
            {
                try
                {

                    IQueryable<Award> AwardList = from Award in db.Awards
                                                        where Award.Award_ID == obj.Award_ID
                                                        select Award;

                    if ((AwardList.ToArray()).Length > 0)
                    {
                        foreach (Award Award in AwardList)
                        {
                            Award.Award_ID = obj.Award_ID;
                            Award.First_Name = obj.First_Name;
                            Award.Last_Name = obj.Last_Name;
                        }

                        #region Database Submission with Rollback

                        try
                        {
                            db.SaveChanges();
                            return true;
                        }
                        catch (Exception ex)
                        {
                            return false;
                        }
                        #endregion
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    return false;
                }

            }
        }