public void SetAttd(string GuestId) { GuestsList dbGuest = new GuestsList(); string sqlQuery = "UPDATE TblGuestsList SET Attendance = 1 WHERE GuestId = " + GuestId; dbGuest.Database.ExecuteSqlCommand(sqlQuery); dbGuest.SaveChanges(); }
public Guest EditGuest(Guest g) { GuestsList dbGuest = new GuestsList(); dbGuest.Entry(g).State = EntityState.Modified; dbGuest.SaveChanges(); return(g); }
public void DeleteGuest(int guestId) { GuestsList dbGuest = new GuestsList(); string sqlQuery = "DELETE FROM TblGuestsList WHERE GuestId = " + guestId; dbGuest.Database.ExecuteSqlCommand(sqlQuery); dbGuest.SaveChanges(); }
public Guest SaveGuest(Guest g) { GuestsList dbGuest = new GuestsList(); dbGuest.dbGuestsList.Add(g); dbGuest.SaveChanges(); return(g); }