public async Task <SaveTypeOfRoomServiceRes> Delete(int id)
        {
            var result = new SaveTypeOfRoomServiceRes()
            {
                Id      = 0,
                Message = "Đã xảy ra sự cố, vui lòng liên hệ với quản trị viên."
            };

            try
            {
                DynamicParameters parameters = new DynamicParameters();
                parameters.Add("@Id", id);

                result = await SqlMapper.QueryFirstOrDefaultAsync <SaveTypeOfRoomServiceRes>(cnn : connection,
                                                                                             sql : "sp_DeleteTypeOfRoomService",
                                                                                             param : parameters,
                                                                                             commandType : CommandType.StoredProcedure);

                return(result);
            }
            catch (Exception)
            {
                return(result);
            }
        }
        public async Task <SaveTypeOfRoomServiceRes> Save(SaveTypeOfRoomServiceReq saveType)
        {
            SaveTypeOfRoomServiceRes Result = new SaveTypeOfRoomServiceRes();

            try
            {
                DynamicParameters parameters = new DynamicParameters();
                parameters.Add("@Id", saveType.Id);
                parameters.Add("@ServiceId", saveType.ServiceId);
                parameters.Add("@TypeOfRoomId", saveType.TypeOfRoomId);


                Result = await SqlMapper.QueryFirstOrDefaultAsync <SaveTypeOfRoomServiceRes>(cnn : connection,
                                                                                             sql : "sp_SaveTypeOfRoomService",
                                                                                             param : parameters,
                                                                                             commandType : CommandType.StoredProcedure);

                return(Result);
            }
            catch (Exception)
            {
                return(Result);
            }
        }