public void insertIntoCreateRoom(Room room) { try { pokerplanningContext context = new pokerplanningContext(); bool roomIdResult = context.Room.Any(x => x.RoomId == room.RoomId); bool hostIdResult = context.Empdetails.Any(x => x.EmpOracleId == room.HostId); if (roomIdResult == true || hostIdResult == false) { throw new Exception("Room is created already or HostId is not registered !!"); } context.Room.Add(room); context.SaveChanges(); // entering the host id to roomDetails var roomId = room.RoomId; var empOracleId = room.HostId; Roomdetails row = new Roomdetails(); row.RoomId = roomId; row.EmpId = empOracleId; row.NumberChoosenStatus = "no"; row.HostStatus = "yes"; context.Roomdetails.Add(row); context.SaveChanges(); } catch (System.Exception e) { throw new Exception(e.Message); } }
public void insertIntoRoomDetails(Roomdetails roomdetails) { try { pokerplanningContext context = new pokerplanningContext(); bool roomIdResult = context.Room.Any(x => x.RoomId == roomdetails.RoomId); bool hostIdResult = context.Empdetails.Any(x => x.EmpOracleId == roomdetails.EmpId); bool alreadyInRoom = context.Roomdetails.Any(x => x.RoomId == roomdetails.RoomId && x.EmpId == roomdetails.EmpId); roomdetails.HostStatus = "no"; if (roomIdResult == false || hostIdResult == false) { throw new Exception("Room is not created or HostId is not registered !!"); } else if (alreadyInRoom) { throw new Exception("You are already in Room !!"); } context.Roomdetails.Add(roomdetails); context.SaveChanges(); } catch (System.Exception e) { throw new Exception(e.Message); } }
public IActionResult Post([FromBody] Roomdetails roomdetails) { try { pokerDAO.insertIntoRoomDetails(roomdetails); return(Ok(new { message = "Room is Joined - Room Id : " + roomdetails.RoomId + " and Host Id : " + roomdetails.EmpId })); } catch (System.Exception e) { return(NotFound(new { message = e.Message })); } }