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);
}
