Example #1
0
        /// <summary>
        /// Update the party details
        /// </summary>
        /// <param name="updatedParty"></param>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public PartyTable UpdateParty(PartyTable updatedParty)
        {
            using (var context = new EntitiesChooseEm())
            { //check for party being null?
                PartyTable party = context.PartyTables.FirstOrDefault(p => p.ID == updatedParty.ID);

                party.startDate         = updatedParty.startDate;
                party.endDate           = updatedParty.endDate;
                party.locationLatitude  = updatedParty.locationLatitude;
                party.locationLongitude = updatedParty.locationLongitude;
                party.privacy           = updatedParty.privacy;
                party.Name            = updatedParty.Name;
                party.RowVersion      = updatedParty.RowVersion;
                party.AvailablePlaces = updatedParty.AvailablePlaces;


                context.PartyTables.Attach(party);
                context.Entry(party).State = System.Data.Entity.EntityState.Modified;

                var num = context.SaveChanges();

                if (num != 1)
                {
                    throw new Exception("Concurrency Error");
                }
            }
            return(updatedParty);
        }
Example #2
0
 public PartyTable CreateParty(PartyTable party)
 {
     using (var db = new EntitiesChooseEm())
     {
         db.PartyTables.Add(party);
         db.SaveChanges();
     }
     return(party);
 }